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.
 

Paszt

Staff member
Joined
Jun 3, 2004
Messages
1,500
Location
Raleigh, NC - USA
Programming Experience
Beginner
The connection string is dependent upon the type of dataSource and the connection settings you want to use.

Check out ConnectionStrings.com for examples for many different types of dataSources.
 
Top Bottom