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 derfloh 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
Joined
Oct 31, 2000
Messages
26
Location
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 Question
Adobe SDK
Replies
6
Views
497
Swi
Swi
sal21
  • Locked
  • Question Question
MULTI connection to use the same report1.rpt
Replies
2
Views
360
Andrzejek
Andrzejek
AncientTiger
  • Locked
  • Question Question
Working with Access databases on network drive with "shaky" connection issues
Replies
3
Views
391
strongm
strongm
Swi
  • Locked
  • Question Question
Reading Tab Delimited File Using ADO
2
Replies
20
Views
2K
Swi
Swi
TGrahmann
  • Locked
  • Question Question
Public MySQL Connection
Replies
5
Views
648
JRB-Bldr
JRB-Bldr

Part and Inventory Search

Sponsor

Back
Top