go to Start > programs > administrative tools > Data Sources (ODBC)
then set up a system DSN, as the php user will need to access it. the dsn name will then be the Data source name (= string dsn). in odbc_connect(string dsn, string user, string password [, int cursor_type) i found that if you set up a user dsn you need to change it to a system dsn so php can access it. Paul Roberts [EMAIL PROTECTED] ++++++++++++++++++++++++ ----- Original Message ----- From: "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]> To: "'Mikael Syska '" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April 30, 2002 5:34 PM Subject: RE: [PHP-WIN] Access database > 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 exact location of the things your a looking for > in Win2000 - since M$ focus on location in stead of functionally 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 assign you already have these ODBC drivers > installed.) > > And for the rest (e.g. PHP related) follow the on line manual at > www.php.net. > > If you want to know more about ODBC related things I would recommend you to > consult the MSDN online manual. MS done a lot of documentation about their > system and it is huge source of information available there. > > > Have fun, > Anders > > -----Original Message----- > From: Mikael Syska > To: [EMAIL PROTECTED] > Sent: 30-4-02 12:54 > Subject: Re: [PHP-WIN] Access database > > > 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 don't know how to do that, i > can > find the OBDC settings but don't 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 > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
