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]]

Kavi wrote:

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...

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"