Problem when conncet to SQL Server 2005 (SQL Native Client + Named instance)

microsoft.public.sqlserver.programming

17 Feb 2006 5:54 AM

ski blue

Hi,

I have an application which previous connect to SQL Server 2000.

Now, I installed SQL Server 2005, and try to conncet to it.

The previous connection string is:
sString.Format("DSN=%s;uid=%s;pwd=%s", sDb, sUser, sPassword);

In order to support SQL Native Client driver in SQL Server 2005, I
changed the connection string to:
sString.Format("Provider=SQLNCLI;
DataTypeCompatibility=80;DSN=%s;uid=%s;pwd=%s", sDb, sUser,
sPassword);

I have a default instance and a named instance in my database. So i
created two DSN:
(1) Use SQL Native Client as the driver and connect to the default
instance.
     The application could work well under this configuration.

(2) Use SQL Native Client as the driver and connect to the named
instance.
     The application could not work successfully under this
configuration.
     It could not connect to the database.

I have started the SQL Server Browser service.

Why I could not connect to the database when i use SQL Native Client +
Named instance

Who can help me?

Thanks in advance.