E2E Bridge E2E Commerce

Connect to MS SQL with different Port

E2E Forum Modeling & Development Connect to MS SQL with different Port

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #726
    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.


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

    Does someone know how to solve this issue?


    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.

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.