<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>I am testing the use of FilePro 5.7 as a way to interact with tables in a MySQL 5.6.21 database. Both FilePro and MySQL are on the same Windows 10 pc.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>My problem is that while I can successfully create a low-level connection with the connection string and the query hard-coded into a prc file, I have been unable to get the high-level approach fully working. When I try the high-level approach, I can successfully start the process, and I get a Windows pop-up where I provide the connection details, and I successfully get past that point, and I get the FilePro screen to specify the table and the ID field, and that seems successful because it then allows me to see the layout for the initial screen, but when I hit ESC to save the screen, I notice that FilePro no longer has the database name at the top of the menu screen, and any further attempts to open that database result in error messages (e.g., if after selecting the database I try “Inquire, Update, Add”, the error message is Cannot open DSN; and if I try “Define Files” after selecting the database, the error message is “Warning An invalid data source was specified”).<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I would like to be able to use the high-level approach, because there will be a lot of tables we’d like to connect to. And I can’t figure out why the high-level approach seems to work all the way through the process of a successful connection and being able to see the first screen automatically defined correctly, and then not being able to use it.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Once the high-level connection is made, is the map file the only place where the connection information is maintained? Or is the map file alone not sufficient to allow FilePro to reopen that connection, and if so, what else is involved in the Windows environment?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal>Rich <o:p></o:p></p></div></body></html>