Alpha Video Training
Results 1 to 2 of 2

Thread: Database API specific error

  1. #1
    Member
    Real Name
    Kathleen Matthews
    Join Date
    Aug 2008
    Posts
    12

    Default Database API specific error

    Hi,

    I received the following error message when attempting to connect to the Account File:

    Database API specific error
    Your database has returned the following error......................................

    11015-'[QODBC] Expected lexical element not found: <identifier> SQL State is 42000'

    Thanks for your assistance.
    Kathleen

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,561

    Default Re: Database API specific error

    Kathleen

    Are selecting fields from the account table or all fields?

    The account table has a field named desc which can cause an error when you have selected fields - including desc.

    I know I usually say to select only the fields needed - this is one exception... Use the select all fields ( columns ).

    Also check your named connection string... It should have a '.' for the company file name so it is looking at the currently open QB file.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. sorting api error
    By Henkie in forum Application Server Version 9 - Web/Browser Applications
    Replies: 1
    Last Post: 06-20-2008, 01:40 AM
  2. API error
    By Anis in forum Application Server Version 9 - Web/Browser Applications
    Replies: 9
    Last Post: 06-04-2008, 12:12 AM
  3. Database API error
    By Anis in forum Alpha Five Version 9 - Desktop Applications
    Replies: 8
    Last Post: 03-28-2008, 04:44 AM
  4. Database connection errors: SQL API-related?
    By jbooth in forum Alpha Five Version 7
    Replies: 5
    Last Post: 11-08-2007, 11:38 AM

Bookmarks

Posting Permissions

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