fp ODBC help, AGAIN

[Kenneth Brody]

On 11/19/2012 5:39 PM, Richard Hane wrote:
> 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.

High-level ODBC access requires a unique integer field, which acts as a 
replacement for ODBC's non-existent "record number" value.  If you don't 
have such a field in the data, you cannot use high-level ODBC to access it.

> 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.

If you selected the timestamp field as your "unique ID" field, I would be 
very surprised if things were to work.  (Though I'm not sure why you would 
be kicked out of filePro.)

-- 
Kenneth Brody