Missing Native SQL Server Connection

[skuhlman]

I've got Cryatal 9.0 and SQL Server 2000. I can't find the Native SQL Server Connection in my crystal list anywhere. I did have it in my Crystal 8.5 list.

I'm looking under
Connections
Create New Connection
More Data Sources
ODBC(RDO)

Do I have to reinstall something? Or possibly a setting I'm missing?

Thanks for your help.

 

[craigber]

Do you have the DSN setup under Windows ODBC manager?

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"

 

[skuhlman]

Craig, Here's what I'm trying to do and what I've found out so far:

The people at Crystal have told me that Crystal 9.0 does not support a native SQL Server connection even though 8.5 did.

In 8.5 I was using the native SQL Server connection. I'd select my Stored Procedure as the data source. Then I'd strip the database.owner. off of that text string. Within my code I'd do a LogOnServer("PDSSQL.DLL","MyServer","MyDB","MyUser","MyPassword&quot and the report would work for any database on any server (all having the same SP). These reports convert up to CR9 fine and run correctly through my code. The problem is that all of my new reports must be created in 8.5 and then converted to 9 using this method.

My Goals:
1) I do NOT want to create and maintain DSN connections for each server on all of the PCs running this application.
2) I need to be able to switch data sources for the reports within my application.

Crystal has suggested that I use the OLE DB (ADO) connection and the CRDB_ADO.DLL.

I have your book and I'm trying to figure things out in Chapter 9 (pg 197).

Here is the relavent code:

.oCrystal = CREATEOBJECT("CrystalRuntime.Application.9&quot
.oReport = .oCrystal.OpenReport(tcReport)
.oReport.LogOnServer("crdb_ado.dll","MyServer","MyDB","MyUser","MyPassword&quot

I'm getting an error message:
OLE error code 0x80020006: Unknown Name

Any suggestions?