PxPlus User Forum

Twitter Twitter Twitter

Author Topic: ODBC / Linked Server  (Read 1405 times)

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
ODBC / Linked Server
« on: February 08, 2022, 09:37:04 AM »
Hello All,

We are trying to attempt is to set up a linked server in SQL as a read only to pull data from a Pxplus database. The linked server is an ODBC type using the 5.20 64 bit driver and we can see all the tables but we cannot query anything. Using Excel we are able to pull data using the same odbc connection but SQL locks up all users and does nothing. The SQL server is in Azure and we are using SSMS to access the connection. We have tried this before with the same result on older versions of SQL both 3.50 64 bit and the 4.21.1 32 bit. Has anyone ever been able to get linked server to work in SQL or is it just not compatible?

thanks

jeff
« Last Edit: February 08, 2022, 10:30:39 AM by Jeffrey Ferreira »

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: ODBC / Linked Server
« Reply #1 on: February 08, 2022, 10:23:53 AM »
There is no version 3.50 of the 64-bit PxPlus ODBC driver. The first version to have a 64-bit version is 5.00.0000.

I am not to sure what software you are running or how you are getting the version number but 3.50 and 64-bit can't be correct for the PxPlus ODBC driver.

As for SQL Server Support we have made several changes to better support SQL Server in more recent versions of the PxPlus ODBC driver and I would recommend using the latest version 7.00.0003 which you can find on our downloads site. Note that you need an activation compatible with PxPlus 2019 (V16) to run the PxPlus ODBC 7.00.0003.
Principal Software Engineer for PVX Plus Technologies LTD.

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Re: ODBC / Linked Server
« Reply #2 on: February 08, 2022, 10:32:01 AM »
I'm sorry Devon. The customer sent me that. It is version 5.20 of odbc
i will try the later version....
Question for you - in the pxplus client / server odbc configuration, if the server is running odbc 5.2 can i run a client at 7.##

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: ODBC / Linked Server
« Reply #3 on: February 08, 2022, 10:38:59 AM »
No version 5.20 can't talk with a version 7.00 server. There have been protocol changes that break compatibility. We try our best to keep things as compatible as possible but some features and bug fixes required us to change the protocol the client and server communicate with.

For details on which version is compatible with which please see: https://manual.pvxplus.com/?odbc/odbc_faq.htm#Mark10
Principal Software Engineer for PVX Plus Technologies LTD.

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Re: ODBC / Linked Server
« Reply #4 on: February 08, 2022, 10:42:23 AM »
Hi Devon - our configuration would have been

Client = 7.00
Server = 5.20

would that not work either.

Devon Austen

  • Administrator
  • Diamond Member
  • *****
  • Posts: 382
  • Don’t Panic
    • View Profile
    • PVX Plus Technologies
Re: ODBC / Linked Server
« Reply #5 on: February 08, 2022, 11:05:40 AM »
No that won't work.

The compatibility table works both ways.

You need at least a 6.10 server but since you have to upgrade you might as well use 7.00.0003.
Principal Software Engineer for PVX Plus Technologies LTD.