Connecting to SQL Server (directly) from Compact Framework

[Evan Camilleri]

I amanged to connec to an SQL server 2005 directly from CF application using
SqlClient.

BUT I cannot access a second instance in that server. i.e. when I enter in
the connection string MYSQLSERVER, ok but MYSQLSERVER\\SQL2 then it is a
problem. The system does not connect!!!

Evan

 

[Ginny Caughey [MVP]]

Evan,

What do the two connection strings look like? Are the servers listening at
different ports?

 

[Evan Camilleri]

It is the same server with 2 different instances which do not work!
usually when there are 2 different instances the 1st instance is sql2000,
the second is sql2005.....and it works for instance 1 only.
where is is only 1 instanace it can be any...and it works.

The sa has the same password on both instances. All I did was for the first
(and it worked)
Data Source=MYSQLSERVER......etc

while in the second... (it did not work)
Data Source=MYSQLSERVER\SQL2......etc

Evan

 

[carnivore]

Evan Camilleri pisze:

It is the same server with 2 different instances which do not work!
usually when there are 2 different instances the 1st instance is sql2000,
the second is sql2005.....and it works for instance 1 only.
where is is only 1 instanace it can be any...and it works.

The sa has the same password on both instances. All I did was for the first
(and it worked)
Data Source=MYSQLSERVER......etc

while in the second... (it did not work)
Data Source=MYSQLSERVER\SQL2......etc

Instead of instance of database try use a port.

Instead of
IP\sqlexpress
try
IP,port

 

[Evan Camilleri]

you mean that different instances work on different ports?

If yes, how do i know which?

Evan

 

[carnivore]

Evan Camilleri pisze:

you mean that different instances work on different ports?

If yes, how do i know which?

Start->Programs->Microsoft Sql 20005->Configuration Tools->Sql server
configuration manager

Sql server 2005 network configuration->Protocols for ....


TCP/IP must by enabled and in properties od TCP/IP you have tab IP Addresses
IPAll -> Port

 

[Evan Camilleri]

thanks

Evan Camilleri pisze:

Start->Programs->Microsoft Sql 20005->Configuration Tools->Sql server
configuration manager

Sql server 2005 network configuration->Protocols for ....


TCP/IP must by enabled and in properties od TCP/IP you have tab IP
Addresses
IPAll -> Port