connection question

Results 1 to 2 of 2

Thread: connection question

  1. #1
    Join Date
    Dec 1969

    Default connection question

    hi guys,<BR>can someone suggest the best connection to use? I&#039;m currently using this:<BR>&#060;% <BR> dbname="private/dbname.mdb"<BR> set conn=server.createobject("adodb.connection")<BR> connpath="DBQ=" & server.mappath(dbname)<BR> conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & connpath<BR>%&#062;<BR><BR>but quite often get this as an error message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key &#039;Temporary (volatile) Jet DSN for process 0x42c Thread 0x5d8 DBC 0x145598c Jet&#039;.<BR>/moviereviewtest/new/confirmreviewinsert.asp, line 5

  2. #2
    Join Date
    Dec 1969

    Default GOOGLE for that...

    ...and you&#039;ll see tons of posts and answers.<BR><BR>But maybe best thing is to stop using the Access driver and graduate to the JET OLEDB driver, instead.<BR><BR>

Posting Permissions

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