Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    21

    Unanswered: ODBC--call failed (#0)

    Hello everybody. I'm trying to set up an ODBC connection in my Access 2003 database. I get as far as seeing the table names of my data source, then when I select one and click 'OK' I get the ODBC--call failed (#0) error. I can see the data with it's real application, Peregrine's Support Center, and I can use it with Crystal Reports. I want to be able to link to it to automate date entry to my db. Any help would be appreciated.

    Thanks,

    John

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Do you have the right permissions as the user connecting in?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    The data you are trying to link to, what format is it in? Is it a SQL Server database? FoxPro? DB2?

    Are you using the correct driver?

  4. #4
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    21
    I'm pretty sure I have rights to the data. I'm using the same login and password that works in the native application and Crystal. Service Center data is storage within its own datastructure called P4. I'm thinking it must be something I'm missing in Access because I can use it in Crystal.

Posting Permissions

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