>I need to execute a stored procedure on an Oracle 7.3 server in a remote location which is connected via dedicated telephone line to my server running Visual FoxPro 5.0.
>How do I start setting this up?
>Any help is greatly appreciated.
>Thanks, Hans.
Hans,
I know nothing about Oracle but I do know something about MS SQL Server. Here's how I would execute a stored procedure on MS SQL Server.
VFP access remote data through ODBC. So you have to create an ODBC Data Source Name (DSN) entry through the ODBC Administrator applet in the Control Panel.
It's not necessary to create a connection in your DBC.
Create a connection to the server using the SQLCONNECT() or SQLSTRINGCONNECT():
c = SQLCONNECT(dsn, username, password)
c = SQLCONNECT(vfp connection)
Now you can call the stored procedure:
r = SQLEXEC(c, [EXECUTE stored procedure] [,cResultSetName])
-Mike