1. Forum
  2. Usenet
  3. COMP.LANG.CLARION

  • how to connect to mssql with different port

    From Joep Borghans@21:1/5 to All on Mon Jan 28 01:05:12 2019
    Hi all,

    I'm using clarion 10 with the mssql driver.
    Recently a big customer asked me to connect to the database through a different port.
    My owner string looks like this:
    Owner(server,database,user,password)
    Who knows where to put the port in the connectstring?
    If I put it after the server and comma seperated the entry got mixed up.

    Kind Regards,
    Joep

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Joep Borghans@21:1/5 to All on Mon Jan 28 02:52:39 2019
    Op maandag 28 januari 2019 10:05:13 UTC+1 schreef Joep Borghans:
    Hi all,

    I'm using clarion 10 with the mssql driver.
    Recently a big customer asked me to connect to the database through a different port.
    My owner string looks like this:
    Owner(server,database,user,password)
    Who knows where to put the port in the connectstring?
    If I put it after the server and comma seperated the entry got mixed up.

    Kind Regards,
    Joep

    I already found how to add a port to my connectstring.
    It actually should be ("server,port",database,user,password)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Joe Drive@21:1/5 to Joep Borghans on Mon Jan 28 20:53:59 2019
    On Monday, January 28, 2019 at 5:52:40 PM UTC+7, Joep Borghans wrote:
    Op maandag 28 januari 2019 10:05:13 UTC+1 schreef Joep Borghans:
    Hi all,

    I'm using clarion 10 with the mssql driver.
    Recently a big customer asked me to connect to the database through a different port.
    My owner string looks like this:
    Owner(server,database,user,password)
    Who knows where to put the port in the connectstring?
    If I put it after the server and comma seperated the entry got mixed up.

    Kind Regards,
    Joep

    I already found how to add a port to my connectstring.
    It actually should be ("server,port",database,user,password)

    great...

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)