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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

connect method

Status
Not open for further replies.

elabidi

Programmer
Apr 5, 2002
7
TN
Plz complete way to use ocx .connect method from vb.
.connect= DSN = server name;UID = userID;PWD = password;DSQ =database qualifier
didn't work.
is there any configuration?
 
I put my connection information into a text box.

then passed that to the .connect property

The minimum is...
.connect="DSN=myodbc;uid=me;pwd=mypassword;"

if no password, then pwd=; is required.
Is the ODBC set up correctly?
Has the client been loaded?
What data source are you using?
Editor and Publisher of Crystal Clear
 
Plz complete way to use ocx .connect method from vb.
.connect= DSN = server name;UID = userID;PWD = password;DSQ =database qualifier
didn't work.
is there any configuration?
Is ODBC necessary, Iwould like to use native connection (oledb) to sql server.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top