NYCPHP Meetup

NYPHP.org

[nycphp-talk] DB connection - web vs. command line?

Tracy tech_learner at yahoo.com
Fri Jan 10 00:45:55 EST 2003


HI,
http://www.mysql.com/portal/software/item-190.html
see if this helps. i have tried and ported data from mysql to access using mysql import. havent tried the other way round. was about. so in case u hit some gud shortcuts plz pass teh word on...
Tracy
 cthorn <cthorn at wt.net> wrote: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/ ---



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Coming together is a beginning... 
   keeping together is progress... 
      working together is success !!!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030109/2e10933c/attachment.html>


More information about the talk mailing list