Sounds like the project is not talking to the same odbc your test environment is. Permissions?

You could test the code from the command window before you intergrated it with your project. For example, you could enter this in your VFP command window:

gcConn=SQLCONNECT("sql_conn1","ServerName/UserName","")
* if that doesn't work, try
gcConn=SQLCONNECT("sql_conn1","","") && or a variation thereof 

and test for connection there. Your project doesn't seem to know who "sql_conn1" is. Most likely, if it is is possible to connect in the command window, it should be possible to log through the project. File #9840 may help you resolve some connection issues.

>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