problems with port in connections (in ASP)

[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=test02x2;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
fine.

 

[Ray Costanzo [MVP]]

Can you post your actual code? It appears you retyped it since your string
doesn't have quotes around it, and your variable names differ. Also, what
version of MDAC?

Ray at work

 

[Kyle Peterson]

try data source, then a comma, port number

that is how I do it

get rid of the port= stuff