ODBC to MySQL database on Web Server

ODBC Connectivity, ELFs , Windows API etc.

Moderators: Phil Winkler, Graham Smith, Pete Tabord

ODBC to MySQL database on Web Server

Postby paulboyes » Sat Jul 02, 2011 10:11 am

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
Paul Boyes

PB Business Solutions

Phone +44 1926 620098
Email paul.b@pbbusinesssolutions.com
Web http://www.pbbusinesssolutions.com
paulboyes
 
Posts: 158
Joined: Thu Nov 06, 2008 4:52 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: ODBC to MySQL database on Web Server

Postby Graham Smith » Mon Aug 22, 2011 8:46 pm

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.
Graham Smith
DataSmith, Delaware
"For every expert there is an equal and opposite expert.", Arthur C. Clarke (1917 - 2008)
"X-Clacks-Overhead: GNU Terry Pratchett"
User avatar
Graham Smith
 
Posts: 2501
Joined: Fri Sep 07, 2007 11:31 am
Location: Delaware, USA
Has thanked: 0 time
Been thanked: 1 time
 

Re: ODBC to MySQL database on Web Server

Postby Stewart Allen » Fri Oct 14, 2011 3:30 pm

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.
Stewart Allen
 
Posts: 88
Joined: Thu Sep 27, 2007 11:25 am
Has thanked: 0 time
Been thanked: 0 time
 

Re: ODBC to MySQL database on Web Server

Postby paulboyes » Sat Feb 25, 2012 1:33 pm

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
Paul Boyes

PB Business Solutions

Phone +44 1926 620098
Email paul.b@pbbusinesssolutions.com
Web http://www.pbbusinesssolutions.com
paulboyes
 
Posts: 158
Joined: Thu Nov 06, 2008 4:52 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: ODBC to MySQL database on Web Server

Postby Adrian Jones » Mon Feb 27, 2012 2:32 pm

you're definitely NOT referring to the Default Link field on the DB Links dialog, are you?
User avatar
Adrian Jones
 
Posts: 2000
Joined: Tue Sep 11, 2007 2:38 pm
Location: Cornwall, UK
Has thanked: 5 times
Been thanked: 4 times
 

Re: ODBC to MySQL database on Web Server

Postby Graham Smith » Mon Feb 27, 2012 2:38 pm

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?
Graham Smith
DataSmith, Delaware
"For every expert there is an equal and opposite expert.", Arthur C. Clarke (1917 - 2008)
"X-Clacks-Overhead: GNU Terry Pratchett"
User avatar
Graham Smith
 
Posts: 2501
Joined: Fri Sep 07, 2007 11:31 am
Location: Delaware, USA
Has thanked: 0 time
Been thanked: 1 time
 

Re: ODBC to MySQL database on Web Server

Postby paulboyes » Mon Feb 27, 2012 2:51 pm

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
Paul Boyes

PB Business Solutions

Phone +44 1926 620098
Email paul.b@pbbusinesssolutions.com
Web http://www.pbbusinesssolutions.com
paulboyes
 
Posts: 158
Joined: Thu Nov 06, 2008 4:52 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: ODBC to MySQL database on Web Server

Postby Adrian Jones » Mon Feb 27, 2012 3:38 pm

Paul, I don't understand the problem, Could you post a screen shot or something to clarify where you are seeing this?
User avatar
Adrian Jones
 
Posts: 2000
Joined: Tue Sep 11, 2007 2:38 pm
Location: Cornwall, UK
Has thanked: 5 times
Been thanked: 4 times
 

Re: ODBC to MySQL database on Web Server

Postby SiDay » Fri May 11, 2012 9:11 am

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
Attachments
ffenicsLink (640x360).jpg
ffenicsLink (640x360).jpg (108.61 KiB) Viewed 8834 times
FfenicsDSN (640x360).jpg
FfenicsDSN (640x360).jpg (118.78 KiB) Viewed 8839 times
SiDay
 
Posts: 6
Joined: Fri Sep 26, 2008 12:01 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: ODBC to MySQL database on Web Server

Postby Graham Smith » Fri May 11, 2012 10:50 am

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.
Graham Smith
DataSmith, Delaware
"For every expert there is an equal and opposite expert.", Arthur C. Clarke (1917 - 2008)
"X-Clacks-Overhead: GNU Terry Pratchett"
User avatar
Graham Smith
 
Posts: 2501
Joined: Fri Sep 07, 2007 11:31 am
Location: Delaware, USA
Has thanked: 0 time
Been thanked: 1 time
 

Re: ODBC to MySQL database on Web Server

Postby SiDay » Mon May 21, 2012 9:10 am

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
SiDay
 
Posts: 6
Joined: Fri Sep 26, 2008 12:01 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: ODBC to MySQL database on Web Server

Postby Graham Smith » Mon May 21, 2012 11:32 am

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.
Graham Smith
DataSmith, Delaware
"For every expert there is an equal and opposite expert.", Arthur C. Clarke (1917 - 2008)
"X-Clacks-Overhead: GNU Terry Pratchett"
User avatar
Graham Smith
 
Posts: 2501
Joined: Fri Sep 07, 2007 11:31 am
Location: Delaware, USA
Has thanked: 0 time
Been thanked: 1 time
 

Re: ODBC to MySQL database on Web Server

Postby SiDay » Mon May 21, 2012 1:08 pm

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
Attachments
NewFfenics.PNG
NewFfenics.PNG (136.57 KiB) Viewed 8767 times
SiDay
 
Posts: 6
Joined: Fri Sep 26, 2008 12:01 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: ODBC to MySQL database on Web Server

Postby SiDay » Fri May 25, 2012 9:42 am

Anyone any ideas - I'm stumped. The connection works with Excel but not Ffenics.
SiDay
 
Posts: 6
Joined: Fri Sep 26, 2008 12:01 pm
Has thanked: 0 time
Been thanked: 0 time
 

Re: ODBC to MySQL database on Web Server

Postby KjetilUrne » Fri May 25, 2012 11:29 am

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).
KjetilUrne
 
Posts: 602
Joined: Mon Oct 08, 2007 8:21 am
Location: Norway
Has thanked: 4 times
Been thanked: 1 time
 
 

Return to Advanced

Who is online

Users browsing this forum: No registered users and 1 guest

cron