ODBC connection to SQL Server


D V Knight


My client insists I establish an ODBC connection to SQL Server using SERVER=IPaddress in the connection string, when developing an Access interface using linked tables. I have been able to set up a User DSN via ODBC Administrator, setting the SERVER=IPaddress.

However what if the computer's IP address changes? Then the connection will fail, is that correct?

Is it possible to automatically reset the DSN Server IPaddress?

How do I know if the IPaddress is Dynamic or Static?

Another question is: why can't I set the SERVER=IP (Gateway) address to connect to the Server?

I hope this question is clear enough.

I am afraid that although I am competent with VBA, I know very little about networks, TCP/IP etc

Thank you

D V Knight

Continue reading...
Top Bottom