Named Instance into a IP Server

Hello,
May be my question its simple, but I don't know the answer, I need to
connect to a named instance into a Remote Server using an IP Address, how I
can do that ?
Thanks
Hi
The default instance normally listens on an IPAddress and Port 1433, so the
client resolves the name to <IPAddress>:1433
A named instance is the same, but just listens on a different port.
<IPAddress>:<configured port>
If you need to connect via an IP only, the named instance must be setup to
use a static port. Do this though enterprize manager.
e.g. In you connection string use: 192.168.10.1:5001 for a named instance on
192.168.10.1 with a static port of 5001.
Regards
Mike
"Ing. Mike" wrote:

> Hello,
> May be my question its simple, but I don't know the answer, I need to
> connect to a named instance into a Remote Server using an IP Address, how I
> can do that ?
>
> Thanks
>

Named Instance into a IP Server

Hello,
May be my question its simple, but I don't know the answer, I need to
connect to a named instance into a Remote Server using an IP Address, how I
can do that ?
ThanksHi
The default instance normally listens on an IPAddress and Port 1433, so the
client resolves the name to <IPAddress>:1433
A named instance is the same, but just listens on a different port.
<IPAddress>:<configured port>
If you need to connect via an IP only, the named instance must be setup to
use a static port. Do this though enterprize manager.
e.g. In you connection string use: 192.168.10.1:5001 for a named instance on
192.168.10.1 with a static port of 5001.
Regards
Mike
"Ing. Mike" wrote:

> Hello,
> May be my question its simple, but I don't know the answer, I need to
> connect to a named instance into a Remote Server using an IP Address, how
I
> can do that ?
>
> Thanks
>

mysql and ASP

Hi all, i've just set up an mysql server on my computer and now i want to
connect to a mysql database with an ASP page but i can't find the correct
connection string. I always get an error that the datasource can not be
found.

ConnString =
"Driver={MySQL};SERVER=mysqlhost;DATABASE=myDB;UID= userID;PASSWORD=pasword"

What's wrong with it?[posted and mailed]

Passero (yanongena@.pandora.be) writes:

> Hi all, i've just set up an mysql server on my computer and now i want to
> connect to a mysql database with an ASP page but i can't find the correct
> connection string. I always get an error that the datasource can not be
> found.
> ConnString =
>"Driver={MySQL};SERVER=mysqlhost;DATABASE=myDB;UID= userID;PASSWORD=pasword"
> What's wrong with it?

No idea, but you are probably more successful in getting an answer if
you ask in a forum devoted to MySQL. You posted your question in groups
related to MS SQL Server.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp