RE: MS Access - Windows ODBC with remote connection to LinuxDatabase

=20
I am not suggesting Reinstalling Access, If you read down to the bottom =
Of
the post that the link was to, what I wound up having to do was to
programitically create the links to the MySQL database using VBA. Given =
the
constraints of the client site that was the only way I could get it to =
work.=20

Thank you
=20
Eric H. Lommatsch
Programmer
360 Business=20
2087 South Grant Street
Denver, CO 80210
Tel 303-777-8939
Fax 303-778-0378
=20
ericl@360b.com

-----Original Message-----
From: Khalim Harris [mailto:kharris@winkinternational.com]=20
Sent: Monday, January 15, 2007 3:40 AM
To: Eric Lommatsch
Subject: RE: MS Access - Windows ODBC with remote connection to =
LinuxDatabase

Hi Eric. And thank you for your response. I've been reluctant to =
reinstall
Access on that machine though - We're running some 3rd party software on
there that requires a specific setup. If that's what you're suggesting,
please acknowledge. I'd just have to do that as the two machines are on =
the
same network (for now) and I think I've tried everything else you've
discussed before.

Thanks again,
Khalim


On Fri, 2007-01-12 at 15:30 -0700, Eric Lommatsch wrote:
> Hello Khalim,
>=20
> I ran into this problem at one of my clients sites when they changed=20
> windows servers to a windows 2003 server with Service Pack 1 Installed =

> On it. The problem primarily is that when Service pack 1 was installed =

> it caused problems for the MyODBC 3.51 software. Since I figured out=20
> this problem in April I have seen similar posts to this list =
describing
similar problems.
> This link points to a web page that describes what I did to get MySQL=20
> tables into MS Access.
>=20
> http://www.experts-exchange.com/Databases/MS_Access/Q_218253 03.html
>=20
>=20
> Thank you
> =20
> Eric H. Lommatsch
> Programmer
> 360 Business
> 2087 South Grant Street
> Denver, CO 80210
> Tel 303-777-8939
> Fax 303-778-0378
> =20
> ericl@360b.com
>=20
> -----Original Message-----
> From: Khalim Harris [mailto:kharris@winkinternational.com]
> Sent: Friday, January 12, 2007 9:53 AM
> To: myodbc@lists.mysql.com
> Subject: MS Access - Windows ODBC with remote connection to Linux=20
> Database
>=20
> Hi List. Please help... I've read up on this for days and days and I=20
> feel like I'm missing something because other people have had so much=20
> more successs than I have.
>=20
> My Request is this:
>=20
> Please describe to me any steps that I may be missing in my=20
> installation / configuration / setup of MyODBC, MS Access 2003, ODBC=20
> DSN in order to make the linking of my databases more successful.
>=20
> I need to either link to or export some MS Access2003 Tables to a=20
> Linux MySQL database. I've tried several times and in many different=20
> ways to do so using MyODBC 3.51 and 5.0. connecting to a MySQL 5.0=20
> database (Currently running on my desktop CentOS4.3 box).
>=20
> Using MyODBC 3.51 crashes Access to where it tells me it must shut=20
> down and restart. This happens about 4 seconds after choosing the=20
> MyODBC 3.51 Resource to connect to.
>=20
> Using MyODBC 5.0 works to a limited extent. Only small tables can be=20
> linked to (less than 5 columns) and even then only with numeric and=20
> varchar definitions... and no keys. I've managed to link 1 table with =
9
columns...
> but that table was empty.
>=20
>=20
> Again, My Request is:
>=20
> Please describe to me any steps that I may be missing in my=20
> installation / configuration / setup of MyODBC, MS Access 2003, ODBC=20
> DSN in order to make the linking of my databases more successful.
>=20
> Thank you all for any help,
> Khalim
>=20
>=20
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: =
http://lists.mysql.com/myodbc?unsub=3Dericl@micronix.com
>=20
>=20
>=20
>=20
>=20




--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg