473,323 Members | 1,589 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

How I can attach to tables on another machine on my LAN?

MLH
I have a DSL line coming in to my home/office into a
4-port router to which 3 windoze boxes and one linux
box are connected. My window$ boxes all see each
other, but I do not have a facility yet for attaching
the linux box's MySQL tables to the MS Access
database across CAT-5, 10BASE-T cabling.

What's the best recommended approach to attaching
to tables on a PC in the next room across my LAN. Of
course, they are MySQL. If they were MS Access, it
would be easy.
Nov 13 '05 #1
6 1547
MLH,
ODBC Driver? The location on the LAN shouldn't matter. The type of network
cable or connection speed shouldn't be an issue on a lightly loaded network.
Assuming there isn't a huge amount of transaction volume on this database
even a crappy 802.11b wireless connection would work. Access is pretty good
at connecting to and using data from a whole lot of sources, MySQL among
them. I believe it's a matter of finding, installing and configuring an
ODBC driver. But brighter lights than me (Hi, Larry) can help you there.

--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS
"MLH" <CR**@NorthState.net> wrote in message
news:gf********************************@4ax.com...
I have a DSL line coming in to my home/office into a
4-port router to which 3 windoze boxes and one linux
box are connected. My window$ boxes all see each
other, but I do not have a facility yet for attaching
the linux box's MySQL tables to the MS Access
database across CAT-5, 10BASE-T cabling.

What's the best recommended approach to attaching
to tables on a PC in the next room across my LAN. Of
course, they are MySQL. If they were MS Access, it
would be easy.

Nov 13 '05 #2
Alan is right,
Download the windows myodbc drivers from mysql.com and you should have
no trouble connecting using access.
To link them you can setup a dsn or use dao's tabledef.connect property
and with an ado connection string.
HTH
Pachydermitis

Nov 13 '05 #3
MLH
I have attached to MySQL servers in other states and other countries
on the other side of my router. But when I use the MySQL ODBC driver
3.51 to connect on my own LAN, the driver tells me it cannot make the
connection. Here are the ODBC driver connection parms:

Data Source Name: (free field - name my "my linux box" will do nicely)
Host/Server Name (or IP) - something like MS**********@ServerName.net
has worked fine for me in the past. Now I'm trying 192.168.1.106.
Database Name - whatever, mysqldb works fine, any valid db
User - root
Password - myrootpass
Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now
SQL Command On Connect - haven't ever put anything here

Perhaps there is some configuration in mysql user privilege for the
mysqluser "root" that would prevent him from logging from a remote PC
to the mysql server???

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxx

On Wed, 30 Mar 2005 09:22:41 -0500, "Alan Webb" <kn*****@hotmail.com>
wrote:
MLH,
ODBC Driver? The location on the LAN shouldn't matter. The type of network
cable or connection speed shouldn't be an issue on a lightly loaded network.
Assuming there isn't a huge amount of transaction volume on this database
even a crappy 802.11b wireless connection would work. Access is pretty good
at connecting to and using data from a whole lot of sources, MySQL among
them. I believe it's a matter of finding, installing and configuring an
ODBC driver. But brighter lights than me (Hi, Larry) can help you there.


Nov 13 '05 #4
MLH,
All the Unix guys on the 'Net are collectively groaning and shouting. User
name of "root"? Shame on you. Set up an account on the Linux box
specifically for your application that has appropriate priviledges. Try
connecting with that.

--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS
"MLH" <CR**@NorthState.net> wrote in message
news:kr********************************@4ax.com...
I have attached to MySQL servers in other states and other countries
on the other side of my router. But when I use the MySQL ODBC driver
3.51 to connect on my own LAN, the driver tells me it cannot make the
connection. Here are the ODBC driver connection parms:

Data Source Name: (free field - name my "my linux box" will do nicely)
Host/Server Name (or IP) - something like MS**********@ServerName.net
has worked fine for me in the past. Now I'm trying 192.168.1.106.
Database Name - whatever, mysqldb works fine, any valid db
User - root
Password - myrootpass
Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now
SQL Command On Connect - haven't ever put anything here

Perhaps there is some configuration in mysql user privilege for the
mysqluser "root" that would prevent him from logging from a remote PC
to the mysql server???

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxx

