troubleshooting Question

Dreamwearver 8 - SQL Server 2005 Connections - No Tables Found

Avatar of sdkman
sdkman asked on
ASPAdobe DreamweaverMicrosoft SQL Server 2005
6 Comments1 Solution373 ViewsLast Modified:
I should be grateful if someone would please solve my problem, as detailed below.

To set the scene, the following technologies are in play&

Local Machine: Windows 2000, Dreamweaver 8

Web Server: Windows Server 2000 (Advanced, SP4, sqlncli.msi applied)

SQL Server: Windows Server 2003, SQL Server 2005

Development Language: Classic ASP

The problem&

I am connecting to an SQL Server 2005 database using the in-built features of Dreamweaver 8, found under the Databases tab. I have applied the file, sqlncli.msi (downloaded from Microsoft), to the web server, which enables the use the necessary SQL Native Client drivers and providers.

I have successfully connected to the required database on the SQL 2005 server, using either the Custom Connection String&

MM_IMWebsite_STRING = "Provider=SQLNCLI;Server=myServer;Database=myDatabase;Uid=myID; Pwd=myPassword;"

Or the Data Source Name (DSN)&

MM_IMWebsite_DSN_STRING = "dsn=myDSNName Uid=myID; Pwd=myPassword;"

&Methods. There are no error messages and all connections test successfully; however, when I expand the connection entries under the Databases tab, everything seems ok, until I click on Tables. In both cases None is displayed.

For completeness, I should mention the following&

1. The Stored Procedures & Views are all visible/available in the 'DSN' connection, but only the Stored Procedures are visible/available in the Custom Connection String connection (Views displays None).

2. The System DSN has been created on the Web Server, using the SQL Native Client.

Can anyone assist me in accessing my SQL 2005 Databases correctly, such that Dreamweaver 8 can make use of the data stored in the tables?

Thanking you in advance,

Simon
ASKER CERTIFIED SOLUTION
saoirse1916

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros