DSN less connection

rahuld3

Hi !

I have tried usingodbc_connect function to connect to a local database such as MS Access.It requires a System DSN.Is there any way to connect to a database without a DSN like it is available in ASP.

Can anyone guide me about that.

thanks

Rahul

Anon

I tried to solve this problem by using COM object ( ADODB.Connection ) , It's just like ASP's DSN Less Connection .

the code is like this

$myconn = "Driver=Microsoft Access Driver (*.mdb);DBQ=c:\kerjaan\masintra\database\jual.mdb";
$dbc = new com ("ADODB.Connection");
$dbc -> open($myconn);

It Worked but the recordset won't
my apache for Window always get an error from msado15.dll , I don't know what' happen.

Anon

Hi,
Dear o dear i came in to the site to ask the same query.If u got the answer please let me know via my email.I will do the same if i got it.
Bye
prakash

Anon

The solution...

//db is database connection
//rs is the record set

$DSN_Less = "YOUR DSN_Less Conn String";
$db = new com ("ADODB.Connection");
$db -> open($DSN_Less);
$rs = $db->execute("SQL Statement");

//ensure there are results.
if (!$rs->EOF()) {
$objItem = $rs -> Fields -> Item("FieldName");
$value = $objItem->Value;
echo $value;
}

Nelson
Dragon Web Publishings
http://www.dwp.ca