ID: 13312
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old Status: Open
Status: Closed
Bug Type: ODBC related
Operating System: Windows2000 server
PHP Version: 4.0.6
Previous Comments:
------------------------------------------------------------------------
[2001-09-15 04:04:27] [EMAIL PROTECTED]
I tried to connect with a Microsoft Access database but it didnt work.
I made the DSN named reg and then I used the following code to connect
$connection=odbc_connect("reg","admin","") or die ("Cant connect the
datasource");
$sql="Select * from newuser order by name asc";
$sql_statement=odbc_prepare($connection,$sql) or die ("Cant prepare statement");
$sql_result=odbc_execute($sql_statement) or die ("Cant execute query");
odbc_result_all($sql_result,"border=1");
odbc_free-result($sql_result);
odbc_close($connection);
when i view the php page it says
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified
can anyone solve my problem
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=13312&edit=1
--
PHP Development 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]
