Opening Connection to Database

ryodoan

Well-known member
Joined
Jul 16, 2004
Messages
65
Location
Ohio
Programming Experience
3-5
Ok, I just did this at my school a while ago, but I have totaly forgotten how I did it... heh...

I remember how to code everything, but I forgot how to get the connection string...

For example.

Dim myDBConn As SqlClient.SqlConnection

Dim myConnection as string= "UID=school;PWD=password;DATABASE=School;WSID=L132DG301;APP=Microsoft Open Database Connectivity;Server=ElderSQL"

myDBConn.Open()
Dim _dt As New DataTable

I cant remember how we got the myConnection (the string)...

If anyone has any suggestions for a method to make a connection to a database, it doesnt have to be the above way, and anyhelp would be much appreciated.
 
Top Bottom