Hi All,
I've got the ASP script shown below that complains as follows:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
/ShowEvents.asp, line 24
Line 24 of the script is the line:
Conn.Open "EventsDB","sa","" 'EventsDB is the ODBC System DSN
I used the 'EventsDB DSN to link an Access 2000 "front end" to the
tempdb.dbo.Events table represented by the DSN. I updated the table through
the front end and confirmed success using a Select statement in Query
Analyzer.
I running Win2000ProSP4 workstation networked to an Win2000AdvanceServerSP4
running Sequel Server 2000. Microsoft Update patches are up-to-date.
Any suggestions would be appreciated.
--
Regards,
Richard
640K ought to be enough for anybody.
Bill Gates, 1981
=========== ShowEvents.asp =============
<html>
<!-- ShowEvents.asp
Display rows in "Events" table in
"tempdb" database in
SQL Server 2000 on
"ASCI2000AS" Win2000 Advanced Server
using System DSN "EventsDB"
-->
<head>
<title>Events</title>
</head>
<BODY BGCOLOR=#ffffff>
<!--#include file="adovbs.inc"-->
<H1>Events</H1><BR>
<%
Response.Write "Creating Connection object<<BR>>"
Set Conn = Server.CreateObject("ADODB.Connection")
Response.Write "Created Connection object<<BR>>"
Response.Write "Opening EventsDB connection<<BR>>"
Conn.Open "EventsDB","sa","" 'EventsDB is the ODBC System DSN
Response.Write "Opened EventsDB connection<<BR>>"
Response.Write "Creating RecordSet rsEvents by executing SELECT stmt<<BR>>"
Set rsEvents = Conn.Execute("SELECT * FROM Events ORDER BY EvDate, EvTime")
Response.Write "Created RecordSet rsEvents by executing SELECT stmt<<BR>>"
%>
</BODY>
</html>
