Guest D V Knight Posted October 11, 2019 Posted October 11, 2019 Hi, 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... Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.