filepro ODBC

Rod Caddy rcaddy at pro-set.com
Mon Oct 3 13:55:05 PDT 2005


I have an issue with fp_odbc, background first.  I run the program from 
a windows xp pro system but the data and programs reside on a win2000 
server.  The access database resides on the c drive of the xp machine 
(although I would prefer it to be on the 2000 server. When I go into 
define files I get a message that says that the field that is my fp key 
is being set to read only.  This is true no matter what program I enter, 
dcabe, dclerk, dreport, etc.  After getting that message I receive an 
error of "Too few parameters. Expected 1." I press ok and it takes me to 
the define files change password question then to the odbc datasource 
area. The following is what I have in the three fields and it is 
identical to what was there when this was licensed for my laptop:

DSN:ODBC;DSN=MS Access Database;DBQ=c:\PS-Journal\journal.mdb;
DriverID=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;
Table:psj
Unique ID field:FP_id

When I try to run any reports that accesses this data I get:
the same errors described above then it allows me to select my output 
format and the rest of the report options.  When I start the selection 
process I get the "Too few parameters. Expected 1." message and then I 
receive this error:

Exception error in CommitOpen
Too few parameters. Expected 1.
State:07001,Native:3010,Origin:[Microsoft][ODBC Microsoft Access Driver]

Retcode= -1(0xffffffff)

Any thoughts would be appreciated.

-- 
Rod Caddy
Pro-Set Systems
rcaddy at pro-set.com


More information about the Filepro-list mailing list