[PHP-DEV] Bug #13312: cant connect to a odbc source From: parabips <email protected>
Date: 09/15/01

From: parabips <email protected>
Operating system: Windows2000 server
PHP version: 4.0.6
PHP Bug Type: ODBC related
Bug description: cant connect to a odbc source

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 bug report at: http://bugs.php.net/?id=13312&edit=1

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>