This took me a really long time to figure out. For some reason I couldn't see the tables in an asp/sql server setup that I had in dreamweaver.
I prefer to use ftp connections in dreamweaver, but I know you probably shouldn't. What you have to do is make sure that you are connected within the same network. Cross network connections via sql server are not as likely to work. I had my sql server for development set up on another network as I had some sites hosted on that server and my roommate likes to play wow. So I decided to get a second connection. But that is neither here nor there... make sure the computer is connected to the same network and save yourself the trouble of trying to figure out which ports are open and closed.
Then create a new ftp connection.
Where you set your HostDirectory and URLPrefix are Very important for these kinds of setups. Your HostDirectory should point to the exact root web directory. For instance if you connect to your host and then there is an html folder, you probably want to enter "/html/" in your HostDirectory setting.
Then, make sure that your url prefix matches up to where you can access the website: http://192.168.2.21
If these two match up to the correct locations, then you should now be able to see the tables in dreamweaver. The reason is that dreamweaver places some scripts in your root folder as well as the connection files. It uses those files to then communicate with the sql server connection and then send you back the information to your interface. If dreamweaver cannot talk to these scripts, you will not be able to see the tables in your database.
Hope this saves you some time! Thanks for reading ... now please click on a google ad :)
Labels: Database, Development, dreamweaver, internet, problem, settings, tables
