Click to See Complete Forum and Search --> : Connection to access without dsn


Anon
12-17-2001, 11:24 AM
Hello,
I'm trying to connect to an access database..
The pb is that i must not use a dsn..

First is it possible?

second : using com object

My syntax:
$db_conn= new COM("ADODB.Connection") or die("Unable to instanciate adodb");

$db_str="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=". realpath("../stats/servers/dbsats.mdb")."; DefaultDir=". realpath("../gatstats/servers/");

(i checked it gives me the good path..)

$db_conn->open($db_str);
At this line : error : invoke failed()..

I don't now if its needed but :
In php info i set com.allow_dcom=true

[com]
; path to a file containing GUIDs, IIDs or filenames of files with TypeLibs
;com.typelib_file=
; allow Distributed-COM calls
com.allow_dcom=true

Pleaseeeeeee whats wrong 4 days on this..

Thanks
GoP

Anon
12-17-2001, 11:56 AM
I m a big newbie.... it works .. it was not a good path apparently ...
ouiiiinnnnnn