ODBC / Linked Server

[Jeffrey Ferreira]

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

[Devon Austen]

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.

[Jeffrey Ferreira]

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]

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

[Jeffrey Ferreira]

Hi Devon - our configuration would have been

Client = 7.00
Server = 5.20

would that not work either.

[Devon Austen]

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.