a.guelle
Posts: 97
Joined: Tue May 19, 2015 2:23 pm

[solved] Testing SQL Server connection does not check port

Tue Nov 08, 2016 10:53 am

Hi Everyone,

when I use the "Test ODBC connection" action with the SQL server driver (Driver=[\{]SQL Server[\}];Server=[SERVER_PROP];Port=[PORT_PROP];Uid=[USERNAME_PROP];Pwd=[PASSWORD_PROP];) then the connection is always tested via the instance name instead of the port. Even more, the port is ignored.

As we are using JDBC in alle further actions, we need a proper connection via port.

Is there a way to change this behaviour?

Best regards,

Angelo
Last edited by a.guelle on Wed Nov 09, 2016 9:39 am, edited 1 time in total.

mihai.petcu
Posts: 3860
Joined: Thu Aug 05, 2010 8:01 am

Re: Testing SQL Server connection does not check port

Tue Nov 08, 2016 4:00 pm

Hi Angelo,

You have the syntax wrong, as described in the How to test SQL connection parameters? article, the correct syntax is:

Code: Select all

Driver=[\{]SQL Server[\}];Server=[SERVER_PROP],[PORT_PROP];Uid=[USERNAME_PROP];Pwd=[PASSWORD_PROP];
All the best,
Mihai
Mihai Petcu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

a.guelle
Posts: 97
Joined: Tue May 19, 2015 2:23 pm

Re: Testing SQL Server connection does not check port

Wed Nov 09, 2016 9:38 am

Hi Mihai,

that was indeed the solution. Many Thanks... Where is the "I Like" button here ;) ?

Return to “Common Problems”