VB Forum / Database Access / September 2007

I have an app that makes a connection to an SQL database using ADODB.
I am setting the "Data Source" to be the name of the server where the
database is. This all works properly - no problems.

But, if I instead set the Data Source to be the server's IP address,
an "SQL Server does not exist..." error is generated. I have tried
several variations of the IP address (preceding it with 2 backslashes,
1 backslash, no backslashes, a trailing backslash, etc.) but can't
find anything that works.

Any suggestions as to how to get this to work?

Thanks