I encountered error :-



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

Data Source Name not found and no default driver specified.



Must I create a DSN and if yes, what's the name of the DSN and link to what?



I enclosed the sample ASP program below.



Rgds,

Terence







Choose Event to Edit



if request("eventid")>"0" then events.open "select * from Event where

id="&request("eventid"),"dsn=msevents" response.write "

" "'name='eventid'>" &"'name='begindate'>

" &"'name='name'>

" value='"&events("description") &"'name='description'>

" &"'name='city'>

" &"'name='state'>

" &"'name='contactname'>

" &"'name='contactemail'>

" &"'name='contactphone'>

" type='Reset' value='Cancel' name='B2'>

" else events.open "select * from event","dsn=msevents" events.movefirst

response.write "

" response.write "" do while not events.eof value='"&events("id")&"' checked

name='eventid'>"&events("begindate")&" "&events("name")&"



" events.movenext loop response.write " " response.write "

" type='Reset' value='Reset' name='B2'>

" end if %>





_________________________________________________________________

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Where is the code where you open the connection?!?

That is the line that is generating this error, not the code you have

posted.



Cheers

Ken





~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "terence yeo" <terenceyeo@h...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Tuesday, July 24, 2001 7:44 PM

Subject: [asp_database_setup] 80004005 error msg





: I encountered error :-

:

: Microsoft OLE DB Provider for ODBC Drivers error '80004005'.

: Data Source Name not found and no default driver specified.

:

: Must I create a DSN and if yes, what's the name of the DSN and link to

what?

:

: I enclosed the sample ASP program below.

:

: Rgds,

: Terence

:

:

:

: Choose Event to Edit

:

: if request("eventid")>"0" then events.open "select * from Event where

: id="&request("eventid"),"dsn=msevents" response.write "

: " "'name='eventid'>" &"'name='begindate'>

: " &"'name='name'>

: " value='"&events("description") &"'name='description'>

: " &"'name='city'>

: " &"'name='state'>

: " &"'name='contactname'>

: " &"'name='contactemail'>

: " &"'name='contactphone'>

: " type='Reset' value='Cancel' name='B2'>

: " else events.open "select * from event","dsn=msevents" events.movefirst

: response.write "

: " response.write "" do while not events.eof value='"&events("id")&"'

checked

: name='eventid'>"&events("begindate")&" "&events("name")&"

:

: " events.movenext loop response.write " " response.write "

: " type='Reset' value='Reset' name='B2'>

: " end if %>