what's is wrong with the connection
first i save the access file and asp file in the same folder under C drive. then i go to explorer and type in 192.169.1.209/folder1/subfolder/filename.asp then it gives me this error:
Code:
Microsoft JET Database Engine error '80004005'
'C:\sample.com\folder1\subfolder\filename.mdb' is not a valid path.
Make sure that the path name is spelled correctly and that you are
connected to the server on which the file resides.
/folder1/subfolder/filename.asp, line 12
here is my code
Code:
Dim DataConn
Dim commandTemp
Dim RS
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\sample.com\folder1\subfolder\filename.mdb"
Set commandTemp= Server.CreateObject("ADODB.Command")
Set commandTemp.ActiveConnection = DataConn
commandTemp.CommandType = 1
commandTemp.Prepared = True
Set RS= Server.CreateObject("ADODB.Recordset")
RS.CacheSize = 100
commandTemp.commandText = "SELECT * FROM filename"
set RS= commandTemp.execute
can some one help me plz
Re: what's is wrong with the connection
