var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Pervasive ODBC Connection
I am using VS2005 for connecting Pervasive Database through ODBC and Its connecting to the Database properly.
Next same ODBC I am using in our application to connect the database and its connecting But when I am trying to execute the query its giving error "Table Name too Long".
My Code is:
string conStr="Dsn=TimberLinePM;dbq=F:\tsgold\Sample TimberLine PM Database;codepage=1252;dictionarymode=0;standardmo de=0;maxcolsupport=255;shortennames=0;databasetype =1";
OdbcConnection con = new OdbcConnection(conStr);
string strSql = "select * from property_pmp_property";
OdbcCommand cmd = new OdbcCommand(strSql, con);
dReader = cmd.ExecuteReader();
Error comes here when he try to run "ExecuteReader"
K B Mishra
Most PSQL databases only support table names of 20 characters. Only v10 supports the "V2" metadata which supports longer table names.
The solution to your problem is to reduce the length of your table name.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
I do not answer questions by email. Please post on the forum.
Thanks for your guidance.