Connecting to a remote SQL database
Hey, not sure where to post it on here but sorry if it's in the wrong spot.
Anyway, I am trying to connect to a SQL database through a visual basic app.
I can't even get it to connect, any idea on what could be wrong?
It just hangs and then after a minute closes.
Here is what I have,
Code:
Dim oSqlConn As New SqlConnection
oSqlConn.ConnectionString =
"Data Source=118.139.179.54;" & _
"Initial Catalog=gunderak;" & _
"User ID=gunderak;" & _
"Password=XXXXXXXX"
oSqlConn.Open()
Cheers.
Re: Connecting to a remote SQL database
Also does anyone have any idea how to actually do query's such as insert or drop etc?