On Wed, 30 Mar 2005 09:22:41 -0500, "Alan Webb" <kn*****@hotmail.com>
wrote:
MLH,
ODBC Driver? The location on the LAN shouldn't matter. The type of
network
cable or connection speed shouldn't be an issue on a lightly loaded
network.
Assuming there isn't a huge amount of transaction volume on this database
even a crappy 802.11b wireless connection would work. Access is pretty
good
at connecting to and using data from a whole lot of sources, MySQL among
them. I believe it's a matter of finding, installing and configuring an
ODBC driver. But brighter lights than me (Hi, Larry) can help you there.

Nov 13 '05 #5
MLH
Hey, I hear you. Actually, MySQL user ID's are completely unique,
separate and have nothing to do with Linux OS login's. MySQL
automatically sets up two root accounts. Neither of these have
anything at all to do with the Linux OS root login account.

anonymous may just turn out to be the answer. BTW, I have no
linux login ID named anonymous. Will let you know how it pans out.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xx

On Thu, 31 Mar 2005 08:50:25 -0500, "Alan Webb" <kn*****@hotmail.com>
wrote:
MLH,
All the Unix guys on the 'Net are collectively groaning and shouting. User
name of "root"? Shame on you. Set up an account on the Linux box
specifically for your application that has appropriate priviledges. Try
connecting with that.


Nov 13 '05 #6
MLH,
You sound like a better DBA than this, but pretty much any DBA worth is
title knows the default accounts that get set up at install time so that the
DBA can go in and configure the DBMS instance. Hackers know these accounts
as well. It shouldn't work to try one of the install acounts but boy, if it
does, it makes stealing data such an easy task. I ranted because it's
really lame of a DBA to leave those accounts unchanged once he's made a
first pass at setting up appropriate admin accounts. But I digress . . .
my best guess is that this is a login issue and not so much a network
connectivity or ODBC issue.
--
Alan Webb
kn*******@SPAMhotmail.com
"It's not IT, it's IS
"MLH" <CR**@NorthState.net> wrote in message
news:0f********************************@4ax.com...
Hey, I hear you. Actually, MySQL user ID's are completely unique,
separate and have nothing to do with Linux OS login's. MySQL
automatically sets up two root accounts. Neither of these have
anything at all to do with the Linux OS root login account.

anonymous may just turn out to be the answer. BTW, I have no
linux login ID named anonymous. Will let you know how it pans out.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xx

On Thu, 31 Mar 2005 08:50:25 -0500, "Alan Webb" <kn*****@hotmail.com>
wrote:
MLH,
All the Unix guys on the 'Net are collectively groaning and shouting.
User
name of "root"? Shame on you. Set up an account on the Linux box
specifically for your application that has appropriate priviledges. Try
connecting with that.

Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bob C. | last post by:
In Access 97, I am trying to attach to a table in my SQL Server 2000 db. I use File/Get Data, which displays all the SQL tables including the one I can't attach to. (I can attach to all the...
3
by: Bennett Haselton | last post by:
I'm working on an ASP.Net project where I want to test code on a local machine using a local database as a back-end, and then export it to the production machine where it uses the hosting...
2
by: Bob C. | last post by:
In Access 97, I am trying to attach to a table in my SQL Server 2000 db. I use File/Get Data, which displays all the SQL tables including the one I can't attach to. (I can attach to all the...
2
by: Salad | last post by:
I am having a problem with linking to FoxPro DOS tables in Access2000. Simply opening the tables are EXTREMELY slow. Let me tell you how make my connections to these tables. I could easily be...
4
by: ShyGuy | last post by:
I have a routine that creates a new database and then copies a couple of tables to the new database as backups. It works fine but I want to split the database and run this routine from a machine...
6
by: Charles Law | last post by:
Suppose my application is running on a client machine, and they report an intermittent problem. It only occurs after the program has been running for a while, and then occasionally fails to perform...
7
by: Greg P | last post by:
I know this is a long post, please bear with me. I have been working on this all weekend to no avail although I have done a good amount of research (see most pertinent links that I've looked at...
0
by: Rod | last post by:
I have installed Visual Studio .NET 2003 and 2005 onto my new machine at work. Right now I am trying to debug an ASP.NET 1.1 app to look into an error that a user mentioned. When I do I get the...
3
by: db2admin | last post by:
Hi, is it possible to have certain user create all table and objects in specific tablespace? i mean , when they create table without specifying any tablespace, their tables should go into say...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.