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