'0 Connectivity errro: Data source name not found and no default driver specified. However, I can use the same format to connect to any other database. I can do:

?SQLCONNECT([database name])

I just created an ODBC Connection and it connects fine...

Yikes, ok, it works now from VFP as well... Sheesh.

Thanks Sergey. :o)



>>SQL Server 2005. I copied a SQL 2005 database from another machine (detached it first. I can connect directly in SFT SQL Server Mgmt Studio, but I cannot connect from VFP using SQLCONNECT(). I've overlooked something. My login is the db_owner and everything else. Any ideas? SQL Server is running on the same machine that I have VFP9 on. It is setup for both SQL Server and Windows Authentication and I can connect to every other database I have attached.
>>
>
>What error do you get?