Dreamweaver to Access - Newbie

[Dave]

When attempting to view information dynamically 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
/autoforms/ViewContent.asp, line 8



The automatically generated code from DreamWeaver MX 2004 is:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/aFORMSconnect.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_aFORMSconnect_STRING
Recordset1.Source = "SELECT * FROM Guests ORDER BY GuestsID ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>

1. I can understand why the system doesn't know where the Data source is
located (The generated code doesn't reveal it.) Good for security but bad
for me since I don't know where or what should be stated regarding it's
local.
Setting things up by use of the Dreamweaver wizards, I know I pointed to the
database. Could this be a Dreamweaver bug or is it just me?

2. Also utilizing a driver for accessing the database: I know ODBC is on
the IIS 5.0 system but the server doesn't seem to think so.

Anything obvious to those who have mastered this type of ordeal?
Dave

[McKirahan]

"Dave" <dgrisset@sewanee.edu> wrote in message
news:#LQcCWPREHA.1644@TK2MSFTNGP09.phx.gbl...

> When attempting to view information dynamically 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
> /autoforms/ViewContent.asp, line 8
>
>
>
> The automatically generated code from DreamWeaver MX 2004 is:
>
> <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> <!--#include file="Connections/aFORMSconnect.asp" -->
> <%
> Dim Recordset1
> Dim Recordset1_numRows
>
> Set Recordset1 = Server.CreateObject("ADODB.Recordset")
> Recordset1.ActiveConnection = MM_aFORMSconnect_STRING
> Recordset1.Source = "SELECT * FROM Guests ORDER BY GuestsID ASC"
> Recordset1.CursorType = 0
> Recordset1.CursorLocation = 2
> Recordset1.LockType = 1
> Recordset1.Open()
>
> Recordset1_numRows = 0
> %>
>
> 1. I can understand why the system doesn't know where the Data source is
> located (The generated code doesn't reveal it.) Good for security but bad
> for me since I don't know where or what should be stated regarding it's
> local.
> Setting things up by use of the Dreamweaver wizards, I know I pointed to

the

> database. Could this be a Dreamweaver bug or is it just me?
>
> 2. Also utilizing a driver for accessing the database: I know ODBC is on
> the IIS 5.0 system but the server doesn't seem to think so.
>
> Anything obvious to those who have mastered this type of ordeal?
> Dave

What is the value of "MM_aFORMSconnect_STRING" in
"Connections/aFORMSconnect.asp"?

[Dave]

MM_aFORMSconnect_STRING = "dsn=db1;uid=******;pwd=******;"

UID and PWD have values; they aren't ******.

I did try removing UID and PWD but the same error occurs.




"McKirahan" <News@McKirahan.com> wrote in message
news:7rZtc.8413$IB.7039@attbi_s04...

> "Dave" <dgrisset@sewanee.edu> wrote in message
> news:#LQcCWPREHA.1644@TK2MSFTNGP09.phx.gbl...

> > When attempting to view information dynamically 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
> > /autoforms/ViewContent.asp, line 8
> >
> >
> >
> > The automatically generated code from DreamWeaver MX 2004 is:
> >
> > <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> > <!--#include file="Connections/aFORMSconnect.asp" -->
> > <%
> > Dim Recordset1
> > Dim Recordset1_numRows
> >
> > Set Recordset1 = Server.CreateObject("ADODB.Recordset")
> > Recordset1.ActiveConnection = MM_aFORMSconnect_STRING
> > Recordset1.Source = "SELECT * FROM Guests ORDER BY GuestsID ASC"
> > Recordset1.CursorType = 0
> > Recordset1.CursorLocation = 2
> > Recordset1.LockType = 1
> > Recordset1.Open()
> >
> > Recordset1_numRows = 0
> > %>
> >
> > 1. I can understand why the system doesn't know where the Data source

is

> > located (The generated code doesn't reveal it.) Good for security but

bad

> > for me since I don't know where or what should be stated regarding it's
> > local.
> > Setting things up by use of the Dreamweaver wizards, I know I pointed to

> the

> > database. Could this be a Dreamweaver bug or is it just me?
> >
> > 2. Also utilizing a driver for accessing the database: I know ODBC is

on

> > the IIS 5.0 system but the server doesn't seem to think so.
> >
> > Anything obvious to those who have mastered this type of ordeal?
> > Dave

>
>
> What is the value of "MM_aFORMSconnect_STRING" in
> "Connections/aFORMSconnect.asp"?
>
>

[Dave]

Double checked database location. It is there and named correctly.


"Dave" <dgrisset@sewanee.edu> wrote in message
news:uQQ4pVASEHA.3344@TK2MSFTNGP12.phx.gbl...

> MM_aFORMSconnect_STRING = "dsn=db1;uid=******;pwd=******;"
>
> UID and PWD have values; they aren't ******.
>
> I did try removing UID and PWD but the same error occurs.
>
>
>
>
> "McKirahan" <News@McKirahan.com> wrote in message
> news:7rZtc.8413$IB.7039@attbi_s04...

> > "Dave" <dgrisset@sewanee.edu> wrote in message
> > news:#LQcCWPREHA.1644@TK2MSFTNGP09.phx.gbl...

> > > When attempting to view information dynamically 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
> > > /autoforms/ViewContent.asp, line 8
> > >
> > >
> > >
> > > The automatically generated code from DreamWeaver MX 2004 is:
> > >
> > > <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> > > <!--#include file="Connections/aFORMSconnect.asp" -->
> > > <%
> > > Dim Recordset1
> > > Dim Recordset1_numRows
> > >
> > > Set Recordset1 = Server.CreateObject("ADODB.Recordset")
> > > Recordset1.ActiveConnection = MM_aFORMSconnect_STRING
> > > Recordset1.Source = "SELECT * FROM Guests ORDER BY GuestsID ASC"
> > > Recordset1.CursorType = 0
> > > Recordset1.CursorLocation = 2
> > > Recordset1.LockType = 1
> > > Recordset1.Open()
> > >
> > > Recordset1_numRows = 0
> > > %>
> > >
> > > 1. I can understand why the system doesn't know where the Data source

> is

> > > located (The generated code doesn't reveal it.) Good for security but

> bad

> > > for me since I don't know where or what should be stated regarding

it's

> > > local.
> > > Setting things up by use of the Dreamweaver wizards, I know I pointed

to

> > the

> > > database. Could this be a Dreamweaver bug or is it just me?
> > >
> > > 2. Also utilizing a driver for accessing the database: I know ODBC is

> on

> > > the IIS 5.0 system but the server doesn't seem to think so.
> > >
> > > Anything obvious to those who have mastered this type of ordeal?
> > > Dave

> >
> >
> > What is the value of "MM_aFORMSconnect_STRING" in
> > "Connections/aFORMSconnect.asp"?
> >
> >

>
>