Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

ASP Sign-Up Problem

Hi, I'm a newbie in ASP Programming.

I've a got a problem with signup syntax.
when I click the Sign-Up button on my web site, it shows an error message, like this:

"Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6fc Thread 0x660 DBC 0x22a0234 Jet'.

/pk/forum/includes/signup-inc.asp, line 144"

Here some line from my "signup-inc.asp"
(line 134 - line 149)
Dim varUsername : varUsername = Request.Form("pseudo")
Dim varPassword : varPassword = Request.Form("mdp")
Dim varEmail : varEmail = Request.Form("email")
Dim strConnString , rs, varSQL, conn

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; Pwd=************ ; DBQ=" & Server.MapPath("/**/****/***************/*********************/****************.mdb")
Set rs=Server.CreateObject("ADODB.recordset")
varSQL = "INSERT INTO USERS([USERNAME], [PASSWORD], [EMAIL], [DATEREGISTERED]) " & _
"VALUES('" & varUsername & "', '" & varPassword & "', '" & varEmail & "', '" & now() & "');"
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open strConnString
conn.Execute(varSQL)
conn.Close
Set conn = Nothing

End Sub

it seems that it has some problem with line 144 which is conn.Open strConnString

I don't know which part I went wrong. can somebody help me???

I really need the answer quickly...

Thanks


Comments

  • FlakesFlakes Member Posts: 642
    [b][red]This message was edited by Flakes at 2005-8-11 0:50:17[/red][/b][hr]
    : Hi, I'm a newbie in ASP Programming.
    :
    : I've a got a problem with signup syntax.
    : when I click the Sign-Up button on my web site, it shows an error message, like this:
    :
    : "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    :
    : [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6fc Thread 0x660 DBC 0x22a0234 Jet'.
    :
    : /pk/forum/includes/signup-inc.asp, line 144"
    :
    : Here some line from my "signup-inc.asp"
    : (line 134 - line 149)
    : Dim varUsername : varUsername = Request.Form("pseudo")
    : Dim varPassword : varPassword = Request.Form("mdp")
    : Dim varEmail : varEmail = Request.Form("email")
    : Dim strConnString , rs, varSQL, conn
    :
    : strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; Pwd=************ ; DBQ=" & Server.MapPath("/**/****/***************/*********************/****************.mdb")
    : Set rs=Server.CreateObject("ADODB.recordset")
    : varSQL = "INSERT INTO USERS([USERNAME], [PASSWORD], [EMAIL], [DATEREGISTERED]) " & _
    : "VALUES('" & varUsername & "', '" & varPassword & "', '" & varEmail & "', '" & now() & "');"
    : Set conn=Server.CreateObject("ADODB.Connection")
    : conn.Open strConnString
    : conn.Execute(varSQL)
    : conn.Close
    : Set conn = Nothing
    :
    : End Sub
    :
    : it seems that it has some problem with line 144 which is conn.Open strConnString
    :
    : I don't know which part I went wrong. can somebody help me???
    :
    : I really need the answer quickly...
    :
    : Thanks
    :
    :
    :


    Is your path to the db correct ? Also , date values in Accesss needs # around them..

    [code]
    varSQL = "INSERT INTO [USERS]([USERNAME], [PASSWORD], [EMAIL], [DATEREGISTERED]) " & _
    "VALUES('" & varUsername & "', '" & varPassword & "', '" & varEmail & "', #" & now() & "#);"
    [/code]

    Also, consider using the jet driver instead of the default access driver.
  • MehanathenMehanathen Member Posts: 13
    : [b][red]This message was edited by Flakes at 2005-8-11 0:50:17[/red][/b][hr]
    : : Hi, I'm a newbie in ASP Programming.
    : :
    : : I've a got a problem with signup syntax.
    : : when I click the Sign-Up button on my web site, it shows an error message, like this:
    : :
    : : "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    : :
    : : [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6fc Thread 0x660 DBC 0x22a0234 Jet'.
    : :
    : : /pk/forum/includes/signup-inc.asp, line 144"
    : :
    : : Here some line from my "signup-inc.asp"
    : : (line 134 - line 149)
    : : Dim varUsername : varUsername = Request.Form("pseudo")
    : : Dim varPassword : varPassword = Request.Form("mdp")
    : : Dim varEmail : varEmail = Request.Form("email")
    : : Dim strConnString , rs, varSQL, conn
    : :
    : : strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; Pwd=************ ; DBQ=" & Server.MapPath("/**/****/***************/*********************/****************.mdb")
    : : Set rs=Server.CreateObject("ADODB.recordset")
    : : varSQL = "INSERT INTO USERS([USERNAME], [PASSWORD], [EMAIL], [DATEREGISTERED]) " & _
    : : "VALUES('" & varUsername & "', '" & varPassword & "', '" & varEmail & "', '" & now() & "');"
    : : Set conn=Server.CreateObject("ADODB.Connection")
    : : conn.Open strConnString
    : : conn.Execute(varSQL)
    : : conn.Close
    : : Set conn = Nothing
    : :
    : : End Sub
    : :
    : : it seems that it has some problem with line 144 which is conn.Open strConnString
    : :
    : : I don't know which part I went wrong. can somebody help me???
    : :
    : : I really need the answer quickly...
    : :
    : : Thanks
    : :
    : :
    : :
    :
    :
    : Is your path to the db correct ? Also , date values in Accesss needs # around them..
    :
    : [code]
    : varSQL = "INSERT INTO [USERS]([USERNAME], [PASSWORD], [EMAIL], [DATEREGISTERED]) " & _
    : "VALUES('" & varUsername & "', '" & varPassword & "', '" & varEmail & "', #" & now() & "#);"
    : [/code]
    :
    : Also, consider using the jet driver instead of the default access driver.
    :

  • MehanathenMehanathen Member Posts: 13
    Str_path= Server.mapPath("Priv/sitterloop.mdb")
    sitterloop="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Str_path &";Persist Security Info=False"

    also be simple in Query

    "insert into tbluser (username,..,..) values('"&uname&"',..,..)"

    and user the # thing for date
Sign In or Register to comment.