Link to Pervasive database
Posted on 2009-04-28
I am trying to link a table in PervasiveSQL9.5 from access2003 through ODBC connection. Everything looks ok I can see tables then when I pick up one and click button to link I got error.
I think that error is related to pervasive table filed name or particular filed data type.
Is it possible that access ODBC connection can not link pervasive table or some data type filed can not be pulled in access.
I dont believe that pervasive table filed name allow some naming convention that access database not support.
Such is putting in table field name ( ?/., or similar characters.
If I go through pass-through query and pull just one or two filed from same table that have char data type my query run ok.
What it could be that causing this problem?
I am able to link all tables from demo database in Pervasive 10. without any problem.