Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009

    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);
    OdbcDataReader dReader;

    dReader = cmd.ExecuteReader();

    Error comes here when he try to run "ExecuteReader"

    Please help...!!

    With Regards,
    K B Mishra

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6
    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.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Jan 2009
    Thanks for your guidance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts