Problems with Odbc_connect()

Bidibule

Hi everyone,

I tried to connect to an Access Database on a Windows server and When I execute "odbc_connect("DBname","admin","")

it says me :

SQL error: [Microsoft][ODBC Microsoft Access Driver]General error Not enough information to connect to this DSN with SQLConnect. Use SQLDriverConnect., SQL state S1000 in SQLConnect in

I dunno how to use "Use SQLDriverConnect" instead of SQLConnect.... 😕

Please help me!! (I've looked on pages but can't understand what modifications I have to do to use SQLDriverConnect)

Thx

zudo

i give you ecxample on hot to connect

<html>
<head><title>try it out crapping on a lawn</title>
<style type="text/css">
TH {color: silver; background-color: navy}
TD {color: white; background-color: blue}
</style>
</head>
<body>

<?php
//odbc_query.php
$odbc_dsn = "sample_db";
$odbc_userid = "";
$odbc_password = "";
$query = "SELECT * FROM user";
$odbc_db = odbc_connect($odbc_dsn, $odbc_userid, $odbc_password);
$odbc_rs = odbc_do($odbc_db, $query);

odbc_result_all($odbc_rs);

</table>
</body>
</html>$odbc_dsn = "sample_db"; odbc_connect($odbc_dsn, $odbc_userid, $odbc_password);