SQLEXEC doesn't return any result 1

[ariftvt]

Sqlexec doesn't return any result if i execute my programme (.exe) from another pc.

 

[baltman]

It returns an error message. Put a suspend in right after and use aerror() to investigate.

 

[bborissov]

ALWAYS check what SQL*() functions return and if the function return negative value use AERROR() to check what is the reason:

IF SQLEXEC(.....) < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[ariftvt]

I 've got an error message :-
------------------------------
Connectivity errror:[Microsoft][ODBC SQL Server Driver][SQL Server][Invalid object name 'arif_fgmaster'
--------------------------------------
'arif_fgmaster' is a view i've created under the database in my server.i can access the view from my PC and it works well.but when i'm trying to run the programm (.EXE) from another work station it returns the above problem.

 

[bborissov]

Then the other computer is connected to different server or different database.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[Olaf Doschke]

True, perhaps you connect to localhost on both computers?
Perhaps you connect to a specific server, but remote access isn't granted. Take a look into SQL Server configuration.

Bye, Olaf.

 

[ariftvt]

Great...it works. The default database in ODBC Connection had to be changed.
i had n't driven my thoughts that way.

thanks