Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001092

Re: [PHP] Can I use Microsoft Access as a database? From: A. op de Weegh (aweegh <email protected>)
Date: 09/18/01

Thanks, but since I am unfamiliar using this kind of database connection, I
was hoping you could help me out some more.

I did the following. In the ODBC Data Source Administrator of Windows 98 I
have created a new file DSN. This DSN is configured to use a certain Access
2000 database on one of my harddisks. The DSN is called 'phpodbc.dsn'. Then,
in the file odbc.php I do the following:

<?php
$odbcId = odbc_connect("dsn=phpodbc.dsn", "admin", ""); // db doesn't
need username/password
?>

When I access this PHP file with Internet Explorer, I get the following
error message:
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified, SQL state IM002 in SQLConnect in
C:\Inetpub\wwwroot\odbc.php on line 3.

Any ideas?

Thanks,
Alex

"Niklas lampén" <niklas.lampen <email protected>> wrote in message
news:NPEFKEPHNLKEPEOLHPKNAEHECFAA.niklas.lampen <email protected>
> I think that ODBC is your solution.
>
>
> Niklas
>
> -----Original Message-----
> From: A. op de Weegh [mailto:aweegh <email protected>]
> Sent: 15. syyskuuta 2001 13:05
> To: php-general <email protected>
> Subject: [PHP] Can I use Microsoft Access as a database?
>
>
> Hi all,
> for testing purposes in a school environment, I would like to use a
> Microsoft Access database with PHP. I know how to connect to and use a
MySQL
> database, but I can't find any functions for accessing Microsoft Access
> databases.
>
> Can anyone help me out here?
>
> Thankx,
> Alex
>
> --
> PS: Replace the underscore (_) in my e-mail address with a minus sign (-).
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>