Crystal Reports connection to a Bugzilla MySQL database - problem with links.

I'm trying to set up Crystal Reports with an ODBC connection to Bugzilla which I know works.

It is crashing if I add more than one table - either if I click on Links or OK.

Do I need to give the user any extra priveledges to see links between tables. Are there links between tables in the MySQL database in the same way you would see in a SQL Server database?

I've done searches such as:
bugzilla odbc links
and
mysql odbc links

but I didn't find anything...

Thanks for your help,

JamesNobody got any idea what I might be doing wrong? My MySQL server is on a Linux Fedora Core 5 machine if that helps...|||It could be smart linking.
Try 'File' menu, 'Options', 'Database' tab, uncheck 'Automatic Smart Linking' at the bottom of the 'Advanced Options' section.|||It could be smart linking.
Try 'File' menu, 'Options', 'Database' tab, uncheck 'Automatic Smart Linking' at the bottom of the 'Advanced Options' section.
I don't have an 'Automatic Smart Linking' option, I'm using Crystal Reports 9.2.0.448

crystal report connection problem

dear respected members of this forum, i really need your help desperately. i have developed a system using asp, oracle as the database and i used crystal report for web reporting site. i developed this system using my pc which using windows 2000 advanced server as the OS. After completed the system i have copied the program to my office main server which is using windows 2000 server as the OS. now after installed to the server,generally the system is working. But once click to connect to crytal report which is the report generation part the error below showed:-

clientdoc.dll error '80041015'

Failed to connect to server "ISIS". Error returned from Windows Sockets API : 0.

/semak/pass_para.asp, line 125

have any of u come a cross this kind of problem. when i run the same system from my pc its working without any error. but when i install to server and try to access from there then only the problem started.there is no one at my place to help. i am really looking forward to get your reply soon. cuz users are going to use the system start from next week....thanks in advance[ Moved thread ]|||Hi madhavibaskaran, Open the report in the server and goto Database>Set Database Location. Now try to configure the database location after that click verify database. Which version of CR are you using?

Madhivanan|||Hi,

This error message appears because the Crystal Report Application Server Service is not running.

To resolve this error message, turn on this service using the following steps:

1. Go to Start > Control Panel > Administrative Tools > Services.

2. Right-click the 'Crystal Report Application Server' Service and click 'Start'.

dear respected members of this forum, i really need your help desperately. i have developed a system using asp, oracle as the database and i used crystal report for web reporting site. i developed this system using my pc which using windows 2000 advanced server as the OS. After completed the system i have copied the program to my office main server which is using windows 2000 server as the OS. now after installed to the server,generally the system is working. But once click to connect to crytal report which is the report generation part the error below showed:-

clientdoc.dll error '80041015'

Failed to connect to server "ISIS". Error returned from Windows Sockets API : 0.

/semak/pass_para.asp, line 125

have any of u come a cross this kind of problem. when i run the same system from my pc its working without any error. but when i install to server and try to access from there then only the problem started.there is no one at my place to help. i am really looking forward to get your reply soon. cuz users are going to use the system start from next week....thanks in advance|||i am using cr enterprise 9 mr madhi.

Hi madhavibaskaran, Open the report in the server and goto Database>Set Database Location. Now try to configure the database location after that click verify database. Which version of CR are you using?

Madhivanan

crystal report and oracle?

I have a little VB.net web application which connects to Oracle using ADO.NET so i make connection

Dim Oraclecon As OleDbConnection = New OleDbConnection("Provider=MSDAORA.1;Data Source=name;Password=pass;User ID=name;")

and all work good till i try to use crystal report. it generate exception(it happens when i do report.export) "CrystalDecisions.CrystalReports.Engine.LogOnException: logon failed".
in msdn i found article "Accessing Secure Databases" with such a code

' Declare require variables.
Dim logOnInfo As New TableLogOnInfo()
Dim i As Integer

' Loop through every table in the report.
For i = 0 To report.Database.Tables.Count - 1
' Set the connection information for current table.
logOnInfo.ConnectionInfo.ServerName = serverNameTxt.Text
logOnInfo.ConnectionInfo.DatabaseName = dbNameTxt.Text
logOnInfo.ConnectionInfo.UserID = userNameTxt.Text
logOnInfo.ConnectionInfo.Password = passwordTxt.Text
report.Database.Tables.Item(i).ApplyLogOnInfo(logOnInfo)
Next i

