I have problems with the designer connection

[Xaplytz]

I have problems with the designer connection

The line is “modify connection”
This line works well inside foxpro environment
Everything is working fine with SQL-Server but I have allow the user set the connection
and inside the EXE doesn’t work the line “modify connection”
return the error “feature is not available ”

is like foxpro know the command only inside hem but doesn’t add it to the EXE

If somebody know who fix it
Pleas answer

thank

 

[foxdev]

There are several commands that are intended strictly for developer, not end-user, use (such as SUSPEND). I didn't think MODIFY CONNECTION was one of them, but it could be. Is your DBC included as a file in your project? If so, then it becomes read-only (as are any other files included within the EXE itself.

Rather than MODIFY CONNECTION, try using DBSETPROP() to set the connection properties.

I'm not sure what you want to change about the connection, but you can change many of the properties after the connection is established by using SQLSETPROP().