Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

connecting to an access database on a different drive

Status
Not open for further replies.

BPMan

Programmer
Jun 25, 2002
163
US
currently i am connecting to a database that is in the same folder as my php file but i want to connect to database that is somewhere else on the network.
here is what i am doing now

$db_connection = new COM("ADODB.Connection");

$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".
realpath("../ceg/CEDatabase.mdb") ." ;DefaultDir=". realpath("../ceg");
$db_connection->open($db_connstr);

the full file location is \\150.45.1.128\\ i want to connect to database that is at
\\ttc_main\vol1\ttcshared\CCC21 Cost Engineering\Database\CEDatabase.mdb

Is this possible???
and if so what do i need to do???
thanks
 
simple, use this path:

\\\\servername\\drive\\folder\\filename

Known is handfull, Unknown is worldfull
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top