| || |
Connection String and Relative Path
my connection String is working if i provide full qualified path of database
i have tried with DP.mdb;" and \DP.mdb;" as well
<font class="small">Code:</font><hr /><pre>
Set connection = CreateObject("ADODB.connection")
Set recordset = CreateObject("ADODB.Recordset")
sConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=DP.mdb;"
If Connection.State = 1 Then
Recordset.Open sSQL, Connection
MYQUERY = "select * from dp_tree"
Re: Connection String and Relative Path
some more R&D and now i found that if i running the script standalone working fine
i made a vbs with this code is working fine by dubble clicking it but if i included this file in a HTML page it is giving some desktop location
DirPath = CreateObject("Scripting.FileSystemObject").GetFold er(".").Path
DirPath = CreateObject("Scripting.FileSystemObject").GetPare ntFolderName(DirPath)