Dreamweaver wont connect to a Database

XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).

Moderator: General Moderators

Post Reply
NotOnUrNelly
Forum Commoner
Posts: 61
Joined: Wed Mar 24, 2004 4:45 pm

Dreamweaver wont connect to a Database

Post by NotOnUrNelly »

Hi All,

Im a bit of a newbie to this.

I am working my way through a book at the moment that is teaching me php through dreamweaver. The book is not really hard coding its about using dreamweavers menu's database, recordset facilties etc.

Anyhow heres my problem.

I have created a link to my database through the Window menu-databases.

I created a link to my web based mysql datase by adding databse names, passwords etc to the dialog box that pops up.

I then go onto create a recordset, using the bindings tab, recordset(query) link. The interface pops up and I can create my recordsets no problem.

I have done all of the above numerous times, for many pages.

Sometimes (at home when) i come back to the page that I have created database links and recordsets upon. the page stalls when I open a page with a recordset on.

I then get a progress bar saying "testing database connection" this goes on for about 2 minutes then I get a message saying could not connect to datasbse THis also happens when I go to create new recordsets or connect to my old ones, the form(interface) searches for a while after selecting the databse but doe snot pick up any tables. I then get the value ***no tables found.

This is only occassional, and sometimes its works fine.

I believe it could be my internet service provider letting me down.

I have experimented with connecting to database and creating recordsets at various times during the day, and at peak times it is impossible to create recordsets/connection through the dreamweaver tools and I end up creating them manually by hard coding.

Another big issue and this is really annoying, is the fact that if I go to a page that I have previously created a recordset set on using dreamweavers wizards. If the server is struggling to connect everytime I do something on the page or change anything text, go from design view to code view etc. Dreamweaver tries to connect to the database and I get the progress bar for about 2 minutes till it fails. This is really annoying because, I know I cant connect using dreamweaver, so take the hard coding option(good Proactise) but the previous connections I have made, are trying to boot up and failing so. I cant get any work done. It would be 2 much undoing to go back and undo or lose all the automated dreamweaver code.

Is this an internet connection problem, it seems fine at low peak usage time ie saturday nights, week nights are a nightmare though

I also have no problem uploading my pages by dreamweaver ftp from my site connections and all of my pages with dynamic data are working fine and dandy allbeit a bit slow.

I cannot use any of Dreamweavers connection wizards whilst at work, but I suspect this may be a firewall issue.

I just get the trying to connect to server progress bar which then fails.

Sorry to waffle, has anyone else had this problem

Many Thanks
Jamie
User avatar
visonardo
Forum Contributor
Posts: 136
Joined: Mon Oct 02, 2006 7:49 pm
Location: Argentina, South America´s Sun.

Post by visonardo »

so long post. Another thing, i dont guess that will give you here the solution (i didnt read your message, so long) because this is payed softward and suposedly here we work with all "open source".
Any time, when i had problem with dreamweaver, i found my solution in their official forum in macromedia.com. If you didnt pay to have this program, just say that is a trial version and done, but you will dont have problem there
Post Reply