Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database Acces with VB 6.0 and CR 10.0

Status
Not open for further replies.

bidra

Programmer
Feb 28, 2002
31
0
0
DE
Hi,

I am using a VB application calling CR reports . I want to use the OLE DB(ADO) database connection but don't know how to pass the logon parameters. How do I have to pass the logon parameters.
------------------------------
With ODBC it was
Report.Database.Tables.Item(1).SetLogOnInfo
"DSN-servername", "databasename", "userid", "password"
-------------------------------

How do I have to pdo with OLE DB(ADO)?

Thanx for any Answer
 
SetLogOnInfo is 'deprecated', but it still works (you won't see in using Intellisense, but it's still there, and still works).

The 'new' method of setting the properties for logging in is the ConnectionProperties property bag. Here's a whitepaper that demonstrates how to use it for different connectivity:

-dave
 
Hi Dave,

thank you for the fast answer, I'll check and try.

bidra
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top