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:[EMAIL PROTECTED]]
> Sent: Tuesday, April 30, 2002 9:34 AM
> To: 'Mikael Syska '
> Cc: '[EMAIL PROTECTED]'
> 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: [EMAIL PROTECTED]
> 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
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
