PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Serius I complete missing undesrtand odbc  (Read 979 times)

eldonfsr

  • Silver Member
  • ***
  • Posts: 39
    • View Profile
Serius I complete missing undesrtand odbc
« on: February 17, 2024, 07:35:15 PM »
ODBC let i setting and test and sad connection successful but just i close odbc32 and open again and to configuration of dns now sad connections failed, so  tried  differents options and i dont get  this works..... even i change setting of odbc on mas90 to let access tables and fields, i created a special user to give access all tables and fields, is strange because is not when run some sql is just login so i thinking is not on setting of odbc on mas90.... you can see on attach first to is when i setting odbc and last 2 image is after re open odbc, not change nothing just ask connect again..

why is so difficult to work with this odbc..... I read a lot of links a documentations and nothing....

Different odbc version...
     

EVa

  • Gold Member
  • ****
  • Posts: 54
    • View Profile
    • EDIAS
Re: Serius I complete missing undesrtand odbc
« Reply #1 on: February 21, 2024, 03:06:40 AM »
For starters, you could enable debugging to see if there's a difference the 1st and 2nd time you connect.  Also, this appears to be a rather old version of the ODBC driver as it says 'ProvideX' in the title bar ?

Mike King

  • Diamond Member
  • *****
  • Posts: 3817
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Serius I complete missing undesrtand odbc
« Reply #2 on: February 21, 2024, 08:00:11 AM »
Edias is correct.  This appears to be the ProvideX ODBC driver as sold and supported by Sage with their MAS90 accounting package. 

If the issues you are having are relative accessing MAS90 data you should contact Sage for assistance as their ODBC driver is different than the drivers for PxPlus.
« Last Edit: February 21, 2024, 08:02:12 AM by Mike King »
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com