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
 
[email protected]

-----Original Message-----
From: Khalim Harris [mailto:[email 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
>  
> [email protected]
> 
> -----Original Message-----
> From: Khalim Harris [mailto:[email protected]]
> Sent: Friday, January 12, 2007 9:53 AM
> To: [email 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/[email protected]
> 
> 
> 
> 
> 




-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]