Database connects but no tables are shown

[Guest]

Hello

I have connected to the database on my remote server in dreamweaver 8 and it says its connected successfully, but when I open the tree or try to make a recordset no tables are show and when I try it in advanced this error appears:

"Error calling GetTables:

MySQL Error#: 1064

You have an error in your SQL syntax; check the manual that

correponds to you MySQL server version for the right syntax to use

near '-maillist' at line1"

maillist being my database name

I'm not very good at dynamics yet so don't really understand the SQL syntax

This is what dreamweaver connection made me:

<?php

# FileName="Connection_php_mysql.htm"

# Type="MYSQL"

# HTTP="true"

$hostname_blog = "localhost";

$database_blog = "servername"

$username_blog ="servername"

$password_blog ="password"

$blog = mysql_pconnect ($hostname_blog, $username_blog, $password_blog or trigger_error (mysql_error (), E_USER_ERROR);

?>

Don't know if any of this makes sence to you.

Please Help!

[Lon_Winters]

There is a patch for DW 8 that fixes this, along with other steps you may need to take. It should still be somewhere on the Adobe support site.

If you can't find it, delete the connection, delete the connection scripts, restart DW and add the connection back. (you may even need to do that after installing the patch.

[Guest]

Hi I installed the update dreamweaver 8.0.1 updates and dreamweaver 8.0.2 updater but they didn't work is this the patch?

[Lon_Winters]

Yep, that's the one. Did you try deleting the connection scripts, etc?

[Guest]

Yeah I've installed it twice and disabled all extentions to see if that would work. I'm thinking its a hosting problem now even thou their saying its not because it all works fine when i connect to the database of my computer, what do you think?

[Lon_Winters]

Is there any way you can check it on another computer using a different version or installation of Dreamweaver?

But, from your response, it doesn't sound like you've actually deleted the connection scripts - it's a specific command in DW. You've installed the patch so that's good, you can verify the installation under the About menu and look for the version number. Bit then here's exactly what you need to do just to cover all bases

1.  First delete the database connection from the Databases tab which is alongside the Bindings tab and the Server Behaviors tab. You'll highlight the connection, click the minus sign, and confirm. This will delete the connections folder and then file within.

2.  From the Commands menu, find Connection Scripts > Delete Connection Scripts.(I'm guessing from memory, if it isn't the Commands menu, try the Site menu) 3.  Exit and restart DW 4.  Define the database connection again, use the same info as before, server, DB name, etc. Make sure you name the connection name as before as any files you have that use the connection will be looking for it under that name. Test the connection to make sure it can once again establish the connection.

That should work. I've had to do this several times before and not just in DW 8. Sometimes you don't have to go through all the steps exactly, but then again sometimes you have to repeat them once or twice.