Results 1 to 2 of 2

Thread: FoxPro Error 1

  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Question Unanswered: FoxPro Error 1

    I am attempting to connect to a fox pro data file using a file DSN. I am receiving the following error when running a select statement: [Microsoft][ODBC Visual FoxPro Driver]Fox Error 1.

    The select statement is the following: Select sosn from somast01 where sono = 12271

    My file dsn looks like this...

    [ODBC]
    DRIVER=Microsoft Visual FoxPro Driver
    UID=
    Deleted=No
    Null=No
    Collate=Machine
    BackgroundFetch=Yes
    Exclusive=No
    SourceType=DBF
    SourceDB=c:\LS

    Any ideas why I get the error?

    Sean M. Severson
    Software Technology Solutions, LLC

  2. #2
    Join Date
    Nov 2004
    Posts
    39
    SourceDB=c:\LS
    You must specify the complete path and full filename with
    extension of your DB.

    SourceDB=c:\LS\Filename.Ext

Posting Permissions

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