fp ODBC help, AGAIN

[Richard Hane]

I am getting quite frustrated getting fp to set up a low level link to our MRP software.
 
So I thought I'll begin to set up a High Level filePro ODBC file and see what it sets as the link.  This is what it set:
 
DSN: ODBC; DSN=Server2010-IERP60; Description=Intuitive ERP Datasource; WSID=virtualxp-51168;
Database=IERP60; Trusted_Connection=Yes; UseProcForPrepare=0; QuotedID=No
Table=IMA
And I would have used it except I do not have a Unique ID Field in this table.  Pressing F6 said I could use the timestamp field; however something tells me that this won't work.   Am I wrong?  The High Level seems a lot easier than the Low Level.
 
Anyway I tried to use the above info in the ODBC samples2 file as listed below
 
Driver Info driver={MySQL ODBC 3.51 Driver}
DB Info database=IERP60; server=server2010-IERP60; UID=sa; password=
Table Name IMA
It did not find and records.  And on my third try of pressing the [ESC] key knocked me out of filePo.
 
Any help would be appreciated.
 
Thanks
Rick Hane
Deluxe Stitcher Company Inc
ISP Stitching Products
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20121119/b4e21aa7/attachment.html