NetTalk Central

Author Topic: Connect simultaneously multi databases  (Read 3049 times)

ralonso2001

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
    • Qúbigo ERP
    • Email
Connect simultaneously multi databases
« 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!
Regards,
Rodrigo Alonso
Mendoza - Argentina

kevin plummer

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Connect simultaneously multi databases
« Reply #1 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?

ralonso2001

  • Jr. Member
  • **
  • Posts: 56
    • View Profile
    • Qúbigo ERP
    • Email
Re: Connect simultaneously multi databases
« Reply #2 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
Regards,
Rodrigo Alonso
Mendoza - Argentina