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!

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

ADO Connection

Status
Not open for further replies.
JMTS

JMTS

Programmer
Oct 31, 2000
26
0
0
US
Does anyone know how to set up ADO using a trusted connection?
 
Sort by date Sort by votes

Just add "Trusted_Connection=yes" to your ConnectionString
Code: 
'(SQL Server)
ConnectionString = "Provider=SQLOLEDB;server=MySrv;initial catalog=MyDB;Trusted_Connection=yes"
Mark
 
Upvote 0 Downvote
Thanks! Do you know of any good documentation on the different parameters that can be used in a connection string?
 
Upvote 0 Downvote
The VB6 help should be good. You will get it from the VB6 IDE.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Adobe SDK
Replies
6
Views
77
Swi
Swi
sal21
  • Locked
  • Question
MULTI connection to use the same report1.rpt
Replies
2
Views
38
Andrzejek
Andrzejek
AncientTiger
  • Locked
  • Question
Working with Access databases on network drive with "shaky" connection issues
Replies
3
Views
58
strongm
strongm
Swi
  • Locked
  • Question
Reading Tab Delimited File Using ADO 1
2
Replies
20
Views
181
Swi
Swi
TGrahmann
  • Locked
  • Question
Public MySQL Connection
Replies
5
Views
72
JRB-Bldr
JRB-Bldr

Part and Inventory Search

Sponsor

Back
Top