By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,474 Members | 939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,474 IT Pros & Developers. It's quick & easy.

ASP - data connection question

P: n/a
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...l/calendar.asp

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

May 19 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I realized I made a typo above. I should have copied and pasted this,
but chose to type it out instead. The real GetDataConnection function
is

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

May 19 '06 #2

P: n/a
Okay, I'm sure you are all shaking your heads by now and wondering who
the heck the idiot is that's posting this, right? Well, last time I
copied and pasted from the previous post and didn't make the change I
needed. So again, here is the REAL correct funtion (it's just a
correction of semi colons in the connection string):

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

May 19 '06 #3

P: n/a
Jennifer wrote:
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...l/calendar.asp

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:


This isn't a question about HTML, it's about ASP. Best to find an ASP
newsgroup.
May 19 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.