ODBC connection to remote computer giving invalid instance() message

I am trying to set up a ODBC connection to a remote database using the ODBC data source administrator. I am getting an error message complaining of an invalid instance(). The database I am trying to connect to does have a default instance and a named instance. Do I need to specify the instance name somewhere in the connection settings? I tried specifying the server name as <Remote computer IP Address>/<Instance Name> but this didn't work. Any ideas?Hi,

make sure SQL Server Browser is running, otherwise you will have to name the port after the service name like in:

Data Source=Servername,SomePortnumber --> Data Source=SomeServer,1455 (e.g. for any non-default port settings)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Note that it should be "<Remote computer IP Address>\<Instance Name>" rather than "<Remote computer IP Address>/<Instance Name>".

Can you connect to the default instance? What protocols are enabled? What's the actual error msg? Any firewall issue? Search firewall and browser posts on the forum would help.

|||Thanks for ideas. I think I needed to sleep on this one a bit! I looked at it again this morning and unticked the 'dynamically determine port' option in the network lib config of the ODBC connection setup and specified the port no. the instance is listening on. This worked!