Macromedia 8, Access & ASP technology Not working

Report · Aug 31, 2006

I am developing asp pages using dreamweaver and ms access database. I am going through tutorials and every time I try to add a Recordset Query and I find my database, I test it and it works fine. But when I hit ok I get this error EVERY TIME with EVERY Database I try....

While executing applyServerBehavior in Recordset.htm, a javascript error occured.

I am new to ASP and access databases, but I am able to see my records and when I hit "test" it shows me that it is connecting. Why is this so? I also updated Dreamweaver to 8.0.2 as needed! Can anyone shed some light on this? I am really lost!

Report · Aug 31, 2006

Do you have any extensions installed? If so, which ones?

--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"yinyang042" <webforumsuser@macromedia.com> wrote in message
news:ed81cl$bnq$1@forums.macromedia.com...
>I am developing asp pages using dreamweaver and ms access database. I am
>going
> through tutorials and every time I try to add a Recordset Query and I find
> my
> database, I test it and it works fine. But when I hit ok I get this error
> EVERY
> TIME with EVERY Database I try....
>
> While executing applyServerBehavior in Recordset.htm, a javascript error
> occured.
>
> I am new to ASP and access databases, but I am able to see my records and
> when
> I hit "test" it shows me that it is connecting. Why is this so? I also
> updated
> Dreamweaver to 8.0.2 as needed! Can anyone shed some light on this? I am
> really
> lost!
>

Report · Mar 27, 2007

Dreamweaver 8 database connection to Microsoft access using .net “C#”

Trouble connecting to database in a local testing server. ( testing XP professional server is working just fine rendering dynamic pages , and using .net framework 2.0 (version 2.0.50727.42 )

Data link properties makes a successful connection to my database in the testing server, this is done by going in dreamweaver and selecting :
1. Applications
2. Databases
3. OLE DB Connections
4. Buid

I then get the following string in the OLE DB connection window that test positive in the data link properties

"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Inetpub\wwwroot\website\database\mydatabase.mdb"

Then I click test on the OLE DB connection window and I get an Undefined error has occurred

This is not allowing to connect to my database and use the useful functionality dreamweaver 8 provides.

Report · Sep 01, 2006

Last night I thought that might be the problem so I installed some extensions thinking maybe taht would work... Such as the ASP.NET Data Sources, and the ASP.NET Upload but I dont think it is correct. I am following the tutorials rightn ow from Lynda.com on setting up an ASP blog. I am attempting to edit a site after I learn ASP but I cant even send record Query's without that javascript error. I am very furstrated.... It makes me feel lost as H***!

Report · Sep 01, 2006

ASP and ASP .NET are not compatible. Make sure you know which one you're
trying to use.
A lot of extensions dealing with recordsets are incompatible with 8.0.2.
Make sure you check the information about the extension to see if it is
compatible with 8.0.2 (not just 8.0 or 8.0.1). When in doubt, contact the
extension developer.

"yinyang042" <webforumsuser@macromedia.com> wrote in message
news:ed9eq5$1cc$1@forums.macromedia.com...
> Last night I thought that might be the problem so I installed some
> extensions
> thinking maybe taht would work... Such as the ASP.NET Data Sources, and
> the
> ASP.NET Upload but I dont think it is correct. I am following the
> tutorials
> rightn ow from Lynda.com on setting up an ASP blog. I am attempting to
> edit a
> site after I learn ASP but I cant even send record Query's without that
> javascript error. I am very furstrated.... It makes me feel lost as H***!
>
>

Report · Sep 01, 2006

That is a logical thought but before I had any extensions on I was not able to do a record query. I can connect to the dabase using DSN, and it seems to read my Database because the user authentication section works fine. I just keep getting the popup box saying

While executing applyServerBehavior in Recordset.htm, a javascript error occured.

I cant do any query at all from the database pannel in dreamweaver... HELP PLEASE?!!?!!?

Report · Sep 01, 2006

There must be some reason. When I asked if you had any extensions
installed, that was because some extensions out there overwrite native
Dreamweaver code and I was concerned that had happened to you. If you
formerly had extensions that overwrote the code, it's possible that
uninstalling it would not restore the original.

--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"yinyang042" <webforumsuser@macromedia.com> wrote in message
news:ed9n5b$avc$1@forums.macromedia.com...
> That is a logical thought but before I had any extensions on I was not
> able to
> do a record query. I can connect to the dabase using DSN, and it seems to
> read
> my Database because the user authentication section works fine. I just
> keep
> getting the popup box saying
>
> While executing applyServerBehavior in Recordset.htm, a javascript error
> occured.
>
> I cant do any query at all from the database pannel in dreamweaver... HELP
> PLEASE?!!?!!?
>

Report · Sep 02, 2006

You can try this simple fix -

Quit DW.

Find this folder -

C:\Documents and Settings\<username>\Application Data\Macromedia\Dreamweaver
8\Configuration\WinFileCache-*.dat
(these folders are normally hidden - you may have to use Explorer > Tools >
Folder Options to unhide them)

and delete it.

Restart DW. Works better?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"yinyang042" <webforumsuser@macromedia.com> wrote in message
news:ed9n5b$avc$1@forums.macromedia.com...
> That is a logical thought but before I had any extensions on I was not
> able to
> do a record query. I can connect to the dabase using DSN, and it seems to
> read
> my Database because the user authentication section works fine. I just
> keep
> getting the popup box saying
>
> While executing applyServerBehavior in Recordset.htm, a javascript error
> occured.
>
> I cant do any query at all from the database pannel in dreamweaver... HELP
> PLEASE?!!?!!?
>

Report · Mar 22, 2007

Nice work man. I had a quick scroll through looking for an answer to this prob and bang! - there you were. Seems to have done the job.

My prob was that after switching to a new machine and reinstalling dreamweaver 8, upload behaviours that were clearly there before on certain pages were now not showing up at all on the server behaviours tab. So I couldn't edit any changes like before. After moving the .bat file, the behaviours have magically reappeared.

Cheers pal!