Re: Access to MYSQL via ODBC?

2001-11-13 Thread SAE's System Administrator

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 # mysql -h localhost -u root -p
Enter password: 
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

is there any way to change/reset the password if any or am i doing
something wrong ?


-- 
Best regards,
 SAE's System Administrator
 [EMAIL PROTECTED]
 World Council of Hellenes Abroad
 2 Komotinis str.
 54655 - Thessaloniki
 GREECE





--__--__--__--
This message was passed through SAE's Mailgate Server. 
Our MailGate Server employs the latest antivirus  antispam technology.
Please report any errors to [EMAIL PROTECTED]

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Access to MYSQL via ODBC?

2001-11-13 Thread Carsten H. Pedersen

 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 running w/o -p

 is there any way to change/reset the password if any or am i doing
 something wrong ?

http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0

/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re[2]: Access to MYSQL via ODBC?

2001-11-13 Thread SAE's System Administrator

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 Council of Hellenes Abroad
 2 Komotinis str.
 54655 - Thessaloniki
 GREECE





--__--__--__--
This message was passed through SAE's Mailgate Server. 
Our MailGate Server employs the latest antivirus  antispam technology.
Please report any errors to [EMAIL PROTECTED]

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Access to MYSQL via ODBC?

2001-11-13 Thread mweb

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 access on NT/IIS.

Is it possible?

mweb


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread Andrew Hill

Sure, this is entirely possible.
Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then
install the MyODBC driver.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access  Data Integration Technology Providers

 -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? 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 access on NT/IIS.

   Is it possible?

   mweb


 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]






-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread mweb

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 [EMAIL PROTECTED]
 Cc  :
 Date: Tue, 13 Nov 2001 10:27:15 -0500
 Subject : RE: [PHP] Access to MYSQL via ODBC?

 Sure, this is entirely possible.
 Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then
 install the MyODBC driver.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread Andrew Hill

Mweb,

Same --with-iodbc, just install a different ODBC driver.
Use the OpenLink Multi-Tier driver, piggybacked on the MS Access driver.

Install the Multi-Tier driver with Linux as your client, Win32 as your
server, and Access as your db.

Then:
1. configure a system DSN on the Win32 box using the ODBC Administrator and
the MS driver for Access. For the example we'll call it foo.
2. configure a DSN on the Linux box in the odbc.ini file.  ServerType =
ODBC, Hostname = [win32 ip address], Database = foo.
All other parameters should be self-explanatory.

