error using the port in connection string

[Kavi]

Hi all

i'm new to this, your assistence will be greatly appriated


i have a connection string (this all in asp )


tCSCst = Provider=SQLOLEDB;Data Source=<bd>;Port=1444;Initial
Catalog=<cataloge>;User ID=<id>;Password=<password>


Set testCaseServerConn = Server.CreateObject("ADODB.Connection")
testCaseServerConn.Open tCSCstr


but i get the following error


An error occured:-2147467259 - Invalid connection string attribute


the problem seems to be the port itself, if i use 1433 then it works

 

[Bob Barrows [MVP]]

Hi all

i'm new to this, your assistence will be greatly appriated


i have a connection string (this all in asp )


tCSCst = Provider=SQLOLEDB;Data Source=<bd>;Port=1444;Initial
Catalog=<cataloge>;User ID=<id>;Password=<password>


Set testCaseServerConn = Server.CreateObject("ADODB.Connection")
testCaseServerConn.Open tCSCstr


but i get the following error


An error occured:-2147467259 - Invalid connection string attribute


the problem seems to be the port itself, if i use 1433 then it works

I don't see the "Port" keyword supported in any documentation I've read.
According to http://www.connectionstrings.com/, this is how to specify a
specific port:

"Provider=sqloledb;Data Source=190.190.200.100,1433;Network
Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

Of course, nobody is suggesting that you should use the sa account - I am
assuming they used it for the sake of the example. I am going to give them
some feedback about this...