From:             [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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to