I am trying to create a SQL Server 2000 and 2005-friendly connection
string that will allow me to connect to a named instance on a
non-standard port. I can't get the syntax right, can anyone show an
example?
Thanks.For data source, use YourServer\YourNamedInstance then a
comma followed by the port number - e.g.
Data Source=YourServer\NamedInstance,1433;
-Sue
On 23 Mar 2006 06:38:16 -0800, bradwiseathome@.hotmail.com
wrote:
>I am trying to create a SQL Server 2000 and 2005-friendly connection
>string that will allow me to connect to a named instance on a
>non-standard port. I can't get the syntax right, can anyone show an
>example?
>Thanks.
Saturday, February 25, 2012
Connection String with Named Instance and Port?
Labels:
2005-friendly,
connect,
connection,
create,
database,
instance,
microsoft,
mysql,
named,
non-standard,
oracle,
port,
server,
sql,
string
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment