Results 1 to 3 of 3

Thread: Searching Access, Databases, DNS error

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    40

    Wink

    Hello,
    I am trying your example for a database search, but I am having trouble making the DSN through the ODBC icon. It seems everything is well, but how do I transfer all of this to a remote server that runs my web page? When I select the file through the ODBC icon, I then FTP it up to my server. But when I try to search Employees DB I get an error of:
    ---------------------------------------------------------------------------------------------
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    /DaEngine.asp, line 14

    --------------------------------------------------------

    I appreciate your help on this,

    Stan

  2. #2

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    40

    code:

    code:
    -------------
    line 13: Set dbGlobalWeb = Server.CreateObject("ADODB.Connection")

    line 14:
    dbGlobalWeb.Open("Employees")

  3. #3

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    40

    Post code:

    Help Gurus!!!!!!!!!!!!

    What is the difference in the previous code for connecting to a DB and this:
    -------------------
    Dim DB
    Dim rst

    Set DB = OpenDatabase("employees.mdb")
    Set rst = DB.TableDefs("Employees").OpenRecordset

    ----------------------------------
    Do I need to use this?

    ----------------------------------
    con.open "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=c:\dealer.mdb;"
    -----------------------------
    Help I'm a rookie!!!!!!!!!!!!!


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