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
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,