SQL Server Tables Not Showing Up

[Morgan Ferry]

I have been coding in Dreamweaver for a while and have a connection to a SQL
Server which resides on my server. As of the last couple days, my SQL Server
tables no longer show up. I get a connection to the database and are able to
test the connection successfully, but if I expand Tables under the connection,
I get "None". I know this same thing happened to me a few years ago, but for
the life of me I can't remember what I did to solve it. I know my host did
some ip changes and upgrades on my server, so maybe I am missing some files?
Any help here? Are there stored procedures I am suppose to run on the server
that might have gotten lost? I so can't remember .... HELP!

[Morgan Ferry]

More info: when i try to add a dataset I get the following message when I try
and open the tables after pointing to my connection object:

Error calling GetTables:
An unidentified error has occurred.

[Morgan Ferry]

I followed the instructions in this quick note: [url]http://www.macromedia.com/support/dreamweaver/ts/documents/dw_xp_sp2.htm#aspnet_db[/url]

and it had no effect. Still have the same problem.

[Morgan Ferry]

I followed the instructions in this quick note: [url]http://www.macromedia.com/support/dreamweaver/ts/documents/dw_xp_sp2.htm#aspnet_db[/url]

and it had no effect. Still have the same problem.

[Morgan Ferry]

I followed the instructions in this quick note: [url]http://www.macromedia.com/support/dreamweaver/ts/documents/dw_xp_sp2.htm#aspnet_db[/url]

and it had no effect. Still have the same problem.

[Morgan Ferry]

I followed the instructions in this quick note: [url]http://www.macromedia.com/support/dreamweaver/ts/documents/dw_xp_sp2.htm#aspnet_db[/url]

and it had no effect. Still have the same problem.

[Slick6997]

Have you fixed this yet? I just applied the Microsoft MDAC patch to 3 of my
web servers and I am now getting this error message. When I removed this
patch, it started working again. Patch is MS06-014 KB 911562. I don't know if
that is your problem too but Macromedia needs to fix this.

[Progressive_Learning]

hmmm.....Im starting to think no-one has even looked at it.

I too am having this problem. please check it out.