Query ODBC database from MS SQL Server?

Started by winstonl91, October 06, 2021, 02:33:49 PM

Previous topic - Next topic

winstonl91

PVX version: 1.41.00000
WindX version: 1.41.00000
ODBC version: 5.10.0002

I downloaded the driver: ODBC 5.20.0002 - Driver and PXPSQL command line processor - Windows

and was able to query the database by Excel and MS Access, I can see all columns. However when I use MS SQL and link the App server as a linked server. I can't see the columns. I can see the tables in MS SQL but I can't query it. Which driver should I use in order to query PxPlus ODBC from MS SQL?

When I right clicked on a tables and Script table as - > Select to -> New query editor

It gave this error:

....contains no columns that can be selected or the current user does not have permissions on that object

But I used the same DSN as MS Access and Excel and was able to see the columns in tables.

Thank you!