In Dreamweaver CS3 I am trying to set up a site with connection to a MS SQL Server 5.

I do NOT have the database-server installed on my PC – the database is installed on a hosting- company’s server on this address/host:

msdb3.surftown.dk

My site I hosted on the same hosting-company – but the server got the address:

wsw11.surftown.dk

Then I make a connection to the database like this:

MM_dbsql_con_STRING = "DRIVER={SQL Server}; SERVER=msdb3.surftown.dk; DATABASE=uniflex_world; UID=user; PWD=password"

I save this file in the connection-folder in the root of my site.

In this root I also got the site:

guide2design.dk

AND the site I am testing the sql-database on (in a subdirectory):

mssql.guide2design.dk

On this site I got default.asp, where I include the connection and make a repeated region-table.

When I load this up on the server it works very well.

BUT when I try to make a recordset with the function in Dreamweaver I got this error-message:

"Unable to retrieve tables from this connection, click on the ‘Define’…button to test this connection".

At the same time I can retrieve and manage the tables in the program Microsoft SQL Server Management Studio Express so it seems as if the problem is in Adobe Dreamweaver CS3.

In the supportfiles on Adobe Homepage I have seen a solution to Windows XP, but I’m working with Windows Vista.

I have also tried the following connections:

'MM_dbsql_con_STRING = "DRIVER={SQL Server}; SERVER=msdb3.surftown.dk; DATABASE=uniflex_world; UID=user; PWD=password"
'MM_dbsql_con_STRING = "DRIVER=SQL Server; SERVER=msdb3.surftown.dk; UID=user; PWD=password; DATABASE=uniflex_world;"
'MM_dbsql_con_STRING = "Provider=SQLOLEDB;Server=msdb3.surftown.dk;Database=uniflex_world;UID=user;PWD=password"
'MM_dbsql_con_STRING = "Provider=SQLOLEDB; Data Source=212.97.133.33; Initial Catalog=uniflex_world; User Id=user; Password=password"
'MM_dbsql_con_STRING = "dsn= msdb3.surftown.dk;Catalog=uniflex_world; uid=user;pwd=password;"

But the results are the same – working on the webside AND in Microsoft SQL Server Management Studio, but Dreamweaver still can’t retrieve any tables.

I have tried to set up the site both with an ftp-connection and a normal connection where I checked in the site definition “Edit locally, then upload to remote testing server” and “Edit directly on remote testing server using local network”, but none of these 3 ways to do it give a resolution to the problem.

Please help me.

Kindly regards

Joergen Lassen

www.guide2multimedia.com

try the following:
"Provider=sqloledb;Data Source=100.100.100.100,1433; Network Library=DBMSSOCN;Initial Catalog=databasename;User Id=username;Password=yourpassword;"

with your info:

"Provider=sqloledb;Data Source=212.97.133.33, 1433; Network Library=DBMSSOCN;Initial Catalog=uniflex_world;User Id=user;Password=password;"



I was in the same boat but this connection string worked for me:

in Data source change to the ip address wwhere your db resides. The 1433, leave as is. I don't really remember what is for <img src=../images/fwzone/forum/icon_smile.gif border=0 align=middle>. The rest should be self explanatory.
Good luck,

Javier


Javier
"I'm a slow learner and I forget fast" grandpa
DW | FW | ASP | HTML | CSS

Edited by - am7555 on 06 Dec 2008 19:37:12