January 4, 2005 at 9:40 am
Does anyone have any idea why when I specify the actual Server Name in my DSN it'll allow me to create multiple connections to my SQL Server using a variety of logins. But, when I specify the Server I.P. address I can only create one connection with my DSN, if I try and create any more I get this error:
Connection Failed
SQL State: '0100o'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpnen (Invalid Instance()).
Thanks in advance.
Adam
January 5, 2005 at 8:42 am
Are you attempting to connect to a named instance? It could be a case of not including the instance name when attempting the connection through the IP, this is especially true if the machines are on seperate subnets.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply