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