ODBC, MySQL, Windows

[Walter Vaughan]

Richard, 
Did you ever get this resolved?

-----Original Message-----
From: Filepro-list
[mailto:filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com]
On Behalf Of Richard Veith via Filepro-list
Sent: Wednesday, May 18, 2016 12:00 PM
To: Filepro-list at lists.celestial.com
Subject: ODBC, MySQL, Windows

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.

 

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

 

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.

 

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?

 

Thanks,

Rich  

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://mailman.celestial.com/pipermail/filepro-list/attachments/20160518/27
bbaba5/attachment.html>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list