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

VB6 connection string using DSN

Status
Not open for further replies.
dmando84

dmando84

Programmer
Dec 28, 2005
68
US
Hello,

I am trying connect a VB6 application to SQL Server using a DSN which I created. I am having alot of problems. Any help would be appreciated.

Dave
 
Sort by date Sort by votes
You many want to try the VB forums. What code do you have so far? What are the problems you are having?


Jim
 
Upvote 0 Downvote
This is what I have so far.. but, I keep getting an error message saying that the connection string is not valid..
What is the proper syntax for this?

Thank you,
Dave



Public Sub ConnectToDatabase()
Set cnn = New ADODB.Connection
sCnn = "Provider=SQLOLEDB; Initial Catalog=DataBaseName;Data Source=DSN;"

End Sub
 
Upvote 0 Downvote
sCnn[!].ConnectionString[/!] = "Provider=SQLOLEDB; Initial Catalog=DataBaseName;Data Source=DSN;"

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
738
Auguy
Auguy
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
663
Mike Lewis
Mike Lewis
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
386
Auguy
Auguy
ahmedsa2018
  • Locked
  • Question
How to display part number based on search string by chemical id ?
Replies
3
Views
325
gmmastros
gmmastros
how2trainyourdragon
  • Locked
  • Question
SQL Server 2016 to 2019 now SSRS Cannot create a connection to data source
Replies
1
Views
479
how2trainyourdragon
how2trainyourdragon

Part and Inventory Search

Sponsor

Back
Top