SQLServer 2000 DB Connection

[Guest]

Hi All;
I'm having a bit of a problem creating a Db connection to my SQLServer2000 DB's from Dreamweaver. Well, actually, that's a bit inaccurate: I can get a connection, test it and it all works fine, but I've got no access to any of the tables, views, stored procedures etc.. in my DB's in Dreamweaver. This is the same whether I use a local or testing DSN.

It would seem also that when I create the system DSN using the administrative tools and input the username and password, that all works fine and the test succeeds etc...However, if I then "Ok" that, then return to it (using "configure"), then it loses the password (but not the username) and the test fails. It would seem the two are related.

Any ideas anybody??

Thanks

[Guest]

If SQL is local, then the connection script would look like this:

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_cnConn_STRING
MM_ConnectionName_STRING = "dsn=nameinIIS;uid=username;pwd=password;"
%>

[Guest]

Thanks for that. That actually worked (well in a roundabout sort of way). I'll explain: It turns out that the initial connection string that I was using also works as well!! This was:

Provider=sqloledb;Data Source=[MACHIINE NAME];Initial Catalog=[ANY EXISTING DB NAME];Uid=[ENTERPRISE MANAGER LOGIN];Pwd=[ENTERPRISE MANAGER LOGIN PWD];

HOWEVER after doing a bit of further investigation, I discovered that Dreamweaver didn't like my PASSWORD!! I'm reluctant to say this is a bug before someone else can verify this for me. Basically, Dreamweaver doesn't like the substring "$$" in the password!! A single "$" is fine, but not "$$" !!! I've not tested it with other (sub)strings so I'm not sure how "widespread" this problem might be. I admit it would be a rather obscure bug to uncover but, pretty significant I believe.

The fact that passwords of this nature work fine in SQL Server/ Enterprise Manager would lead me to conclude that this is not a problem with SQL Server 2000.

If you could give that a quick check and let us know that'd be really good.

Thanks...