NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: ralonso2001 on June 27, 2013, 10:32:25 AM

Title: Connect simultaneously multi databases
Post by: ralonso2001 on June 27, 2013, 10:32:25 AM

Hi, I need to connect simultaneously multi databases with FM3, is that I have to do it from processlink (WebHandler), but the FM only works with the base that is associated with the Connection window. If I connect a second base from Connection string gives me this error:

FM3: Unable to open file. Errorcode 90 received. Are you sure your Connection details are correct?::Driver=mss Name:dbo.Table

I have also set to FM MultipleActiveResultSets = TRUE

thanks!

Title: Re: Connect simultaneously multi databases
Post by: kevin plummer on June 27, 2013, 04:30:09 PM

Can you post the code you are using to set the connection string? Is the connection string global variable threaded?

Title: Re: Connect simultaneously multi databases
Post by: ralonso2001 on June 27, 2013, 04:50:51 PM

this is the string I'm using mssql

GLO:Conexion = CLIP(LEFT(LOC:Server))&','&CLIP(LEFT(p_web.GSV('LOC:DatabaseName')))&','&CLIP(LEFT(LOC:UserName))&','&CLIP(LEFT('LOC:Pwd'))

thanks!!

Rodrigo