RE: [PHP] Can I use Microsoft Access as a database?
| From: | Niklas Lampén | Date: | Tue, 18 Sep 2001 08:20:00 +0000 |
| Subject: | RE: [PHP] Can I use Microsoft Access as a database? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67682@lists.php.net to get a copy of this message | ||
Try:
$odbcId = odbc_connect("phpodbc.dsn", "admin", "");
Niklas
-----Original Message-----
From: A. op de Weegh [mailto:aweegh@weegh_it.nl]
Sent: 18. syyskuuta 2001 10:57
To: php-general@lists.php.net
Subject: Re: [PHP] Can I use Microsoft Access as a database?
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@publico.fi> wrote in message
news:NPEFKEPHNLKEPEOLHPKNAEHECFAA.niklas.lampen@publico.fi...
> I think that ODBC is your solution.
>
>
> Niklas
>
> -----Original Message-----
> From: A. op de Weegh [mailto:aweegh@weegh_it.nl]
> Sent: 15. syyskuuta 2001 13:05
> To: php-general@lists.php.net
> 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@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net