This is Interesting: Free Magazines for Graphics designers and webmasters
Home > Archive > Dreamweaver > March 2004 > IIS ASP Access Dreamweaver
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
IIS ASP Access Dreamweaver
|
|
|
| Hi, I can hand code an ASP doc so that it can lookup data from an Access Database, how would I do it the lazy way by using Dreamweaver MX 2004. Later on I might consider using Oracle 9i
| |
| Chris In Madison 2004-02-17, 3:29 pm |
| Beware, however, that the code that Dreamweaver creates is somewhat longhand
compared to what you're probably used to.
Best regards,
Chris
| |
| Chris In Madison 2004-02-17, 3:29 pm |
| The easiest way is to use the Create Recordset server behavior, then loop
through the results using the Repeat Region server behavior.
Lots of info in the product help files for this scenario.
Best regards,
Chris
| |
|
| http://www.webthang.co.uk have some good tutorials for that.
regards
Spud
"vmail" <sales@vmail.tk> wrote in message
news:c0tonb$nuj$1@forums.macromedia.com...
> Hi, I can hand code an ASP doc so that it can lookup data from an Access
Database, how would I do it the lazy way by using Dreamweaver MX 2004.
Later on I might consider using Oracle 9i
| |
|
| followed the tutorial, connection file was created, using DNS-less, but it still wont work
| |
| Les Matthews 2004-02-18, 2:42 pm |
| What's not working?
"vmail" <sales@vmail.tk> wrote in message
news:c109nf$ja1$1@forums.macromedia.com...
> followed the tutorial, connection file was created, using DNS-less, but it
still wont work
| |
| Les Matthews 2004-02-18, 2:42 pm |
| What's not working?
"vmail" <sales@vmail.tk> wrote in message
news:c109nf$ja1$1@forums.macromedia.com...
> followed the tutorial, connection file was created, using DNS-less, but it
still wont work
| |
|
| I have not been able to connect to yourdatabase.mdb database from within DW, at
all. Here is what happens
(1) After entering connection string in "Custom Connection String" dialog box,
and then pressing "Test", the following error pops up in a message box
"An unidentified error has occurred
(2) After several other reattempts (checking and rechecking spelling errors
and sundry potential fat-finger mistakes), to no avail, I tried to connect with
the standard ODBC driver for Access, using both a custom connection string
string (DSN-less) and DSN. No luck. Same error
(3) I press the "OK" button, to create the "DBconn.asp" file. Created
perfectly, code inside is as advertised; the "Database Bindings" panel looks
OK: connection appears with the usual tree view structure: "Tables", "Views",
"Stored Procedures"
(5) However, when I attempt to expand any of the treeview items, "Tables", for
example, the following message pops up
"While executing getComponentChildren in Connections.htm, the following
JavaScript error(s) occurred
At line 65 of file "D:\Program Files\Macromedia\Dreamweaver
MX\Configuration\Components\Common\Connections\Connections.js"
exception throw in native function"
I've (a) turned off my firewall (b) turned off script blocking in Norton
Antivirus; I've uninstalled, then reinstalled DW MX. Nothing works
I am running DW MX 2004, Windows XP Pro, IIS 5.1, all on same computer
| |
| Les Matthews 2004-02-18, 4:00 pm |
| what's the code in DBconn.asp?
"vmail" <sales@vmail.tk> wrote in message
news:c10f8v$sas$1@forums.macromedia.com...
> I have not been able to connect to yourdatabase.mdb database from within
DW, at
> all. Here is what happens
>
> (1) After entering connection string in "Custom Connection String" dialog
box,
> and then pressing "Test", the following error pops up in a message box
>
> "An unidentified error has occurred
>
> (2) After several other reattempts (checking and rechecking spelling
errors
> and sundry potential fat-finger mistakes), to no avail, I tried to connect
with
> the standard ODBC driver for Access, using both a custom connection string
> string (DSN-less) and DSN. No luck. Same error
>
> (3) I press the "OK" button, to create the "DBconn.asp" file. Created
> perfectly, code inside is as advertised; the "Database Bindings" panel
looks
> OK: connection appears with the usual tree view structure: "Tables",
"Views",
> "Stored Procedures"
>
> (5) However, when I attempt to expand any of the treeview items,
"Tables", for
> example, the following message pops up
>
> "While executing getComponentChildren in Connections.htm, the following
> JavaScript error(s) occurred
>
> At line 65 of file "D:\Program Files\Macromedia\Dreamweaver
> MX\Configuration\Components\Common\Connections\Connections.js"
> exception throw in native function"
>
> I've (a) turned off my firewall (b) turned off script blocking in Norton
> Antivirus; I've uninstalled, then reinstalled DW MX. Nothing works
>
> I am running DW MX 2004, Windows XP Pro, IIS 5.1, all on same computer
>
>
>
| |
|
| the mdb file is in the root dir for that site
| |
|
| <
' FileName="Connection_odbc_conn_dsn.htm
' Type="ADO"
' DesigntimeType="ADO
' HTTP="false
' Catalog="
' Schema="
Dim MM_dcc_STRIN
MM_dcc_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("yourdatabase.mdb"
%
| |
| Les Matthews 2004-02-18, 4:34 pm |
| It looks like you are missing the closing paretheses after yourdatabase.mdb"
and also the opening ASP tag delimeter (<%) and part of closing ASP tag
delimeter (> ).
I've never used the mapPath connection; I generally use a DSNless string.
When doing so, my conn.asp looks something like below.
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connProject_STRING
MM_connProject_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Webs\MyWeb\Database\myDatabase.mdb;Persist Security Info=False"
%>
BTW, it is best to not place your database within the web root.
"vmail" <sales@vmail.tk> wrote in message
news:c10h8b$22o$1@forums.macromedia.com...
> <
> ' FileName="Connection_odbc_conn_dsn.htm
> ' Type="ADO"
> ' DesigntimeType="ADO
> ' HTTP="false
> ' Catalog="
> ' Schema="
> Dim MM_dcc_STRIN
> MM_dcc_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath("yourdatabase.mdb"
>
> %
>
| |
|
| done what you did, but it still wont work, yeah i only but the db in the root,
just to find out where the fault it, how can i mod the code to that i am using
a db from an external site, i know the location on the D
| |
| Les Matthews 2004-02-18, 6:44 pm |
| If you know the physical path, then use a dsnless connection. Use MapPath
when you don't know the physical path.
"vmail" <sales@vmail.tk> wrote in message
news:c10ma9$9p6$1@forums.macromedia.com...
> done what you did, but it still wont work, yeah i only but the db in the
root,
> just to find out where the fault it, how can i mod the code to that i am
using
> a db from an external site, i know the location on the D
>
| |
| Les Matthews 2004-02-18, 6:44 pm |
| You have to get past the error below:
"I have not been able to connect to yourdatabase.mdb database from within
DW, at
all. Here is what happens
(1) After entering connection string in "Custom Connection String" dialog
box,
and then pressing "Test", the following error pops up in a message box
"An unidentified error has occurred
"
I would try again to "Test" using a connection string similar to below (a
single line):
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Webs\MyWeb\Database\myDatabase.mdb;Persist Security Info=False
Make sure when you test, you don't have the db open (I'm not sure this has
an affect, but why not) or otherwise have a db lock.
| |
|
| tried testing, and got
"An unidentified error has occurred"
again
| |
| Les Matthews 2004-02-18, 7:13 pm |
| You may have to contact MM tech support - that should work.
"vmail" <sales@vmail.tk> wrote in message
news:c10q0f$end$1@forums.macromedia.com...
> tried testing, and got
>
> "An unidentified error has occurred"
>
> again
| |
|
| Erm, to contact MM I need to use the SN Number, DMX is not my copy, it belongs to the Uni, and they will not give out all the info that I need to fill out the forms, now what?
| |
| Les Matthews 2004-02-19, 11:30 am |
| Try a fresh install of DMX?
Is Uni the company you work for? Why won't they give you the SN?
"vmail" <sales@vmail.tk> wrote in message
news:c123cv$56l$1@forums.macromedia.com...
> Erm, to contact MM I need to use the SN Number, DMX is not my copy, it
belongs to the Uni, and they will not give out all the info that I need to
fill out the forms, now what?
| |
|
| No I dont work for the University, could do in a couple of weeks, I'm an MSc student, they wont give out the details to students, will ask them to fresh install
| |
| BoroLee 2004-03-03, 11:29 am |
| Did you manage to resolve this problem???
I am getting exactly the same thing.
Thanks,
Lee.
| |
| BoroLee 2004-03-03, 11:29 am |
| Did you manage to resolve this problem???
I am getting exactly the same thing.
Thanks,
Lee.
|
|
|
| | Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |
|