MYSQL to MS ACCESS DbLink

Acid0

Acid0

Executive Member
Joined
Feb 10, 2009
Messages
5,900
Reaction score
2,743
Location
Johannesburg
Hi there,

Would any of you be able to point me in the correct direction (If it is even possible to do)

I need to create a Database link from a MYSQL database on a windows machine to a MS Access Database on another Windows machine that is in the same network.

Is it even possible from a MYSQL database to connect to other DB's
I know Oracle can create a dblink.

Regards
 
don't know if it is possible to create a dblink but an alternative will be to write an ETL script in your favorite scripting language and odbc libraries. Obviously, the downside is you will have to schedule a job to keep them in sync. I also like Oracle dblinks but even then it is just between Oracle databases.
 
Thanks for the feedback I need the connection to be from the MYSQL side and not from MS access.

I need to make a connection from inside MYSQL to read and write data back to the MS access database
The ETL is an option but I wonder if it is not over complicating a simple ODBC connection or something like that.

Is it not possible to create a ODBC connection from the MYSQL machine and linking it back to the MS Access Database?
 
You are needing some sort of replication between the two?
 
_neo said:
I'd normally say that postgres could do this...
Click to expand...
...and you would be right. This tech is truly out of this world:

Foreign data wrappers - PostgreSQL wiki

wiki.postgresql.org wiki.postgresql.org

PSQL to PSQL works great, selects, inserts, updates, etc. PSQL to MSSQL seems to only allow reads with my setup.

Not sure about MySQL, but @OP you probably could put PSQL in front of everything and create separate schemas to query the remote MySQL and the MS Access dbs. Not sure about writes tho

EDIT: @_neo looks like that link you posted does use fdw's, although it doesn't explicitly state that postgres is the underlying db
 
Don’t know much about MS Access, other than to steer clear of it :), but it might be easier to knock up a web service that allows data to be retrieved from the access db on the pc hosting the access db ??

I don’t know anyone who uses direct links between databases anymore.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X