<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>I am getting quite frustrated getting fp to set up a low level link to our MRP software.</div><div> </div><div>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:</div><div> </div><div>
<span style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: Calibri; mso-ansi-language: EN;" lang="EN"><font face="Calibri">DSN: ODBC; DSN=Server2010-IERP60; Description=Intuitive ERP Datasource; WSID=virtualxp-51168;
Database=IERP60; Trusted_Connection=Yes; UseProcForPrepare=0; QuotedID=No<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></font></span></div><div>
</div><div style="margin: 0in 0in 10pt; text-autospace: ; mso-pagination: none; mso-layout-grid-align: none;" class="MsoNormal"><span style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: Calibri; mso-ansi-language: EN;" lang="EN"><font face="Calibri">Table=IMA<o:p></o:p></font></span></div><div>
</div><div>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.</div><div> </div><div>Anyway I tried to use the above info in the ODBC samples2 file as listed below</div><div style="margin: 0in 0in 10pt; text-autospace: ; mso-pagination: none; mso-layout-grid-align: none;" class="MsoNormal"><span style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: Calibri; mso-ansi-language: EN;" lang="EN"><o:p><font face="Calibri"> </font></o:p></span></div><div>
<span style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: Calibri; mso-ansi-language: EN;" lang="EN"><font face="Calibri">Driver Info driver={MySQL ODBC 3.51 Driver}<o:p></o:p></font></span></div><div>
</div><div style="margin: 0in 0in 10pt; text-autospace: ; mso-pagination: none; mso-layout-grid-align: none;" class="MsoNormal"><span style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: Calibri; mso-ansi-language: EN;" lang="EN"><font face="Calibri">DB Info database=IERP60; server=server2010-IERP60; UID=sa; password=<o:p></o:p></font></span></div><div>
<span style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family: Calibri; mso-ansi-language: EN;" lang="EN"><font face="Calibri">Table Name IMA<o:p></o:p></font></span></div><div>
</div><div>It did not find and records. And on my third try of pressing the [ESC] key knocked me out of filePo.</div><div> </div><div>Any help would be appreciated.</div><div> </div><div>Thanks</div><div>Rick Hane</div><div>Deluxe Stitcher Company Inc</div><div>ISP Stitching Products</div><div><var id="yui-ie-cursor"></var> </div></div></body></html>