Connect Multiple MSSQL database with FM3

[ralonso2001]

Hello, you can select using webserver user, password and database from a browser using Nettalk MsSql Fm3

Thanks

Rodrigo

[kevin plummer]

1) You need a way of storing the DB connection string associated with each user (p_web.ssv is a good way)
2) In your web handler processlink embed set your glo:dbowner to what you saved.

After your app connects to SQL via fm3 when you start up, there is no need to use FM3 to do the connection again.

[Bruce]

also, make sure your glo:owner string for the tables is THREADed.
Then, as Kevin says, it can (MUST) be set explicitly in the WebHandler, ProcessLink, Before parent call.

cheers
Bruce

[ralonso2001]

This method works if you disable all file manager features

But I want to keep updating the tables

any ideas?

[kevin plummer]

I have fm3 enabled at it still works as discussed.