I'm trying to connect to my remote SQL database using ASP.NET in Dreamweaver MX, but I keep getting either error 407 proxy authentication required or a message asking me if the ODBC DSN exists on the web server. I'm pretty sure ASP.NET doesn't use ODBC DSNs so I am more than a little confused. Anyone else had similar issues?

Thanks,

Christine

Can you show the exact code that tries to connect to the database ?

---------------------------------------
Rik Eshuis

---------------------------------------

Can you show the exact code that tries to connect to the database ?

This is in the web.config file.

<configuration>

<system.web>
<customErrors mode="Off"/>
</system.web>

<appSettings>
<add key="MM_CONNECTION_HANDLER_oneplus" value="sqlserver.htm" />
<add key="MM_CONNECTION_STRING_oneplus" value="Persist Security Info=False;Data Source=[213.111.111.111];Initial Catalog=[dbname];User ID=[admin];Password=[sa];" />
<add key="MM_CONNECTION_DATABASETYPE_oneplus" value="SQLServer" />
<add key="MM_CONNECTION_SCHEMA_oneplus" value="" />
<add key="MM_CONNECTION_CATALOG_oneplus" value="" />
</appSettings>
</configuration>

Cheers,

Christine

Hmm, can't fault this <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

And the aspx code that's accessing the database ?

---------------------------------------
Rik Eshuis

---------------------------------------

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hmm, can't fault this <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

And the aspx code that's accessing the database ?

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Um, I was afraid you'd say that! There's no other code (that I know of). I've only got as far as trying to test the connection string ... and it failing miserably. Starting to think it might be an access issue with my network, which means I have to talk to my IT bods....again, they're starting to run from me in the corridors...

Cheers,

Christine