how do I connect to a sql db 1

[jeffmoore]

I have been to

http://www.connectionstrings.com

and the code doesn't work!!!

The Imports line give me an error....

And I am assuming that this is my connectionstring:

"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

if so why is the 3rd line below spelled:
"my connectionstring"
and not
myconnectionstring
no space and no quotes ??

Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connectionstring"
oSQLConn.Open()


thanks
jeff

 

[dace]

You need the ConnectionString property to be set to the actual connection string, either directly or as a variable.
so:

Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
oSQLConn.Open() 

'or

Dim MyConnectionString As String = "DataSource=Aron1;Initial Catalog=pubs;UserId=sa;Password=asdasd;"
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString= MyConnectionString
oSQLConn.Open()

 

[jeffmoore]

okay I pasted the first three lines of your cod in and ....

SqlConnection is not defined .....

the same thing happens with all the code samples from microsoft .... what an i missing???

tia
jeff

 

[dace]

Make sure you still import the System.Data.SqlClient namespace.

 

[jeffmoore]

how do i do that?
I'm a newbie at this so bear with all the dumb questions...

jeff

 

[dace]

No worries

You import namespaces by using

Imports System.Data.SqlClient

at the top of your class. This saves you from having to fully qualify each of your objects, i.e.:

Dim oSQLConn As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection()
[code]

 

[jeffmoore]

Okay thanks .... my problem was I put the imports stmt below (inside) the class stmt NOT on the first line of code
Thanks ....


I'll be back !!!!
Jeff

 

[jeffmoore]

In this connection string :

oSQLConn.ConnectionString="Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

what is the data source supposed to point at?
this connection string was copied from an example. and I dont know what "aron1" is

thanks
jeff

 

[dace]

I assume that's for a DSN that was set up in the example. An easier (and more portable) way would be to use:
"Initial Catalog=pubs;Data Source=INSERT_SERVER_NAME_HERE;User Id=sa;Password=asdasd;"
for a connection string, and make replace INSERT_SERVER_NAME_HERE with the name of the SQL server instance (probably the computer name it's hosted on).

 

[jeffmoore]

that works thanks

 

[dace]

nothing says thanks like a star

 

[jeffmoore]

got ya