DBI problems: from MySQL to Access

From: joe (tunmaster_at_hotmail.com)
Date: 10/30/03 

Date: Thu, 30 Oct 2003 21:32:03 GMT

Dear guru's,

Here is what it is. I used to have my sites run on a UNIX-based webserver.
My cgi-scripts were connecting to a MySQL-database perfectly. Now I tried to
do the same thing on my Windows machine. I installed Apache, ActivePerl, DBI
and DBD to connect to a Access database. So far, so good. Everything was
going just the way I planned it. Untill...

Untill some querys weren't handled by the Access db the way they were by the
MySQL db. Simple select and delete queries are ok, but even slightly more
difficult ones make the db-connection hang.

My question: is there a possibillity to use the exact same queries on
Windows as on UNIX? I tried installing Win32::ODBC but didn't get far. Is
Win32::ODBC my promised land?

I'd be really gratefull if anyone could help me out,
Thanks in advance,

Joe

Relevant Pages

  • Re: Data Access Pages
    ... > queries, forms and macros to enable it to be operated over the internet. ... > data can be edited manually via data access forms, ... if there are any example of access database being controlled via web ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access and Excel
    ... via append queries and update queries. ... > Excel spreadsheets. ... > wanting to create some sort of Access database for her as ...
    (microsoft.public.access.tablesdbdesign)
  • Re: office 2003 Word mailmerge with Access
    ... If you aren't able to see all of the queries then ... it's likely due to the connection method rather than permissions. ... Select the Access database as the data source again and when ...
    (microsoft.public.office.misc)
  • Re: Mail merge from access Database
    ... Word 2003 uses a thing called OLE DB to connect to the Access database. ... however, both Access tables and Access Queries are listed in that dialog box, although Queries are described as Views. ... OLE DB does not "see" all types of table and query. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exporting Access data into excel using vb6
    ... > I have data in an Access database. ... > Certain users need all the data in the queries exported to excel. ... > specify the filename and location of the data without someone doing it ... If you encounter problems for some specific aspect of the task, ...
    (microsoft.public.vb.syntax)