NYCPHP Meetup

[cthorn]

Install myodbc for windows and export the tables and data to
a mysql db...

MyODBC http://www.mysql.com/downloads/api-myodbc-2.50.html

A better way would be to port your access schema to mysql
and use myodbc to link to the mysql tables and create
queries in access to move data.



> Hi everyone,
>
> After struggling with Windows all these years, I'm finally
> learning PHP and My SQL on Linux/Apache.  Unfortunately, I
> have some data that I need to get to, that is in an MS
> Access database.  Is it possible to access Access via PHP?
>  Alternatively, is there a way to transform Access to
> MySQL instead?  Any links to additional info would be
> appreciated!
> Thanks,
>
> Bill
>
> -----Original Message-----
> From: Freedman, Tom S. [mailto:tfreedma at ubspw.com]
> Sent: Thursday, January 09, 2003 2:42 PM
> To: NYPHP Talk
> Subject: [nycphp-talk] DB connection - web vs. command
> line?
>
> Hi all,
>
> I've run into another weird one.  I'm using PHP 4.1.2 to
> connect to SQL Server 2000.  If I run the page from IIS,
> it connects to the DB just fine and runs a stored
> procedure.  If I execute the same page via the command
> line, it dies on the connection attempt (mssql_connect()).
> Anyone run into something like this?  I can't figure out
> why they'd behave differently.
>
> Thanks in advance!
> Tom
>
>
>
>
>
>
>
>
> --- Unsubscribe at http://nyphp.org/list/ ---
>
>