i suppose servername parameter should be equal Data Source in connection string and DatabaseName should be empty but it still don't work. and frankly speaking i don't understand why crystal report should know logon information if i use in my report ado.net dataset as data source and make connection to oracle through ado.net technology. why should i logon twice?? so if someone had such problems please help any advice will be usefulHi,

Maybe this can help you because I also use Oracle under SCO UNIX and works for me.

1. You need to have a CrystalReport control in your form.
2. Assign to that control a name (myControl, v.g.).
3. Declare two strings variables (strSQL and strCon, v.g.).
4. Make your SQL sentence for criteria that will be throw to Crystal Reports.
Example:

strSQL = "{mytable.cycle} = 2004"

This line will added to the SQL sentence formed by Crystal Reports when you make your report. Note: this can be optional.


5. Connection for Crystal Reports. This example applies to Oracle where server is a service name made with Easy Configuration of your Oracle Client software.
strCon = "DSN =server;UID=user;PWD=password;"

User: user of Oracle
Password: which is necessary to connect to Oracle

6. Finally, properties to connect to Crystal Reports and view your report.


myControl.ReportFileName = app.path & "\Test.rpt"
myControl.Connect = strCon
myControl.SelectionFormula = strSQL
myControl.Action = 1

I hope this can serve you.

Xernai.

Crystal Reoprt Connection

Attention Ashish Seth, Hyderabad...

I'm new in C/Reports..I'm developint a project using Orale 8i, VB 6.0 and C/Reports 7.0..So my paltform is almost same with U..As you found the error"server has not yet been open" I also am facing an error and I could not come out of that my error is
-Error number 20599 "SQL Server can not open"
As I'm not using SQL Server, why this error is then...Someone has told me that I've to connect to report by coding, which I didn't do..Can You just help me as your prob is a bit similar to mine...[Moved thread]|||I've come across similar problems where I get a SQL server error and my report doesn't connect to the database itself (I connect to the database in VB and pass the report a recordset). It turned out that it was a version incompatibility between some of my dlls. Check the version of all your dlls.|||You need to add following code into your preview window
'-----------------
'General Declaration
Dim crApplication As New CRAXDRT.Application

'Form Load
Set crApplication = CreateObject("CRYSTALRUNTIME.APPLICATION")
crApplication.LogOnServer "pdsmon.dll", "", sDatabase, sUid, sPwd

sdatabase = <databse name>
sUid = User Name
sPwd = Password

use pdsmon.dll when you created report via ado connection
use pdsodbc.dll when you created report via odbc connection

This will really help you

Sikander

Crystal 4.6 connection to Access 2000?

I have a VB6 package that uses CR 4.6 and has installed successfully on numerous PCs under all versions of Windows (97 to XP).
Now I when I run the package on my new laptop and try to print a report, I get error error 2147417848 - disconnected from client.
Moreover, although the CR report designer recognises the rpt files, the preview window gives an error. I'm assuming connecting to the database is the problem. The new laptop has no problem with any other software or with printing in general.
I have tried re-installing VB6 and Crystal Reports, re-registering crystl32.ocx, tried the Dependency Walker from Crystal, spent hours trawling the web, all to no avail.
Any bright ideas out there?Are you able to open the report?
Do verify database

CryptoAPI function 'CryptAcquireContext' failed

Hi,
I am receiving the following error after installing MSDE
on a machine with NT 4.0 SP6a:
MSSQL Server logon. Connection failed. SQL State 42000 SQL
Server error 552
[Microsoft][ODBC SQL Server Driver][SQL Server]CryptoAPI
function 'CryptAcquireContext' failed.
Error 0x8009001d: Provider DLL failed to initialize
correctly.
I have found the following KB article which addresses
this, but don't know how to sign on to the server using
sysadmin login.
http://support.microsoft.com/default.aspx?scid=%
2Fservicedesks%2Fbin%2Fkbsearch.asp%3FArticle%3D32 1459
If anyone has seen this before would be very interested to
hear.
Many thanks,
Mark.
Yep... I've had this problem - or rather a customer 4000 miles away did.
As we were unwilling to advise the customer to do the fix - as we'd be the
ones responsible for 'trashing the machine' if it went wrong, we gave the
customer a link to the article. They didn't fancy doing it, their IT
looked at it and did not want to do the BOOT.INI thing either.
They upgraded subsequently to Win2K, bringing forward that users upgrade
window.