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 strongm 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
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
134
Swi
Swi
sal21
  • Locked
  • Question
MULTI connection to use the same report1.rpt
Replies
2
Views
64
Andrzejek
Andrzejek
AncientTiger
  • Locked
  • Question
Working with Access databases on network drive with "shaky" connection issues
Replies
3
Views
99
strongm
strongm
Swi
  • Locked
  • Question
Reading Tab Delimited File Using ADO 1
2
Replies
20
Views
297
Swi
Swi
TGrahmann
  • Locked
  • Question
Public MySQL Connection
Replies
5
Views
140
JRB-Bldr
JRB-Bldr

Part and Inventory Search

Sponsor

Back
Top