Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rb112978
Starting Member
11 Posts |
 Posted - 2005-06-10 : 04:29:55
|
| 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 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-06-10 : 04:34:09
|
try:SQLConn="Data Source=190.190.200.100:1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"Go with the flow & have fun! Else fight the flow  |
 |
|
|
rb112978
Starting Member
11 Posts |
Posted - 2005-06-10 : 05:30:52
|
| I mean like this, how do I configure an ODBC-DSN on my desktop by putting in the IP address of myserver which is at my ISP who's hosting my web site and connect to the SQLServer DB on that server from MS Access in my office. Assume I have rightsto get into that box.As I said, My app is behaving badly when using connectionstring or I go DSN Less Connection.Proud to be Pinoy |
|
|
|
|
|
|
Help Configuring ODBC (DSN)