Re: Using Microsoft Access as a Front-end to MySQL
I have a solution (part of one). In my situation we use a 3rd party web host that uses cPanel for their web admin gui. The web host has a connection time out set at 60 seconds and they won't change it due to being a shared server. Thus producing the #2006 error "connection has gone away" -cuz it did.
Using ADO I am able to make a connection via the myODBC 5.1 like this;
This is for deleting all the records in a table
-------------------------------------
myodbcconn = "Driver={MySQL ODBC 5.1 Driver};Server=xx.xx.xxx.xx;Port=3306;Database=thmysqldatabasename;User=yourusername; Password=yourpassword;Option=3;"
Dim adoConn As ADODB.Connection
Dim adoRS As ADODB.Recordset
Set adoConn = New ADODB.Connection
Set adoRS = New ADODB.Recordset
Dim strSql As String
strSql = "DELETE yourmysqltable.* FROM yourmysqltable;"
adoConn.Open myodbcconn
adoRS.Open strSql, adoConn
Set adoRS = Nothing
Set adoConn = Nothing
Set adoConn = Nothing
-------------------------------------
I said "part of one" because I'm still working on a way to insert a local source table into the remote mySQL table using ADO
Subject
Views
Written By
Posted
71496
February 14, 2007 01:10PM
18551
July 08, 2007 05:10PM
14290
August 24, 2007 05:57AM
11018
February 06, 2008 01:16PM
7197
September 01, 2009 11:03AM
7401
March 02, 2009 06:09AM
8096
December 01, 2008 01:49PM
5932
May 15, 2009 08:45AM
Re: Using Microsoft Access as a Front-end to MySQL
6127
May 25, 2009 05:12PM
5993
May 26, 2009 11:33AM
6311
April 03, 2009 02:44AM
5693
May 01, 2009 08:36PM
5713
May 02, 2009 04:37AM
5955
June 08, 2009 10:28AM
7449
June 09, 2009 04:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.