Old code not able to connect to unicode instance   

Hi,

I have a program written in C/C++ compiled with MS Visual Studio 6.0 that 
fails to connect to a french SQL Server instance (probably a 2005 instance) 
with "SQL Server does not exist or access denied".

I can connect to the instance with SQL Server Management Studio with no 
problems.

Is the OLE interface for VS6.0 not capable of this?

John.

date: Tue, 25 Sep 2007 11:18:27 +1000   author:   John

RE: Old code not able to connect to unicode instance   

I doubt it had anything to do with the code page of the instance. I would try 
to modify the connection string to make the server name as specific as 
possible. For instance, try the IP address followed by a comma and the port 
number (e.g. tcp:30.5.183.110,1433).

Linchi

"John" wrote:

> Hi,
> 
> I have a program written in C/C++ compiled with MS Visual Studio 6.0 that 
> fails to connect to a french SQL Server instance (probably a 2005 instance) 
> with "SQL Server does not exist or access denied".
> 
> I can connect to the instance with SQL Server Management Studio with no 
> problems.
> 
> Is the OLE interface for VS6.0 not capable of this?
> 
> John.
> 
> 
>

date: Fri, 28 Sep 2007 11:15:01 -0700   author:   Linchi Shea