ODBC RDO

[junction123]

Hi

I am using CE 9 and the SQL 7.x. I open a report originally created in Crystal 7.0 and saved it. Now when I run the report I get an ODBC RDO window.

I do have the SQL drivers installed. I tried to configure the DSN but I do not see the SQL server in the drop down list to connect to.

In the past I have created/run reports that run against procedures in Sybase 12.x but for SQL server this is the first one.

Is this an ODBC configuration issue?

Thanks
junction123

 

[synapsevampire]

Go into Control Panel and try creating the SQL Server ODBC Source with the same name.

Open the report in CR 9 and select Database->Verify Database

-k

 

[junction123]

Great! That worked. Now when I schedule the report on CMC (Crystal 9), using SQL server, under the Database Tab, I choose :

Use Original Database Logon information from the report.

For some reason the database field is blank. The server name is shown.

For eg:

Server: stintldb
Database:
User: xyz
Pasword: ********

Why is this so? Is there something I need to fix in the report itself? Previously I have used Sybase server and did not encounter any problems. This is the first report that uses a procedure on SQL server.

Thanks
junction123