Connections may be verified using odbctest application.
Be sure to use the syntax DSN=DSN_NAME in odbctest.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access  Data Integration Technology Providers

 -Original Message-
 From: mweb [mailto:[EMAIL 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

  -- Initial message ---
 
  From: Andrew Hill [EMAIL PROTECTED]
  To  : mweb [EMAIL PROTECTED], phplist
 [EMAIL PROTECTED],mysqllist [EMAIL PROTECTED]
  Cc  :
  Date: Tue, 13 Nov 2001 10:27:15 -0500
  Subject : RE: [PHP] Access to MYSQL via ODBC?
 
  Sure, this is entirely possible.
  Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then
  install the MyODBC driver.







-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread mweb

Andrew,

thanks again for your lightning fast answers. However, I realize that
I did not explain the problem completely. Part of it is that I don't
have the possibility to network one Win computer and a Linux one.

I only have either Linux or Windows, in any given moment:-((
Otherwise another 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 it?


 -- Initial message ---

 From: Andrew Hill [EMAIL PROTECTED]
 To  : mweb [EMAIL PROTECTED]
 Cc  : [EMAIL PROTECTED], [EMAIL PROTECTED]
 Date: Tue, 13 Nov 2001 10:48:52 -0500
 Subject : RE: [PHP] Access to MYSQL via ODBC?

 Mweb,

 Same --with-iodbc, just install a different ODBC driver.
 Use the OpenLink Multi-Tier driver, piggybacked on the MS Access driver.

 Install the Multi-Tier driver with Linux as your client, Win32 as your
 server, and Access as your db.

 Then:
 1. configure a system DSN on the Win32 box using the ODBC Administrator and
 the MS driver for Access. For the example we'll call it foo.
 2. configure a DSN on the Linux box in the odbc.ini file.  ServerType =
 ODBC, Hostname = [win32 ip address], Database = foo.
 All other parameters should be self-explanatory.

 Connections may be verified using odbctest application.
 Be sure to use the syntax DSN=DSN_NAME in odbctest.

 Best regards,
 Andrew Hill
 Director of Technology Evangelism
 OpenLink Software  http://www.openlinksw.com
 Universal Data Access  Data Integration Technology Providers

  -Original Message-
  From: mweb [mailto:[EMAIL 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
 
   -- Initial message ---
  
   From: Andrew Hill [EMAIL PROTECTED]
   To  : mweb [EMAIL PROTECTED], phplist
  [EMAIL PROTECTED],mysqllist [EMAIL PROTECTED]
   Cc  :
   Date: Tue, 13 Nov 2001 10:27:15 -0500
   Subject : RE: [PHP] Access to MYSQL via ODBC?
  
   Sure, this is entirely possible.
   Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then
   install the MyODBC driver.
 
 
 
 





-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread Andrew Hill

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 Software  http://www.openlinksw.com
Universal Data Access  Data Integration Technology Providers

 -Original Message-
 From: mweb [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 13, 2001 11:02 AM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: RE: [PHP] Access to MYSQL via ODBC?


 Andrew,

 thanks again for your lightning fast answers. However, I realize that
 I did not explain the problem completely. Part of it is that I don't
 have the possibility to network one Win computer and a Linux one.

 I only have either Linux or Windows, in any given moment:-((
 Otherwise another 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 it?


  -- Initial message ---
 
  From: Andrew Hill [EMAIL PROTECTED]
  To  : mweb [EMAIL PROTECTED]
  Cc  : [EMAIL PROTECTED], [EMAIL PROTECTED]
  Date: Tue, 13 Nov 2001 10:48:52 -0500
  Subject : RE: [PHP] Access to MYSQL via ODBC?
 
  Mweb,
 
  Same --with-iodbc, just install a different ODBC driver.
  Use the OpenLink Multi-Tier driver, piggybacked on the MS
 Access driver.
 
  Install the Multi-Tier driver with Linux as your client, Win32 as your
  server, and Access as your db.
 
  Then:
  1. configure a system DSN on the Win32 box using the ODBC
 Administrator and
  the MS driver for Access. For the example we'll call it foo.
  2. configure a DSN on the Linux box in the odbc.ini file.  ServerType =
  ODBC, Hostname = [win32 ip address], Database = foo.
  All other parameters should be self-explanatory.
 
  Connections may be verified using odbctest application.
  Be sure to use the syntax DSN=DSN_NAME in odbctest.
 
  Best regards,
  Andrew Hill
  Director of Technology Evangelism
  OpenLink Software  http://www.openlinksw.com
  Universal Data Access  Data Integration Technology Providers
 
   -Original Message-
   From: mweb [mailto:[EMAIL 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
  
-- Initial message ---
   
From: Andrew Hill [EMAIL PROTECTED]
To  : mweb [EMAIL PROTECTED], phplist
   [EMAIL PROTECTED],mysqllist
 [EMAIL PROTECTED]
Cc  :
Date: Tue, 13 Nov 2001 10:27:15 -0500
Subject : RE: [PHP] Access to MYSQL via ODBC?
   
Sure, this is entirely possible.
Configure PHP --with-iodbc as per the HOWTO at
www.iodbc.org and then
   install the MyODBC driver.
 
 
 
 





--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread Jon Haworth

 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 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 layer to make the
transition a bit easier - it's more work up front, but the benefits are many
:-)

Cheers
Jon


**
'The information included in this Email is of a confidential nature and is 
intended only for the addressee. If you are not the intended addressee, 
any disclosure, copying or distribution by you is prohibited and may be 
unlawful. Disclosure to any party other than the addressee, whether 
inadvertent or otherwise is not intended to waive privilege or confidentiality'

**

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread mweb

Yes I found it!!:

http://www.cynergi.net/exportsql/

thanks you again!!

mweb



 -- Initial message ---

 From: Andrew Hill [EMAIL PROTECTED]
 To  : mweb [EMAIL PROTECTED]
 Cc  : [EMAIL PROTECTED], [EMAIL PROTECTED]
 Date: Tue, 13 Nov 2001 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 regards,
 Andrew Hill
 Director of Technology Evangelism
 OpenLink Software  http://www.openlinksw.com
 Universal Data Access  Data Integration Technology Providers

  -Original Message-
  From: mweb [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, November 13, 2001 11:02 AM
  To: [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
  Subject: RE: [PHP] Access to MYSQL via ODBC?
 
 
  Andrew,
 
  thanks again for your lightning fast answers. However, I realize that
  I did not explain the problem completely. Part of it is that I don't
  have the possibility to network one Win computer and a Linux one.
 
  I only have either Linux or Windows, in any given moment:-((
  Otherwise another 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 it?
 
 
   -- Initial message ---
  
   From: Andrew Hill [EMAIL PROTECTED]
   To  : mweb [EMAIL PROTECTED]
   Cc  : [EMAIL PROTECTED], [EMAIL PROTECTED]
   Date: Tue, 13 Nov 2001 10:48:52 -0500
   Subject : RE: [PHP] Access to MYSQL via ODBC?
  
   Mweb,
  
   Same --with-iodbc, just install a different ODBC driver.
   Use the OpenLink Multi-Tier driver, piggybacked on the MS
  Access driver.
  
   Install the Multi-Tier driver with Linux as your client, Win32 as your
   server, and Access as your db.
  
   Then:
   1. configure a system DSN on the Win32 box using the ODBC
  Administrator and
   the MS driver for Access. For the example we'll call it foo.
   2. configure a DSN on the Linux box in the odbc.ini file.  ServerType =
   ODBC, Hostname = [win32 ip address], Database = foo.
   All other parameters should be self-explanatory.
  
   Connections may be verified using odbctest application.
   Be sure to use the syntax DSN=DSN_NAME in odbctest.
  
   Best regards,
   Andrew Hill
   Director of Technology Evangelism
   OpenLink Software  http://www.openlinksw.com
   Universal Data Access  Data Integration Technology Providers
  
-Original Message-
From: mweb [mailto:[EMAIL 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
   
 -- Initial message ---

 From: Andrew Hill [EMAIL PROTECTED]
 To  : mweb [EMAIL PROTECTED], phplist
[EMAIL PROTECTED],mysqllist
  [EMAIL PROTECTED]
 Cc  :
 Date: Tue, 13 Nov 2001 10:27:15 -0500
 Subject : RE: [PHP] Access to MYSQL via ODBC?

 Sure, this is entirely possible.
 Configure PHP --with-iodbc as per the HOWTO at
 www.iodbc.org and then
install the MyODBC driver.
  
  
  
  
 
 
 


 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]






-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread Jonathan Hilgeman

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 into Control Panel--ODBC.

4. Set up a new ODBC connection using the mySQL driver and have it connect
to your MySQL database.

5. Open up your Access database, and go to the File menu, and choose to
Export your tables.

6. In the drop-down list of exportable formats, you can find ODBC
Datasource at the very bottom. Choose that and you'll be able to select the
MySQL ODBC connection you set up. From there, exporting can take merely
seconds to fully reconstruct a whole table with data.

Microsoft did a pretty good job on this one.

- Jonathan

-Original Message-
From: mweb [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 7: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

 -- Initial message ---
 
 From: Andrew Hill [EMAIL PROTECTED]
 To  : mweb [EMAIL PROTECTED], phplist [EMAIL PROTECTED],
mysqllist [EMAIL PROTECTED]
 Cc  : 
 Date: Tue, 13 Nov 2001 10:27:15 -0500
 Subject : RE: [PHP] Access to MYSQL via ODBC?
 
 Sure, this is entirely possible.
 Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then
 install the MyODBC driver.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Access to MYSQL via ODBC?

2001-11-13 Thread Peter Harvey

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 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 access on NT/IIS.

Is it possible?

mweb


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Access to MYSQL via ODBC?

2001-11-13 Thread Curtis Maurand


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 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 access on NT/IIS.
 
   Is it possible?
 
   mweb
 
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: [PHP] Access to MYSQL via ODBC?

2001-11-13 Thread Curtis Maurand


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: Andrew Hill [EMAIL PROTECTED]
  To  : mweb [EMAIL PROTECTED], phplist [EMAIL PROTECTED],
mysqllist [EMAIL PROTECTED]
  Cc  : 
  Date: Tue, 13 Nov 2001 10:27:15 -0500
  Subject : RE: [PHP] Access to MYSQL via ODBC?
  
  Sure, this is entirely possible.
  Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then
  install the MyODBC driver.
 
 
 
 -
 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 [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php