sql server connect: Can not connect to SQL over internet connection -- sql server connect

Can not connect to SQL over internet connection

brian
11/5/2003 7:46:55 AM

sql server connect:

I am having trouble connecting to an sql server over my
internet connection on a LAN. I have set up DSN on the
server, ( do I set a DSN server name on the client as
well?). I can connect using a dial-up connection with
this code but when I use my ISDN internet service, I have
no luck.
I am programming in VB and this is the code I am using
Set cnn1 = New ADODB.Connection

strCnn = "Provider=sqloledb;" & _
"Data Source=sql7.hostbasket.com;Initial
Catalog=mydatabase;User Id=myusername;Password=my
password;"
cnn1.Open strCnn

'' This is were the error occurs [Microsft][ODBC SQL

Re: Can not connect to SQL over internet connection

Steve Thompson
11/5/2003 3:31:42 PM

You should be able to connect with a DSN-less connection. It is likely we
are dealing with a name resolution issue, in your connection string
substitute the IP address for the UNC.

Steve
[quoted text, click to view]