Hello All !
I have client/server application (SQL Server and VFP8)
I used to work with remove views and now trying to work with SQL Pass Through technique.
I have DSN “sql_conn1”, which works with views.
Now I’m trying to use the same DSN for SPT like this:
Create new form:
Form1:Load:
#define MB_OKBUTTON 0
#define MB_STOPSIGNICON 16

public gcConn
gcConn=SQLCONNECT("sql_conn1","ServerName/UserName","")
IF (lcConn < 0)
LOCAL ARRAY laError[1]
AERROR(laError)
MESSAGEBOX(laError[2],;
MB_OKBUTTON+MB_STOPSIGNICON,;
"Error "+TRANSFORM(laError[5]))
ELSE
MESSAGEBOX("OK")
ENDIF
*********************
Everything works fine. I create stored procedures, call them, execute them , fine.
But when I decide to put this form into my project and call it from the menu, I got error message
Connectivity error:[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified.
I don’t understand what’s the problem here ?
May be somebody can help?
Thanks in advance,
Mariam