RE: [PHP-WIN] Access databse

I'm getting to this post late, however, instead of messing around with ODBC data sources which M$ calls a DSN, I use a connection string instead (for Windows 2000 the ODBC data sources are in Settings, Control Panel, Administrative Tools, Data Sources (ODBC). I've used the following code for an ASP program. I haven't put it in php, since I don't use Access with php (what's the point?). However, this should be a starting point. strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application("AccessPath") & ";Persist Security Info=False" where the variable is: Application("AccessPath") = "d:\inetpub\wwwroot\helpdesk\db\helpdesk.mdb" Remember to put the connection string all on one line. Hope this helps, Tom > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@lumc.nl] > Sent: Tuesday, April 30, 2002 9:34 AM > To: 'Mikael Syska ' > Cc: 'php-windows@lists.php.net' > Subject: RE: [PHP-WIN] Access databse > > > Don't you think you stretch these question a little bit to far now? > This is after all a PHP-mailing list, not a M$-support e-mail list. > > > Anyhow, > M$ done its best to alter things between different versions > of Windows (I am > using NT so I don't know the excat location of the things > your a looking for > in Win2000 - since M$ focus on location in stead of > functionaly forcing > people to re-learn this > "were-to-find-what-I-already-know-what-I-want-to-do-thing" > everytime they > upgrade their version.) > > You need to locate the ODBC driver set up. And then you should select > something like create a new or set up a new ODBC connection. > Once you manage > this, you need to select the MS Access ODBC driver, and tell > it were to find > the Access database file. (I am assimg you already have > these ODBC drivers > installed.) > > And for the rest (e.g. PHP realted) follow the on line manula at > www.php.net. > > If you want to know more abot ODBC related things I would > recommed you to > consult the MSDN online manual. MS done a lot of > ducumentation about their > system and it is huge source of information availabe there. > > > Have fun, > Anders > > -----Original Message----- > From: Mikael Syska > To: php-windows@lists.php.net > Sent: 30-4-02 12:54 > Subject: Re: [PHP-WIN] Access databse > > > Check the functions regarding ODBC support. You will need > to add the > > database in the ODBC manager and after that, it is transparent like > > any other DSN database. > > > How do i do that, I use Windows2000 and i dont know how to do that, i > can > find the OBDC settings but dont know what to change.... > > And I get this failure when I tries to connect to my "data.mdb" > > Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name > not > found and no default driver specified, SQL state IM002 in > SQLConnect in > c: > \apache\htdocs\access\index.php on line 18 > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >