Connecting a SQL server via ODBC 1

[LearningVB]

Hello,

I am trying to learn this (for me) cryptic subject called Visual Basic.

And now I am woundering how to access a database lacated on an SQL server. I have configured an user DSN and here the databaseconnection vent vell.

And here it all stops.........

How can I use this DSN at the best way in my Application? I have tryed to use the data envirement but here it all stopps I am not able to access my database.

Anyone who can give me an explonation of the best way to connect to an sql-database?

Ed

 

[AndyDuke]

Try something like this,

dim objConn = ADODB.Connection
Set objConn = New ADODB.Connection
objConn .ConnectionString = "PROVIDER=MSDASQL;DSN=DSNName;UID=sa;Password=;"
objConn .Open

Just replace DSNName in the connection string with your DSN Name.

Andy