bildwelt
E2E FORUM
E2E Bridge E2E Commerce

Connect to MS SQL with different Port

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

This topic contains 2 replies, has 2 voices, and was last updated by  Till Dreier 4 years, 1 month ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #726

    Till Dreier
    Participant

    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?

    #727

    Alfred
    Moderator

    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

    #728

    Till Dreier
    Participant

    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.