NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: ralonso2001 on March 27, 2013, 07:25:48 AM

Title: Connect Multiple MSSQL database with FM3
Post by: ralonso2001 on March 27, 2013, 07:25:48 AM

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

Thanks

Rodrigo

Title: Re: Connect Multiple MSSQL database with FM3
Post by: kevin plummer on March 27, 2013, 02:32:59 PM

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.

Title: Re: Connect Multiple MSSQL database with FM3
Post by: Bruce on March 27, 2013, 09:56:32 PM

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

Title: Re: Connect Multiple MSSQL database with FM3
Post by: ralonso2001 on April 03, 2013, 09:19:55 AM

This method works if you disable all file manager features

But I want to keep updating the tables

any ideas?

Title: Re: Connect Multiple MSSQL database with FM3
Post by: kevin plummer on April 04, 2013, 06:39:02 PM

I have fm3 enabled at it still works as discussed.