D
D V Knight
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...
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...