Hi. I don't know a whole bunch about html and asp pages, but I thought
I'd give it a try to see if I could get it to work. I found an example
for a calendar event page from Microsoft at:
http://msdn.microsoft.com/library/de...ary/en-us/dnas...
So using this example, I saved all the examples for each part of the
code as asp pages. I created a default htm page which opens the asp
pages. The code for that is:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Calendar</title>
</head>
<frameset cols="120" border=0 frameborder="0">
<frame name="MAIN" src="calendar.asp" noresize >
</frameset>
</html>
I opened this all in Front Page and published it to my local inetpub
directory. When trying to run it, I get the following error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
/calendar/Header.asp, line 43
I'm not sure what is causing this. Line 43 on the header.asp page is
blank, but anyway... I did check to make sure my connection string was
correct, with no typos. My modified GetDataConnection function is now:
function GetDataConnection()
dim oConn, strConn
Set oConn = Server.CreateObject("ADODB.Connection")
strConn = "Provider=SQLOLEDB.1; Persist Security Info=False; "
strConn = strConn & "User Id=CCLead; Password=xxxx;"
strConn = strConn & "Initial Catalog=CC Leadership; "
strConn = strConn & "Data Source=WBCORP501 "
oConn.ConnectionString = strConn
oConn.Open
set GetDataConnection = oConn
end function
I feel sure that I am missing something obvious, but not sure what.
Any suggestions for a newbie?
Thanks,
Jennifer
