The connection string I am using is like follows:
"Provider=SQLOLEDB.1;Server=123.456.78.9;Initial Catalog=db;User
ID=userid;password=password"

Is there a way to change the port number that the server is accessed on? The
server is not using the standard 1433 port number. I cannot use a DSN. 

I have also used: 
"Driver={SQL Server};Server=123.456.78.9;Database=db;UID=;pwd="

Same thing for that connection as well. 

Thanks!

Brandon Ludwig
Brandon.Ludwig@M...

I haven't tried this BUT the standard way to connect to a web browser on a
different port is to place a ":" and the port number after the IP address. I
think this is standard for TCP/IP so I would try something like this,
assuming your server was on port 8080:-
"Provider=SQLOLEDB.1;Server=123.456.78.9:8080;Initial Catalog=db;User
ID=userid;password=password"


HTH

Mark Anderson
01202 775483
07802 404838 mob
Web Development and database design
mailto:mark@a...
http://www.anderson.uk.com
-----Original Message-----
From: Ludwig Brandon-FBL017 [mailto:Brandon.Ludwig@m...]
Sent: 20 August 2002 21:14
To: ASP Databases
Subject: [asp_databases] Different port with DSNless SQL connection


The connection string I am using is like follows:
"Provider=SQLOLEDB.1;Server=123.456.78.9;Initial Catalog=db;User
ID=userid;password=password"

Is there a way to change the port number that the server is accessed on? The
server is not using the standard 1433 port number. I cannot use a DSN.

I have also used:
"Driver={SQL Server};Server=123.456.78.9;Database=db;UID=;pwd="

Same thing for that connection as well.

Thanks!

Brandon Ludwig
Brandon.Ludwig@M...