You are using "phoneinfo" both as a table name and a datasource name.
You *could* do that, but I don't think it's what you're trying for :)
Go back to your control panel and see what you named the ODBC you
created (datasource name, or DSN). You use that name for the first
parameter for your ODBC connection call, like so:
$odbc_dsn="my_odbc_dsn";
$odbc_uid="my_db_uid";
$odbc_pwd="my_db_pwd";
$sql="SELECT * FROM my_table";
$connection = odbc_connect ($odbc_dsn, $odbc_uid, $odbc_pwd) or die
("Can not connect to $odbc_dsn.");
$resultset = odbc_exec ($connection, $sql) or die ("Can not perform
query");
Note that $odbc_uid and $odbc_pwd can be blank (""), providing your
database allows access via NT authentication *AND* you specified in
your ODBC DSN that you wish to use that type of authentication.
Otherwise, use a UID and password, and ensure they're in your ODBC DSN
too.
Caveat: I don't use MS Access -- I use MSSQL, but I'm pretty sure the
principles are the same for the two drivers.
On Thu, 26 Jul 2001 22:34:58 -0700 (PDT), [EMAIL PROTECTED] (Meng Yoke)
wrote:
>Hi,
>
>php 405
>IIS 5.0 / W2K
>MS Access 2000
>
>I had a simple script that will connect to MS Access
>DB. I had created the DSN and it was tested ok on the
>dos promopt.
>
>When I tested using the IIS, it failed:
>
>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\o2.php on line 3
>
>Warning: Supplied argument is not a valid ODBC-Link
>resource in c:\inetpub\wwwroot\o2.php on line 5
>
>
>This is my script:
>
><?
>$cx=odbc_connect ("phoneinfo", "", "");
>
>$cur=odbc_exec($cx,"select * from phoneinfo");
>?>
>
>any help appreciated?
>
>thanks.
>
>- yoke
>
>
>=====
>=======================================
> Yoke Meng Keong
> Email : [EMAIL PROTECTED]
> eFax : (253) 669-6578 (US)
>=======================================
>
>__________________________________________________
>Do You Yahoo!?
>Get personalized email addresses from Yahoo! Mail
>http://personal.mail.yahoo.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
