Forum Discussion

Yggdrasill's avatar
Yggdrasill
Icon for Responsive Resident rankResponsive Resident
6 years ago

Pervasive SQL

I'm trying to connect to a db. I'm getting the name of the db but no tables.   This is what I've done so far Installed Pervasive ODBC Client Interface drive   Setup System DNS in ODBC Data ...
Need Help
Show and Tell
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Yggdrasill,

Accorin to your description, it seems that you could connect to Pervasive SQL successfully, but you can't get the table from database, right? And it seems that when you use windows credential , it could work, right?

You need to make sure the user(which use database credential) have permission to these table. In addition, if you write the SQL query in advanced option, will you get table data?

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.