Results 1 to 2 of 2

Thread: what's is wrong with the connection

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2006
    Posts
    260

    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

  2. #2

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2006
    Posts
    260

    Re: what's is wrong with the connection

    i got it ty guys

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width