OLE Db and SQL Server

[hanglam]

hi.

I'm trying to connect to SQL Server 2000 in Visual Basic by using a OLE DB Connection.

I supply the login credentials by using the following line of code:

Report.Database.LogOnServer "SQLOLEDB.DLL", "ServerName",
"Database", "user", "password"

I'm pretty sure SQLOLEDB.DLL is the dll for the SQL SErver OLE Connection.

But everytime I run my Visual Basic application, I get the following error :

"Fail to load database Information.
Details: The database DLL crdb_sqloledb.dll could not be loaded"

Can anyone tell me if I'm doing the connection right ? or is there something I'm missing ?

Thanks,

Hang

 

[hanglam]

sorry, it is SQLOLEDB.DLL . I don't know why a smily face came up in post.

Thanks,
Hang

 

[hanglam]

it is SQLOLEDB.DLL , I forgot to turn off the smiley face

Thanks,
Hang

 

[synapsevampire]

This should be of interest:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/ado_connectionmethods.zip.asp

-k

 

[hanglam]

synapsevampire, thank you fro the repply.
Is there a way to set up the connection from Crystal Report in Visual Basic to a SQL Server without having to use the DataEnvironment object in Visual Basic ?

Thanks,
Hang