Login using ODBC
Is it possible to use an ODBC (my sql) database for the logon? All of my other files in this app are on mysql.
Thanks for posting.
I just wanted to make sure that we're on the same page; could you give an example of what you would like FileMaker to do? For example, are you asking if the MySQL database can manage the authentication for opening FileMaker databases where launching a FileMaker database would prompt for a SQL log-in?
I apologize for the confusion, I'm just thinking of a few routes that I could take this but I'd like to get a clearer idea of what you're trying to achieve before responding.
In Filemaker Pro I was using the IWP to design my program and there is a login screen. I’m going to move the final program to FM Server for more access and I was planning to use that login to determine what data should be available to the person logging in. Since all of my other data is stored in MySQL and accessed by other applications, I was hoping to maintain the logon rights in MySQL. Is that not the way to go?
The only way to authenticate a login to a database is either via FileMaker account (username/password) or external authentication (Open/Active Directory group privileges). You can specify if you want to maintain a MySQL login prompt within the database when that page displays MySQL data, but again this does not authenticate login information or authenticate FileMaker pages.
For what you're trying to do, it looks like you will need to create FileMaker logins.
Hope this helps,
Retrieving data ...