Driver Error

Results 1 to 2 of 2

Thread: Driver Error

  1. #1
    Join Date
    Dec 1969
    Posts
    94

    Default Driver Error

    I&#039m getting this error:<BR>=======<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <BR><BR>/pollResults.asp, line 11 <BR>=======<BR>this is the code:<BR>=======<BR><BR>&#060;%<BR> Response.ExpiresAbsolute = Now() - 1<BR><BR> &#039All we want to do here is increment the vote count for the voting option<BR> &#039selected...<BR><BR> set rsy=Server.CreateObject("adodb.connection")<BR> connectme="DSN=db1"<BR>&#060;!!!line 11!!!&#062; rsy.open, connectme<BR><BR> &#039Read in our variables<BR> Dim iPollOptionID<BR> iPollOptionID = CInt(Request("radPoll"))<BR> <BR><BR> rsy.Execute "UPDATE PollOption SET Votes = Votes + 1 " & _<BR> "WHERE PollOptionID = " & iPollOptionID<BR><BR> <BR> rsy.Close<BR> Set rsy = Nothing<BR> <BR> &#039We&#039ve gotta write a cookie<BR> Response.Cookies("Voted") = "Yes"<BR> Response.Cookies("Voted").Expires = DateAdd("d",1,Date)<BR> &#039Response.Cookies("Voted").Domain = ".t-smitch"<BR> Response.Cookies("Voted").Path = "/poll" <BR> <BR> &#039Send the user back to the previous page<BR> Response.Redirect Request("URLFrom")<BR>%&#062;<BR>=======<BR>the databse does work throught the site, am I overlooking anything?

  2. #2
    Marco Valdez Guest

    Default RE: Driver Error

    Hello Marko:<BR><BR>I think the comma is messing your line 11 up. try using:<BR><BR>rsy.Open connectme<BR><BR><BR>thanks,<BR><BR>Marco<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
  •