Help Configuring ODBC (DSN)

reyboy · June 10th, 2005, 03:28 AM

How do we configure the ODBC to map a SQL Server using IP?

My app is going nuts if I use a DSN less connection.

'-------------
'OK
'-------------
SQLConn="DSN=MyDSNConn"
'-------------

'-------------
'NOT ok
'-------------
SQLConn="Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
'-------------

Proud To Be Pinoy

reyboy · June 10th, 2005, 04:25 AM

How can I configure an ODBC-DSN on my desktop by putting in the IP address of my
server which is at my ISP who's hosting my web site and connect to the SQL
Server DB on that server from MS Access in my office. Assume I have rights
to get into that box.

Proud To Be Pinoy