Error "Logon Fail" with crystal repor 11 and sql native language

Hi, I am using VB6 and sometimes when I try to display a report using cristal report 11 , I get this error "Logon Fail", I am working with SQL 2005 ENTERPRISE EDITION.

I want to know if I need an aditional configuration or something like that.

Thank you.

There should be a more datiled error message with the error number and state which explains why the logon failed.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error "Physical Databasew not found" :-(

Hi out there,

I've created some Crystal Reports in a VB Application. Everything works fine on my comnputer.
The application is installed on several other clients, and on some other machines the reoprts do not work, CR generates an error "Physical Database not found".
On the Crystal Reports homepage several articles are given to solve this poblem, but unfortunately nothing helps.

I've done the foolowing things trying to fix the problem:
- distributing the files given in the knowledgebase with the setup
- Unsetting the "Use indexes for speed" option in the CR object
- Setting the "discard saved data" option in the CR Object

Is there any other thing I can do to try to make the CR work?

System-Environment is CR85, database Background is SQL-Server2k, ADO-Version is 2.8"Physical Database not found"

Obviously ur link 2 Db is broken. Did u check SQL client configurations. U should be using ODBC like connection, if u give a direct link to Db in CR, u should expect this problem.|||Hi Janitha,

no it's quite clear that this can't be the problem as the reports are running correctly on some machines. As the database is on sql-Server (and I'm using the sql-Server-driver, no odbc), if the connection would not be initialized correctly the reports would not run on any client.|||Hi out there,

seems that it is a network (and possibly permission of user) problem.
The setup referred to a folder on the intranet of the company, where the app was located. When I changed the link in the setup back to a local installation, everything works :-)

Error "Failed to Export the Report"

Using Crystal Reports 8.5, RDC, VB6, Win2k for both Dev and client

I'm trying to export a report to pdf, but keep getting:

Error -2147190908 (80047784) "Failed to Export the Report"

It exports fine on my Dev machine, but not on the client machine. I've earched the internet high and low for the answer. The only thing I found was a missing or incorrectly registered ExportModellar.dll and crtslv.dll. I verified that both of those files as well as the correct Destination and ExportType dlls are installed and registered properly. I even reinstalled CR 8.5 on that machine! I have no idea what to try next!

I even downloaded Crystal's Modules utility that supposed to tell you the differences between the dlls being used on 2 different machines. ExportModellar was version 8.5 on the client machine and version 9.1 on my machine, so I upgraded ExportModellar to 9.1 on the client machine, but it didn't help.

Any thoughts would be greatly appreciated!

Thanks in advance.^^^
I have the exact same problem but am using crystal 7 on windows server 2003
Everything seems fine on my machine but not on the client machines.
did you manage to solve this problem, or does any1 have any ideas?|||I finally did get it to work. I ended up downloading a hotfix and installing it on that machine. I still don't know what file was messed up.

Good luck and sorry I couldn't be of any more help!

Malleyo|||sorry to ask another question but what hot fix did you download and where did you get it from?
thanks in advance|||I don't remember which hotfix I used. Try searching Crystal Reports website:
http://support.businessobjects.com/search/advsearch.asp|||I don't remember which hotfix I used. Try searching Crystal Reports website:
http://support.businessobjects.com/search/advsearch.asp
I had the same problem. The hotfix can be found at http://support.businessobjects.com/communityCS/FilesAndUpdates/dbexdrvrwin_en.zip.asp

Roy DeWitt|||I am haing the same problem but the patch did not fix the problem...does anyone have any other ideas? We are running Crystal Report 7 on 2003 operating system.|||For this type of problems you need to make sure that the system is updated with latest patches if any

error

what is max size for a string field in latest crystal report?. can it get increased?.I don't think there is any limitation in the crystal. But there is a limitation in UFL's or Function if there return type is string then they can only return maximum 256 character.

Does any body else has idea about this ?

Error

Hello,

Following is the code written to call a crystal report having records for branch 3 only:

Dim appl As New CRAXDRT.Application
Dim rpt As New CRAXDRT.Report
Dim dat As CRAXDRT.Database

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set rpt = appl.OpenReport(app.path & "\password.rpt", 1)

Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open "dsn=invdet"
rs.Open "select * from table1 where branch=3", cn, adOpenStatic, adLockPessimistic

Set dat = rpt.Database
dat.SetDataSource rs, 3, 1
CR.ReportSource = rpt
CR.ViewReport

Error:

The Report shows all the records from "table1". It resembles the same report when I run from Crystal Reports.

i.e. it is not reporting for the above recordset set.My changes are in Bold.

'Get rid of these
'Dim appl As New CRAXDRT.Application
'Dim rpt As New CRAXDRT.Report
'Dim dat As CRAXDRT.Database

Dim Report as CrystalReport1 'This is the dsr file that you create

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set rpt = appl.OpenReport(app.path & "\password.rpt", 1)

Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open "dsn=invdet"
rs.Open "select * from table1 where branch=3", cn, adOpenStatic, adLockPessimistic

Report.SetDataSource rs, 3, 1
'Make sure CR is the name of the CrystalViewer on your form
CR.ReportSource = Report
CR.ViewReport|||I do not know how to create the dsr file|||What version of Crystal Reports are you using?|||I am using version 8.5|||I'm using version 8.5 Developer Edition. When I installed it, it placed all the necessary dlls on my comuter for me.

To create a dsr file, All I have to do is click 'Project', 'Add Crystal Reports 8.5'. Then follow the directions to create a dsr file.