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

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.

Thank you

Eric H. Lommatsch
Programmer
360 Business
2087 South Grant Street
Denver, CO 80210
Tel 303-777-8939
Fax 303-778-0378

ericl [at] 360b.com

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




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