Connect to MS SQL with different Port

[Till Dreier]

I’m trying to access a MS SQL Server database with host, instance and port.

Normally the connection string looks “hostinstance@database” or “host@database” as I can’t use the standard port I tried to use “host:portinstance”, “host:portinstance@database” and a lot of other combinations. But I always get the error:

08001 [DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.

OR

08001 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Does someone know how to solve this issue?

[Alfred]

The E2E Runtime uses the library SQLAPI++ for database access. For access to SQL Server our SQLAPI++ version uses as default OLE DB interface. If you access SQL Server 2005 or newer you can use this connection string:
   tcp:<servername>[<instancename>][,<port>][@<database name>]

I use e.g. this connection string: tcp:sqlserver.e2e.ch,1433@e2eRegTest

More information about SQLAPI connection string http://sqlapi.com/ServerSpecific/SQLServer_OleDb.html

[Till Dreier]

Thanks for your help. It’s working perfectly now.

[Author]

Posts