fp ODBC help, AGAIN

[Rick Hane]

Ken,

[ sorry top posted ]

Thanks for the reply.  Please answer two questions for me.

1.  What is the driver that filePro is looking for Microsoft SQL Server?
Not "MySQL ODBC 3.51 Driver" I'm sure.

2. I just thought of something which may be the root of my problems.  I
have been testing these in filePro file ODBC_Samples2.  I am pretty sure
this has files already programmed.  If this is correct I probably should
set up a test file and do my setup in there.   Does this make sense?

I have to tell you fpWeb was a lot easier than this.

Thanks again,
Rick Hane
Controller
Deluxe Stitcher Company Inc
ISP Stitching Products
www.deluxestitcher.com
773-777-6500

-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Tuesday, November 20, 2012 8:58 AM
To: Richard Hane
Cc: file Pro Mailing List; Rick Hane
Subject: Re: fp ODBC help, AGAIN

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