Andreas Schoelver chortled:
How about using a VPN (virtual private network) ?
regards
Andreas
sql,select,mysql
I want to minimize the network structure on their part because they will
have a minimal DSL system as they are on the outskirts of town. As well, I
don't want the bulk of the
Marcus Collins chortled:
(sorry; missed the original post)
If you have admin access to both machines, then how about using stunnel
URL:http://www.stunnel.org/ to set up an SSL-encrypted connection
between both machines on the ports on which mysqld communicates?
There's an example for
I have just started playing with MySQL about a week ago. I have read as
much as I can about optimizing the performance of MySQL and believe I
have everything setup according to the documenation i've read and am
very skilled at Linux.
When we attempt to link a table from MySQL, using the MyODBC
Mark,
Saturday, January 26, 2002, 11:58:47 PM, you wrote:
MS What about converting MySQL data to Oracle ?
In general, mysqldump will help.
MS Mark
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
Hello again all,
Greetings from Scotland.
Can anyone direct me to where I can get some free software which will
convert an MS Access database to My SQL.
Thanks,
James Oliver
-
Before posting, please check:
Hello again all,
Greetings from Scotland.
Can anyone direct me to where I can get some free software which will
convert an MS Access database to My SQL.
Thanks,
James Oliver
-
Before posting, please check:
I Scotland,
It's not the first time i give this adress:
http://www.urbanresearch.com/software/utils/urbsql/
Hope This Help ;)
theOtherOne
- Original Message -
From: oliverjd [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 26, 2002 3:34 AM
Subject: Converting MS Access
At 12:51 PM 1/26/2002 -0800, you wrote:
I Scotland,
It's not the first time i give this adress:
http://www.urbanresearch.com/software/utils/urbsql/
Hope This Help ;)
theOtherOne
It looks like urSQL allows you to view data from various database
formats. Does it handle data conversion as
At 9:59 -0800 1/26/02, Ed Lazor wrote:
At 12:51 PM 1/26/2002 -0800, you wrote:
I Scotland,
It's not the first time i give this adress:
http://www.urbanresearch.com/software/utils/urbsql/
Hope This Help ;)
theOtherOne
It looks like urSQL allows you to view data from various database
formats.
: Converting MS Access to MySQL
At 9:59 -0800 1/26/02, Ed Lazor wrote:
At 12:51 PM 1/26/2002 -0800, you wrote:
I Scotland,
It's not the first time i give this adress:
http://www.urbanresearch.com/software/utils/urbsql/
Hope This Help ;)
theOtherOne
It looks like urSQL allows you
Subject: Re: Converting MS Access to MySQL
At 9:59 -0800 1/26/02, Ed Lazor wrote:
At 12:51 PM 1/26/2002 -0800, you wrote:
I Scotland,
It's not the first time i give this adress:
http://www.urbanresearch.com/software/utils/urbsql/
Hope This Help ;)
theOtherOne
It looks like urSQL allows
At 14:58 -0700 1/26/02, Mark Stringham wrote:
What about converting MySQL data to Oracle ?
There's something for this somewhere on Oracle's web site.
That's all I know, never used it.
-
Before posting, please check:
have on this: have you already ported
databases from Access to Mysql on PHP sites, and how much did the
performance increase (due only to this of course)?
2) Any benchmark available online on this. Myself, I know I can trust
you, but the customer will be much easier to persuade if he can
Vernon A Webb writes:
I have setup a database that GRANTs a specific user access
to a database, which is theirs and will be their
responsibility to manage.
They have privileges on that database only. Using MySQLGUI
they can log in and manage that database, but from the drop-
down menu
I have setup a database that GRANTs a specific user access
to a database, which is theirs and will be their
responsibility to manage.
They have privileges on that database only. Using MySQLGUI
they can log in and manage that database, but from the drop-
down menu they also see the other
I need to convert ms access to mysql.
Has anyone done this successfully ??
thanks
=
Regards,
Investorclb
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
Steve, Doug Gordan,
Thanks for taking the time to help me.
Billy
- Original Message -
From: Steve Rapaport [EMAIL PROTECTED]
To: Billy Reed [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, December 28, 2001 2:17 AM
Subject: Re: MS Access to MySQL convert
Instead of TOP 5
pilot) and then sums the result for
each pilot. Subsequent code writes this to a new table showing who is in the
lead !!
Can anyone suggest how this is done in MySQL. It doesnt seem to like the TOP
5 syntax.
I have been able to convert the rest of my site from MS Access to MySQL but
am struggling
On Thursday 27 Dec 2001 23:31, Billy Reed wrote:
I am new to MySQL and am trying to convert :
SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague
WHERE LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC)
Can anyone suggest how this is done in MySQL. It doesnt seem to
which was the fastest but still slower than MS
access file it's self, Especially using Continuous Forms
My question is : (I'm not an expert, I know just enough to setup simple data
base and use it..)
What am I doing wrong?
Are there some settings in access, ODBC or mySQL I do not know of..
Or perhaps
of the decimal fields in access and make sure you change the
default settings in MyAccess.
On Tue, 11 December 2001, Rosyna wrote:
Is it possible to export a database from mysql so MS Access can read
it as its own? I am not able to install MyODBC on the windows box
(not admin)
--
Sincerely
Is it possible to export a database from mysql so MS Access can read
it as its own? I am not able to install MyODBC on the windows box
(not admin)
--
Sincerely,
Rosyna Keller
Technical Support/Holy Knight/Always needs a hug
Unsanity: Unsane Tools for Insane People
Hello everyone,
I'm trying to grant rights to several user accessing my database.
Right now I'm using their individual IP addresses to grant them privileges. Which
works fine.
This way I have to assign user name and password to each and everyone of them.
What I want is to enable everyone
Did you Flush your table when you changed permissions?
Hello everyone,
I'm trying to grant rights to several user accessing my database.
Right now I'm using their individual IP addresses to grant them
privileges. Which works fine. This way I have to assign user name and
password to each
SAE's System Administrator writes:
Hello all,
I just installed a Suse 7.2 Linux, with MySql..
MySQL runs, but when i try to access it, i get the following message:
cleopatra:/usr/bin # mysql -h localhost -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost'
Hello all,
I just installed a Suse 7.2 Linux, with MySql..
MySQL runs, but when i try to access it, i get the following message:
cleopatra:/usr/bin # mysql -h localhost -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
cleopatra:/usr/bin #
cleopatra:/usr/bin # mysql -h localhost -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
cleopatra:/usr/bin # mysql -h localhost -u root -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Try
Hello Carsten,
Tuesday, November 13, 2001, 9:48:56 PM, you wrote:
CHP Try running w/o -p
cleopatra:/usr/bin # mysql -h localhost -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
;(
--
Best regards,
SAE's System Administrator
[EMAIL PROTECTED]
World
Hello,
apart from performance issues, is it possible in PHP to read/write a
MYSQL DB not directly, but via ODBC? The reason (as states in my other
message MS ACCESS on Linux) is that it would make possible to test on
Linux PHP code that would eventually manage (wit xero or minimal changes)
an MS
-Original Message-
From: mweb [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 10:23 AM
To: phplist; mysqllist
Subject: [PHP] Access to MYSQL via ODBC?
Hello,
apart from performance issues, is it possible in PHP to read/write a
MYSQL DB not directly, but via ODBC
GREAT, THANK YOU!
Now the only step left is how to convert (on Linux) the MS access
database to MySQL...How?
mweb
-- Initial message ---
From: Andrew Hill [EMAIL PROTECTED]
To : mweb [EMAIL PROTECTED], phplist [EMAIL PROTECTED],
mysqllist
PROTECTED]]
Sent: Tuesday, November 13, 2001 10:45 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP] Access to MYSQL via ODBC?
GREAT, THANK YOU!
Now the only step left is how to convert (on Linux) the MS access
database to MySQL...How?
mweb
solution would have been to leave the access DB
run on the Win machine, and access it via ODBC from the Linux one without MySQL at all.
Sometime ago I heard a tool that converted offline Access files
to MySQL ones but can't find it again now. Is it still around? Has
anybody used
Mweb,
This access to mysql conversion tool is availabe at the MySQL site - check
the contributed software section for a couple of options.
Alternatively, just run both MySQL and Access on Windows, and access it via
ODBC.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink
access on NT/IIS.
While the theory behind this is sound, a quick caveat: Access' SQL is
way out in left field somewhere, and you might find you
need to do considerable tweaking to get the same results out of Access
MySQL.
You might want to consider some sort of db abstraction
11:00:05 -0500
Subject : RE: [PHP] Access to MYSQL via ODBC?
Mweb,
This access to mysql conversion tool is availabe at the MySQL site - check
the contributed software section for a couple of options.
Alternatively, just run both MySQL and Access on Windows, and access it via
ODBC.
Best
The best way I've found to convert MS Access to mySQL is via ODBC.
1. Just set up ODBC on Windows (an easy install process - just run the
install program that you can download from MS)
2. Install MyODBC (you can download this from MySQL's site - somewhere in
their downloads section)
3. Go
Look for unixODBC on http://www.sourceforge.com
Peter
-Original Message-
From: mweb [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 7:23 AM
To: phplist; mysqllist
Subject: Access to MYSQL via ODBC?
Hello,
apart from performance issues, is it possible in PHP to read/write
The last time I checked, the windows version of PHP had MySQL support
built in.
Curtis
On Tue, 13 Nov 2001, mweb wrote:
Hello,
apart from performance issues, is it possible in PHP to read/write a
MYSQL DB not directly, but via ODBC? The reason (as states in my other
message MS ACCESS
There are scripts available at MySQL.com to perform the task.
Curtis
On Tue, 13 Nov 2001, mweb wrote:
GREAT, THANK YOU!
Now the only step left is how to convert (on Linux) the MS access
database to MySQL...How?
mweb
-- Initial message ---
From
Hello,
I have another question about the situation explained in my other message Keeping SQL
DBs separated.
If it's not possible reconfigure SQL on the ISP server, then I
will have to test on Linux/Apache some PHP/MySQL pages that will
have to access via ODBC a MS Access database on an
mweb,
To make sure I understand you correctly, you want to create
and
test your PHP/MySQL database on your Linux/Apache box, then upload it
to
your ISP server that is running PHP/Access? I'm sorry but that's not
going
to work. You can't transparently switch a PHP application from MySQL
application from MySQL
to
Access.
Yes, you did understand me correctly.
What I understand ( and could certainly be wrong) is that there are in
PHP layers of abstraction/wrappers/APIs or whatever you call them,
that allow you to do just that, i.e. to write code that is obviously
want to create
and
test your PHP/MySQL database on your Linux/Apache box, then upload it
to
your ISP server that is running PHP/Access? I'm sorry but that's not
going
to work. You can't transparently switch a PHP application from MySQL
to
Access.
Yes, you did understand me
that is running PHP/Access? I'm sorry but that's not
going
to work. You can't transparently switch a PHP application from MySQL
to
Access.
Yes, you did understand me correctly.
What I understand ( and could certainly be wrong) is that there are in
PHP layers of abstraction
Hello everyone,
I too, am in a simular position, though not a business venture.
I have some private databases that I would like to port to MySQL
from MS Access 2000. If you know of any tools that will export all
the tables and queries to a MySQL equivlent, and convert the forms
to html, php
I am new to this fast database and love MySQL, but I need to know how to
import or convert Access database to MySQL. ANyone know how I would go
about that? Also this is for a web site and I need to change the asp
code to PHP. Its not a lot, only a few pages, but its a headache for
someone
try this:
http://www.mysql.com/downloads/contrib.html#SEC653
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:12 PM
To: [EMAIL PROTECTED]
Subject: MS Access to MySQL conversion? How?
I am new to this fast database and love MySQL
The Jonathan Tutorial
Access -2- MySQL in 8 Not-Extremely-Easy-But-Not-Hard Steps
1. Go to mysql.com
2. Download and install MyODBC
3. Set up a new ODBC connection for the new mySQL server
4. Open up the database in access
5. Go to the File menu and choose to Export (Tables?)
6. At the bottom
I used MyAccess2000, it connects through ODBC inside Access. You can create
tables, import Access to MySQL or MySQL to Access and it will display table
SQL and indexes, its $30usd http://www.accessmysql.com/
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent
Stephen Johnson wrote:
I have a client that uses an Access dB in house and wants that database to
automatically update a MySQL database that I am creating for their website.
Is this possible and if so where can I find some reading material on how to
accomplish it?
Thanks for the
Anyone can tell me how can i import an access db to mysql.
Thanks in advance,
Gabriel.
At 09:43 AM 8/21/01 -0300, Gabriel wrote:
Anyone can tell me how can i import an access db to mysql.
Thanks in advance,
Gabriel.
Convert the access data into text file, comma separated (CSV)
then use LOAD DATA INFILE c:\textfile INTO TABLE table_name
You can get additional hints using Google
snip
Anyone can tell me how can i import an access db to mysql.
/snip
Go to http://www.mysql.com/downloads/contrib.html. Many contributed tools
plus a couple of macros that are run from within Access.
Jay Fesco
-
Before
from Access to MySql
Anyone can tell me how can i import an access db to mysql.
Thanks in advance,
Gabriel.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi all,
There are a mysql fornt for windows named mysqlfront with the option of
import acces databases into mysql.
And it works.!!
- Original Message -
From: Gabriel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 21, 2001 2:43 PM
Subject: Import from Access to MySql
?
Hi !
Can you send me the ODBC trace ?
Thanks in advance
venu
-Original Message-
From: Adam Douglas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 10:52 AM
To: '[EMAIL PROTECTED]'
Subject: Access to MySQL Column Type Error
I'm trying to do an append query
Hi !
Can you send me the ODBC trace ?
Thanks in advance
venu
-Original Message-
From: Adam Douglas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 10:52 AM
To: '[EMAIL PROTECTED]'
Subject: Access to MySQL Column Type Error
I'm trying to do an append query in Access
Hi,
I have an access database in MSAccess 2000 and I am trying to
export tables into mySQL database. I can import tables in MSAccess
but cannot export table.
When I try to export the table , I get the following error:
ODBC--call failed.
[Microsoft][Gestionnaire de pilotes ODBC ]
Type
Hello,
I have made an access database in MSAccess 2000 and I am trying to
export tables into mySQL database. The problem is, I can export tables with
numbers but cannot export table with text or anything. When I try to
export the table with a text column, I get the following error:
9:21 PM
Subject: exporting tables from MS access to mysql
Hello,
I have made an access database in MSAccess 2000 and I am trying to
export tables into mySQL database. The problem is, I can export tables
with
numbers but cannot export table with text or anything. When I try to
export
MySQL doesn't support certain features such as foreign keys and sub-selects
but may do so in the future. This is documented in the mysql manual.
MS Access is not very suitable for networks especially on a large scale.
- Original Message -
From: Wavyx [EMAIL PROTECTED]
To: [EMAIL
Now that the mess with starting the server is over, I cannot access it.
After installing the rpm files, I initialize the grant tables with
mysql_install_db.
Then I type:
mysql -u root mysql
The result is: ERROR 1045: Access denied for user: 'root@localhost' (Using
password: NO)
Typing mysql
-
From: Simon Chan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 9:46 PM
To: Brian Walker
Cc: [EMAIL PROTECTED]
Subject: Re: Cannot gain access to MySQL server
Brian,
When you run the mysql_install_db bit, a root user is created (username =
root...imagine
Brian,
When you run the mysql_install_db bit, a root user is created (username =
root...imagine that!)
But, there is no password for this root user. You have to set this password yourself.
Here's how to do it:
1. $ bin/mysqladmin -u root -p password 'enter_new_password_here'
Then, try this:
Howdy,
I currently have an application which uses DAO and ADO coding in VBA/VB as
well as databound objects in VB to access a MS Access database. Can DAO and
ADO in VBA/VB and databound objects in VB be made to work with a MySQL
database?
Anybody done this successfully?
Cheers,
Mike
Yes it can, via ODBC.
I've never done it though. (I don't work in VB)
Cal
- Original Message -
From: Thompson, Mike [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 12:37 PM
Subject: VBA/VB DAO/ADO MS Access to MySQL?
Howdy,
I currently have an application which
to the backend...
Good Luck.
ChrisB
MCSE MCDBA
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 11:14 AM
To: Thompson, Mike; [EMAIL PROTECTED]
Subject: Re: VBA/VB DAO/ADO MS Access to MySQL?
Yes it can, via ODBC.
I've never done it though. (I don't
This works fine from VB6. Install the MyODBC driver (get it from the
MySQL web site), then set up a datasource just as you usually would.
Ideally, you won't have to change any of your VB code - just bind the
ADO/DAO controls to the MySQL datasource rather than the Access
datasource.
Note
**
Beridney Computer Services
http://www.beridney.com
- Original Message -
From: Thompson, Mike [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 10:37 AM
Subject: VBA/VB DAO/ADO MS Access to MySQL?
Howdy,
I currently have an application which uses DAO and ADO coding
PROTECTED]
Subject: Porting Access to MySQL
Hi, I have a user who want to move there database from Access to MySQL.
Are there tools available to make the conversion simple, or what is the
best way of going about this?
Thanks
hello all
this is to inform u that i am running mysql 3.23.26 on linux 7.1 redhat but some
problem with the mysql demon
i am not able to stop the service through /etc/inet.d/mysqld
it is showing serviece failed
can any aone help me
Thanking You,
CBayScribe SysAdmin,
CBayScribe Support.
!
Hi!
The above error has nothing to do with mysqlgui.
The above error means that you have not set up privileges so that your
user can connect from the computer on which mysqlgui runs.
Read the manual on the MySQL access system.
Regards,
Sinisa
I have found an isp that will leave port 3306 open for me to talk to the mysql server,
my question is
Is anything sent over this connection secure, if not is there some way of encrypting
it such as ssl?
Cyber Monkey wrote:
I have found an isp that will leave port 3306 open for me to talk to the mysql
server, my question is
Is anything sent over this connection secure, if not is there some way of encrypting
it such as ssl?
Yes.. you ssh like here
www.ssh.com
www.openssh.org
and do
Hi, I have a user who want to move there database from Access to MySQL.
Are there tools available to make the conversion simple, or what is the
best way of going about this?
Thanks
-
Before posting, please check:
http
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 6:43 PM
To: [EMAIL PROTECTED]
Subject: Porting Access to MySQL
Hi, I have a user who want to move there database from Access to MySQL.
Are there tools available to make the conversion simple, or what is the
best way of going about this?
Thanks
I am trying to see if I can communicate with a MySQL on Free BSD from the
MySQL GUI client on my Windows NT.
The GUI client cannot connect because the MySQL seems to be refusing this
connection. This does not seem to be server-related, but related to MySQL
itself, since, when I try to telnet in
upload the database?
And where are you getting the error from, that error is from Access
not mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
, that error is from Access
not mysql?
--
Chris Wilkinson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
just upload the database?
And where are you getting the error from, that error is from Access
not mysql?
--
Chris Wilkinson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
. You cannot upload
an Access DB to a MySQL server. You can upload and insert the data, you
can write some program to make calls to both DBs and insert the data
but you can't just upload the database?
And where are you getting the error from, that error is from Access
not mysql
Hello MySQL,
We are a company that is considering a change to the MySQL database.
Due to the fact that we got a lot of MS-access databases around here we want
to ask you about the possibilities to converte MS-access databases to mySQL.
I m interested in the bugs that is known ( loosing
[EMAIL PROTECTED] writes:
Hello MySQL,
We are a company that is considering a change to the MySQL database.
Due to the fact that we got a lot of MS-access databases around here we want
to ask you about the possibilities to converte MS-access databases to mySQL.
I m interested
Why is myODBC so hard to get working on different computers?
I just had to reinstall Win 95 Office 97 on one of our test computers AND
Win 98 with Office 2000 on another (due to virus hits on our network)...
Now, since then, we cannot update our mySQL database from either of them.
Fortunately,
to everyone who tried to help.
Martin.
-Original Message-
From: Bruce Stewart [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 12:43
To: 'Martin E. Koss'
Subject: RE: myODBC from Access to mySQL (Failing)
Hi Martin,
I'm fairly new to MySQL, have had similar hassles, and I think I've resolved
Dear Sir/Madam
I just know that there is a tool to convert database from MS Access
to Mysql, But I do not know the URL of this tool. Could you tell me this
URL? Thanks
Regards
Taing Nguon
-
Before posting, please check
At 8:37 AM +0700 5/4/01, Taing Nguon wrote:
Dear Sir/Madam
I just know that there is a tool to convert database from MS Access
to Mysql, But I do not know the URL of this tool. Could you tell me this
URL? Thanks
Check this page and look in the converters section. Might be what you
want
Hi
Start a mysql client session by entering mysql at the command prompts, then
you'll be able to enter SQL statemeents.
At 21:42 18/04/2001 +, [EMAIL PROTECTED] wrote:
Hi guys,
I have created databae of mysql on redhat 7. I want to access my
database by command promt can any body
HHG You must go to control panel of windows in Data Sources(ODBC) section and add
your DSN of you new MySQL database and then you can explor the database by browsing
your ODBC avilable databases .
HHG You can check MyODBC manual for this .
Yes, this worked for me too.
However ... I can only
L Ok i'm still a little bit lost. I have a database in MySQL called "irm"
L In the ODBC Data Source 32 bit I went in user dsn and added user data source
L called irm the driver is mysql
L not this is were i dont understand .
L In the field that says Windwos DSN name I put "irm"
L MySQL I put
in access File MenuExport or Import, depending which
way youre goin' Follow on screen inst.
scott
At 03:06 PM 4/3/01, you wrote:
Ok i'm still a little bit lost. I have a database in MySQL called "irm"
In the ODBC Data Source 32 bit I went in user dsn and added user data
Good morning all, last night I installed MyODBC on my laptop. What i dont
understand is how do i connect threw access now?
I'm a little confuse, can anyone help me understand how MyODBC works.
luis
-
Before posting, please
Luis wrote:
Good morning all, last night I installed MyODBC on my laptop. What i dont
understand is how do i connect threw access now?
I'm a little confuse, can anyone help me understand how MyODBC works.
luis
It is an ODBC driver for Mysql.
Create a databsae in mysql
go to the ODBC
Hi ,
You must go to control panel of windows in Data Sources(ODBC) section and add your DSN
of you new MySQL database and then you can explor the database by browsing your ODBC
avilable databases . You can check MyODBC manual for this .
On Tue, Apr 03, 2001 at 06:55:52AM -1000, Luis wrote:
Ok i'm still a little bit lost. I have a database in MySQL called "irm"
In the ODBC Data Source 32 bit I went in user dsn and added user data source
called irm the driver is mysql
not this is were i dont understand .
In the field that says Windwos DSN name I put "irm"
MySQL I put the ip
In the field were "Windows DSN name" what do I put there.
Also if i just created a database in mysql called customer
would i put the that name in "MySQL database Name"
-
Before posting, please check:
Hello to all, I was wondering if anyone could help me out with a little project i
have going. I have a database in access 7.0 I would like to transfor all the
fields, tables, plus information it has to mysql running on a linux box (rh 7.0)
running mysql.
now how would i go about that?
is there
Luis,
This is an easy one.
Go here ftp://ftp.informate.co.nz/pub/ and download one of the scripts, the
instructions are in the script. It will create a text file that has the sql
commands needed to create and fill your mySQL tables with your Access info.
You can exec the script from the mySQL
Thank you for the help, but I'm a newbie on MySQL . Some of the stuff i been
reading tells me to download MyODBC or i could make a txt file out of access
when exporting.
If i try to inport a all the fields from access to mysql do i have to create a
database plus tables that are the same
201 - 300 of 321 matches
Mail list logo