 | | | MS Access - Windows ODBC with remote connection to LinuxDatabase | MS Access - Windows ODBC with remote connection to LinuxDatabase 2007-01-15 - By Eric Lommatsch
Back
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@(protected)
-- --Original Message-- --
From: Khalim Harris [mailto:kharris@(protected)]
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_21825303.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@(protected)
>
> -- --Original Message-- --
> From: Khalim Harris [mailto:kharris@(protected)]
> Sent: Friday, January 12, 2007 9:53 AM
> To: myodbc@(protected)
> 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=ericl@(protected)
>
>
>
>
>
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)
|
|
|