dsn on server? (asp/JavaScript/Vista)

[kdv]

Hi there,

I've been running a small website without any major problems for quite a while now. I created it using Dreamweaver, generating ASP pages with Javascript.
The site has been on hold for a while and in the meantime I had switched to Vista on my computer. Then I also upgraded to Dreamweaver CS5 and started editing some pages again. I didn't get this to work properly and therefore uninstalled DCS5 and switched back to CS4. Now I am getting connection problems that I have not managed to solve.
On my local computer I use a n ODBC Data Source for the connection and the system DSN is still perfectly fine as it has been defined through the Control Panel, which is linked to the Microsoft Access database I am using.

The index.asp file of the website at the moment generates this error:
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified "

referring to the code line in index.asp that contains:
<%
rcActiveUser.ActiveConnection = MM_gcit_STRING;
%>

A few lines up from this in index.asp the connection file has been included:
<!--#include file="Connections/gcit.asp" -->

This connection file contains:
<%
var MM_gcit_STRING = "dsn=DBGCIT"
%>

Locally things are working ok and the connection tests in Dreamweaver are affermative too.

Obviously locally the DNS is recognized, but remotely the coreresponding information is not available. And frankly I don't know where this should be coming from.

I hope someone can point me in the right direction. If I need to include more information, please let me know.

Thanks in advance!

Katja

 

[ChrisHirst]

Use a connection string rather than a DSN or get your hosting company to set up a DSN on the server.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[kdv]

Thanks very much! Mentioning my provider was the magic word. It immediately dawned on me that at the time I had set up the remote DNS through the provider's control panel (I use Discount.asp). So messing with my DSN locally and editing connection files in Dreamweaver was never going to get me anywhere. I just looked at the DSN definition in the Discountasp control panel and corrected it in my files where necessary. Only mystery is how it got changed (in my files) in the first place). But it's working now again...geez, I spent 6 hours on this today and then fixed it in 10 seconds

Thanks again!