PDA

View Full Version : FoxPro Error 1


SeanSeverson
01-13-05, 15:47
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

RedAxl
01-26-05, 02:05
SourceDB=c:\LS

You must specify the complete path and full filename with
extension of your DB.

SourceDB=c:\LS\Filename.Ext