Page 1 of 1

ODBC to MySQL database on Web Server

PostPosted: Sat Jul 02, 2011 10:11 am
by paulboyes
I want to use ODBC to link to a MySql database on a hosted web server.

This is on a domain that I own.

I need advice as to the appropriate ODBC driver and the methodology of establishing the link.

Paul

Re: ODBC to MySQL database on Web Server

PostPosted: Mon Aug 22, 2011 8:46 pm
by Graham Smith
Do you mean that the server is not a part of your network? If so, then I'm pretty sure you are out of luck.

Re: ODBC to MySQL database on Web Server

PostPosted: Fri Oct 14, 2011 3:30 pm
by Stewart Allen
If you can create a standard UDL that connects to the MS DB then you should be able to use it.

Register the UDL path/name in DE/Ffenics.

Re: ODBC to MySQL database on Web Server

PostPosted: Sat Feb 25, 2012 1:33 pm
by paulboyes
It has taken a while to get around to this again, now I have a problem.

I am running under Windows 7 and I have created a 64 bit ODBC link to the web server database which works (I use it to link to a Business Intelligence app)

I have created a UDL file to the MySql Database on the web server using the same ODBC. This seems OK because when I have the correct credentials the Test connect reports a successful connection.

However when I go to the Database Links and I point to the UDL file the available tables point to the Native FF tables in the database not MySql ones.

Clearly I have done something wrong but i am not sure what.

Paul

Re: ODBC to MySQL database on Web Server

PostPosted: Mon Feb 27, 2012 2:32 pm
by Adrian Jones
you're definitely NOT referring to the Default Link field on the DB Links dialog, are you?

Re: ODBC to MySQL database on Web Server

PostPosted: Mon Feb 27, 2012 2:38 pm
by Graham Smith
Not sure either, but I do know that 64 bit ODBC can be tricky because some programs don't see the links. But that doesn't sound like the problem you are having.

There are separate 32 bit and 64 bit ODBC registries. Are you sure that you don't have a 32 bit registry entry with the same name that you are connecting to?

Re: ODBC to MySQL database on Web Server

PostPosted: Mon Feb 27, 2012 2:51 pm
by paulboyes
No, I am referring to the UDL file.

However in creating the UDL file I selected Microsoft OLEDB DB Provider for ODBC drivers. There is not one for just ODBC.

Also could the use of 64 bit drivers cause a problem?

Paul

Re: ODBC to MySQL database on Web Server

PostPosted: Mon Feb 27, 2012 3:38 pm
by Adrian Jones
Paul, I don't understand the problem, Could you post a screen shot or something to clarify where you are seeing this?

Re: ODBC to MySQL database on Web Server

PostPosted: Fri May 11, 2012 9:11 am
by SiDay
Hi

I have exactly the same problem. You can see from the attached screenshots that I have setup a User DNS and then try to use it in Database Link within ffenics to link to a mySQL database on a webserver.

All that comes up is the ffenics table list. I am running on Windows 7.

I have read the related posts on this forum regarding mySQL, UDLs and ODBC / OLEDB and cannot make it work.

I wonder if anyone has any suggestions or if a precise set of instructions exist regarding how to link ffenics to a mySQL database.

Thanks

Simon

Re: ODBC to MySQL database on Web Server

PostPosted: Fri May 11, 2012 10:50 am
by Graham Smith
SiDay wrote:All that comes up is the ffenics table list.

Only comes up where? What list are we talking about here?

I think you may be missing something.

Re: ODBC to MySQL database on Web Server

PostPosted: Mon May 21, 2012 9:10 am
by SiDay
Sorry its taken so long to get back - I've been away for a week.

Only the ffenics tables appear in the "Tables Available" box as shown in the first screenshot above.

Best Regards

Simon

Re: ODBC to MySQL database on Web Server

PostPosted: Mon May 21, 2012 11:32 am
by Graham Smith
The graphics are too small for my old eyes to read but... Below the tables is a choice field to select the data source. By default it is Native, but if you look you should see your link as well.

Re: ODBC to MySQL database on Web Server

PostPosted: Mon May 21, 2012 1:08 pm
by SiDay
Hi Graham

Thanks for the reply. The link to the database appears in the box that you mentioned underneath "Native" but when I select it nothing happens.

You can see the DataLink name showing in the attached image but the tables in the database do not show.

Regards

Simon

Re: ODBC to MySQL database on Web Server

PostPosted: Fri May 25, 2012 9:42 am
by SiDay
Anyone any ideas - I'm stumped. The connection works with Excel but not Ffenics.

Re: ODBC to MySQL database on Web Server

PostPosted: Fri May 25, 2012 11:29 am
by KjetilUrne
If drivers are available (I do not know if they are...) I would have tried a connection based on oledb in stead of odbc (at least connections to Oracle works fairly well through oledb).