Re: 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 >