Hi all,
I’m trying to create a connection with SQL Server using sqlstringconnect(). I’ve done this about a zillion times over the years and work every day with VFP to over a dozen SQL Server and Sybase databases from Win2000, XP and Win7 clients, no problem.

All of a sudden, we have a box that runs some processes that began to fail when the box was upgraded to Win 7. The connect string no longer works. I’m working through a remote desktop to get to this box, but surely that can’t matter. The app runs on the box, or used to, when a batch file is run by a timer. I just use the remote desktop to get to it.

Anyway, I can create an ODBC DSN, user and system, on the box and they connect fine. I can ping the database server successfully. But I cannot get a connect string to work, either trusted connection or ODBC login. Can’t get sqlconnect(‘MyDSN’) to work either even though the DSN connects fine through the ODBC administrator.

When the connect fails, I get an error to the effect that the server can’t be found. Specificlly:
SQLState: 08001
"Error locating server/instance specified"

This even with the DSN connecting fine with the same server/instance.

We have both the SQL Server 6.01 and SQL Server Native Client 10.0 drivers on the box and I can create DSN’s using either.
Any of this ring any bells for anyone?

Thanks,
Gary