:o) Yeah, silly me. I know. I don't know what I was thinking! :o) It just dawned on me when I was replying to you what I was actually doing. I guess I got so used to having an odbc connection configured on my dev machine that I got into the habit of just using that name (I always use the same name for the odbc connection as the database itself) when I connect in testing...



>Tracy,
>
>The parameter to SQLCONNECT has to be either DSN or DBC connection name. You cannot just use Database name.
>
>>'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)