connection to database

[mj@leicester]

Hi im using dreamweaver for the first time and im having problems displaying
recordsets between the database and dreamweaver. I have defined the site, i
have created a database and i have done all the stuff with dsn. I have
successfully connected the database to my webpage but im having problems with
my recordset, when i try to click live data view the data from the database
does not appear, what appears is a window saying "live data error" . Withinn in
this window information comes up with the error saying-

- error type;
microsoft OLE DB provider for ODBC drivers (0x80004005)
[microsoft][ODBC microsoft access driver] could not use
"(unknown)"; file already in use
/i-lettings/homepage_skcgdi2h2.asp, line 5

I am using asp.Javascript and IIS and im not sure what to do next as ive read
all the books and followed the instructions. Im not sure if there is a problem
with my dreamweaver as before i tried to use PHP and MYSQL but could not
connect to a database as it kept saying unidentified error. Could someone
please help im going mad.

[mj@leicester]

Hi im using dreamweaver for the first time and im having problems displaying
recordsets between the database and dreamweaver. I have defined the site, i
have created a database and i have done all the stuff with dsn. I have
successfully connected the database to my webpage but im having problems with
my recordset, when i try to click live data view the data from the database
does not appear, what appears is a window saying "live data error" . Withinn in
this window information comes up with the error saying-

- error type;
microsoft OLE DB provider for ODBC drivers (0x80004005)
[microsoft][ODBC microsoft access driver] could not use
"(unknown)"; file already in use
/i-lettings/homepage_skcgdi2h2.asp, line 5

I am using asp.Javascript and IIS and im not sure what to do next as ive read
all the books and followed the instructions. Im not sure if there is a problem
with my dreamweaver as before i tried to use PHP and MYSQL but could not
connect to a database as it kept saying unidentified error. Could someone
please help im going mad.

[mj@leicester]

Hi im using dreamweaver for the first time and im having problems displaying
recordsets between the database and dreamweaver. I have defined the site, i
have created a database and i have done all the stuff with dsn. I have
successfully connected the database to my webpage but im having problems with
my recordset, when i try to click live data view the data from the database
does not appear, what appears is a window saying "live data error" . Withinn in
this window information comes up with the error saying-

- error type;
microsoft OLE DB provider for ODBC drivers (0x80004005)
[microsoft][ODBC microsoft access driver] could not use
"(unknown)"; file already in use
/i-lettings/homepage_skcgdi2h2.asp, line 5

I am using asp.Javascript and IIS and im not sure what to do next as ive read
all the books and followed the instructions. Im not sure if there is a problem
with my dreamweaver as before i tried to use PHP and MYSQL but could not
connect to a database as it kept saying unidentified error. Could someone
please help im going mad. :confused;

[BillB]

Try this. Put this in your /database/ folder and give it a Connection name.

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim DP_connDBName
Dim DP_connDBBasePath, DP_connDBPath
Dim MM_realestate_String

'add your database name
DP_connDBName = "my_db.mdb"

'live string
'make this your absolute server path
DP_connDBBasePath = "D:\Inetpub\www\RealEstatePro\database\"

'local string (used for testing locally, if different then server path)
'DP_connDBBasePath = "D:\InetPub\www\RealEstatePro\database\"

DP_connDBPath = DP_connDBBasePath & DP_connDBName
MM_realestate_String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
DP_connDBPath & ";"

%>


--
Bill
[url]www.DataPacks.com[/url]
Home Of Real Estate Pro



"mj@leicester" <webforumsuser@macromedia.com> wrote in message
news:d1c3vl$ijd$1@forums.macromedia.com...

> Hi im using dreamweaver for the first time and im having problems
> displaying
> recordsets between the database and dreamweaver. I have defined the site,
> i
> have created a database and i have done all the stuff with dsn. I have
> successfully connected the database to my webpage but im having problems
> with
> my recordset, when i try to click live data view the data from the
> database
> does not appear, what appears is a window saying "live data error" .
> Withinn in
> this window information comes up with the error saying-
>
> - error type;
> microsoft OLE DB provider for ODBC drivers (0x80004005)
> [microsoft][ODBC microsoft access driver] could not use
> "(unknown)"; file already in use
> /i-lettings/homepage_skcgdi2h2.asp, line 5
>
> I am using asp.Javascript and IIS and im not sure what to do next as ive
> read
> all the books and followed the instructions. Im not sure if there is a
> problem
> with my dreamweaver as before i tried to use PHP and MYSQL but could not
> connect to a database as it kept saying unidentified error. Could someone
> please help im going mad. :confused;
>