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. 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.
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
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.
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.
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
|
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...
| |