|
 |
asp_database_setup thread: Re: 80004005 error msg
Message #1 by "McHenney,Molly" <molly.mchenney@d...> on Thu, 16 Aug 2001 13:38:52 -0500
|
|
Ken,
I'm getting the following error: Can you help me!
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
/TSS/TMP5boypi6anc.asp, line 5
Here is my code:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/Regional_Personnel.asp" -->
<%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Regional_Personnel_STRING
Recordset1.Source = "SELECT * FROM RegionPersonnel"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = -1
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
Molly
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Tuesday, July 24, 2001 9:35 PM
To: ASP Database Setup
Subject: [asp_database_setup] Re: 80004005 error msg
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 %>
Message #2 by "Vincent Vandermeeren" <vincent@v...> on Thu, 16 Aug 2001 21:22:01 +0200
|
|
Hi Molly,
line 5 = Recordset1.ActiveConnection = MM_Regional_Personnel_STRING
What's the connectstring that you have given to this variable ???
Greetings,
Vinnie
----- Original Message -----
From: "McHenney,Molly" <molly.mchenney@d...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Thursday, August 16, 2001 8:38 PM
Subject: [asp_database_setup] Re: 80004005 error msg
> Ken,
>
> I'm getting the following error: Can you help me!
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
>
> /TSS/TMP5boypi6anc.asp, line 5
>
>
> Here is my code:
>
>
>
> <%@LANGUAGE="VBSCRIPT"%>
> <!--#include file="Connections/Regional_Personnel.asp" -->
> <%
> set Recordset1 = Server.CreateObject("ADODB.Recordset")
> Recordset1.ActiveConnection = MM_Regional_Personnel_STRING
> Recordset1.Source = "SELECT * FROM RegionPersonnel"
> Recordset1.CursorType = 0
> Recordset1.CursorLocation = 2
> Recordset1.LockType = 3
> Recordset1.Open()
> Recordset1_numRows = 0
> %>
> <%
> Dim Repeat1__numRows
> Repeat1__numRows = -1
> Dim Repeat1__index
> Repeat1__index = 0
> Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
> %>
>
> Molly
>
>
>
>
>
>
>
> -----Original Message-----
> From: Ken Schaefer [mailto:ken@a...]
> Sent: Tuesday, July 24, 2001 9:35 PM
> To: ASP Database Setup
> Subject: [asp_database_setup] Re: 80004005 error msg
>
>
> 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 %>
>
> ---
> Microsoft ASP.NET Connections (Orlando FL Sept 18-22, 2001) is the premier
conference for the ASP.NET developer. Keynotes by Microsoft's Steve Ballmer
& Mark Anders. Over 50 Cutting-edge ASP.NET/ASP sessions by THE experts PLUS
FREE admission to 60 bonus session at VB and C# Connections.
www.asp-connections.com?refer=asptoday
$subst('Email.Unsub')
>
Message #3 by "Ken Schaefer" <ken@a...> on Fri, 17 Aug 2001 17:19:15 +1000
|
|
What's in the variable that you are referencing?
<%
Recordset1.ActiveConnection = MM_Regional_Personnel_STRING
%>
<humour>
This is almost as fun as extracting teeth. Why do I need to ask you for all
this information?
</humour>
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "McHenney,Molly" <molly.mchenney@d...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Friday, August 17, 2001 4:38 AM
Subject: [asp_database_setup] Re: 80004005 error msg
: Ken,
:
: I'm getting the following error: Can you help me!
:
: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
:
: [Microsoft][ODBC Driver Manager] Data source name not found and no default
: driver specified
:
: /TSS/TMP5boypi6anc.asp, line 5
:
:
: Here is my code:
:
:
:
: <%@LANGUAGE="VBSCRIPT"%>
: <!--#include file="Connections/Regional_Personnel.asp" -->
: <%
: set Recordset1 = Server.CreateObject("ADODB.Recordset")
: Recordset1.ActiveConnection = MM_Regional_Personnel_STRING
: Recordset1.Source = "SELECT * FROM RegionPersonnel"
: Recordset1.CursorType = 0
: Recordset1.CursorLocation = 2
: Recordset1.LockType = 3
: Recordset1.Open()
: Recordset1_numRows = 0
: %>
: <%
: Dim Repeat1__numRows
: Repeat1__numRows = -1
: Dim Repeat1__index
: Repeat1__index = 0
: Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
: %>
:
: Molly
:
:
:
:
:
:
:
: -----Original Message-----
: From: Ken Schaefer [mailto:ken@a...]
: Sent: Tuesday, July 24, 2001 9:35 PM
: To: ASP Database Setup
: Subject: [asp_database_setup] Re: 80004005 error msg
:
:
: 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 %>
:
: ---
: Microsoft ASP.NET Connections (Orlando FL Sept 18-22, 2001) is the premier
conference for the ASP.NET developer. Keynotes by Microsoft's Steve Ballmer
& Mark Anders. Over 50 Cutting-edge ASP.NET/ASP sessions by THE experts PLUS
FREE admission to 60 bonus session at VB and C# Connections.
www.asp-connections.com?refer=asptoday
ken@a...
$subst('Email.Unsub')
|
|
|
View Cart
