Hi Daniel,

First thanks for the reply,

Following is the error returned by AERROR() function;

------------------------------------
1526

Connectivity error: [Microsoft][ODBC SQL Server driver][SQL Server]Invalid object name 'orders'.

[Microsoft][ODBC SQL Server driver][SQL Server]Invalid object name 'orders'.

S0002

208

1

.NULL.
------------------------------------

If I use ODBC connection to my VFP databases on remote server (withing LAN) it works fine. However if I use ODBC to SQL Server it won't work. Can you make our how do I establish a connection.

Do I have to specify Northwind database, under the SQL Server??? How?

TIA




>Shaishav,
>
>Did you configure SQL Server to be case sensitive? If yes, then you must specify object names (tables, fields, etc) using the exact case. Try the following:
>

>SQLExec(gnConnHandle,'SELECT * FROM Orders','RESULT1')
>

>
>Another thing to check if a SQLEXEC() fails is AERROR(). It will tell you what went wrong.
>
>HTH
>>I'm trying to establish connection to SQL 2000 database on a server on my LAN. I successfully created a connection using my ODBC data source. however, when i try to run SQL query using SQLExec, it fails.
>>
>>Following is my code; can any one help me in this.
>>
>>I'm trying to connect to ORDERS table of Northwind Database.
>>
>>STORE SQLCONNECT('MRAD', 'sa') TO gnConnHandle
>>IF gnConnHandle < 0
>> = MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
>>ELSE
>> = MESSAGEBOX('Connection made', 48, 'SQL Connect Message')
>> SQLExec(gnConnHandle,'SELECT * FROM ORDERS','RESULT1')
>> SELECT RESULT1
>> BROW
>>ENDIF
>>
>>TIA