nooone
2013-01-31T00:06:00Z
Topic: Mandatory Keys incorrectly configured - how to fix?

[programs / versions / Log File]

GeniusConnect V5 Outlook 2003
Version:501101 Multi-Byte 32 bit build.
Edition:5, Outlook version support: 2000 or higher.
Microsoft® Office Outlook® 2003 (11.0.0.8330) 32bit
Microsoft® Office Access® 2003

...Beginning of Log file

INFO:20130130 16:15:39 Folder: \\Personal Folders\Contacts\companies
INFO:20130130 16:15:39 Connecting to database: MS Access Database
INFO:20130130 16:15:40 Connected to database
INFO:20130130 16:15:40 Using file storage:C:\Users\Win7(Edward)\Documents\GeniusConnect\companies1.gc
INFO:20130130 16:15:40 Saving all Outlook items to database...
INFO:20130130 16:15:40 Preparing to save items
ERROR:20130130 16:15:41 Database call:
select max(id) + 1 from companies

07001 [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. (-3010)
WARNING:20130130 16:15:41 Advanced-Resources Temp-Agencies Items has empty primary key(s)!Without primary keys it is not possible to find the item in the database.
INFO:20130130 16:15:41 Inserted: Advanced-Resources Temp-Agencies
ERROR:20130130 16:15:41 Database call:
select max(id) + 1 from companies

07001 [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. (-3010)
WARNING:20130130 16:15:42 Expresscdl. com Truckdrivingschool Items has empty primary key(s)!Without primary keys it is not possible to find the item in the database.
INFO:20130130 16:15:42 Inserted: Expresscdl. com Truckdrivingschool
INFO:20130130 16:15:42 Summary:
INFO:20130130 16:15:42 -> Successfully saved 10 items(0 updated, 10 inserted, 0 unchanged, 0 conflict(s))
INFO:20130130 16:15:42 Disconnecting from database
INFO:20130130 16:15:42 Disconnected from database. Time Elapsed:0 min. 2 sec. Start:01/30/13 16:15:40 End:01/30/13 16:15:42 Items:10 Items/second:5

.... End of Log File
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
nooone
2013-01-31T00:07:00Z
I've assigned a database, picked a table, mapped the DB Fields, and lastly clicked 'Mandatory Keys' button.

##############

....after reading the Help File I entered...
'select max(id) + 1 from companies'

where 'id' represents a PrimaryID created by the database and 'companies' represent a folder I created in Outlook with various contacts

#################
mk:@MSITStore:C:\Program%20Files%20(x86)\Genius@WORK\GeniusConnect\OutlookConnect.chm::/OutlookConnectManual_rtf/Mandatory_keys.htm
##################

pressing 'test query' returns the result...

Database call:
07001 [Microsoft][OBDC Micrsoft Access Driver] Two few parameters.
Expected 1. (-3010)

What am I doing wrong?
(I can take screenshots if you find anything confusing)
nooone
2013-01-31T00:09:00Z
I've assigned a database, picked a table, mapped the DB Fields, and lastly clicked 'Mandatory Keys' button.

##############

....after reading the Help File I entered...
'select max(id) + 1 from companies'

where 'id' represents a PrimaryID created by the database and 'companies' represent a folder I created in Outlook with various contacts

#################
mk:@MSITStore:C:\Program%20Files%20(x86)\Genius@WORK\GeniusConnect\OutlookConnect.chm::/OutlookConnectManual_rtf/Mandatory_keys.htm
##################

pressing 'test query' returns the result...

Database call:
07001 [Microsoft][OBDC Micrsoft Access Driver] Two few parameters.
Expected 1. (-3010)

What am I doing wrong?
(I can take screenshots if you find anything confusing)
Administrator
2013-01-31T00:21:00Z
SQL statement 'select max(id) + 1 from companies' will be executed against your Database table.
Table companies must exist and primary key column id must exist in your database!