networked home directory

[mobius1983]

Hi,

Im wondering if anyone can help me.

I currently run my own webserver for some personal sites and one work site. Due to backup issues I have moved the files onto a networked computer and have set up iis 'home directory' to point to the networked computer.

But now all of my database connections fail.
If website files are on a different computer than IIS and SQL Server, can I not use any DSN connections that are on the server (that reference 'localhost') in my webpages?

Thank you in advance to anyone that can help me out!

Nick

 

[Serbtastic]

Nope. Localhost is reserved for accessing the local machine. Change your webpages to refer to the actual hostname instead.

 

[mobius1983]

Thanks very much for your swift reply. Just so I have it clear in my head...

If pcA has IIS & SQL installed and pcB has the website asp files. Which computer should have the ODBC DSN for the website?

Thanks soo much for your help

 

[lgarner]

pcA needs the ODBC setup. It'll be running the pages. It sounds like there's another issue.

As I read your post, the web and database servers are one one computer, which is accessing the content via a mapped or UNC connection, right? This should work normally.

 

[mobius1983]

Thanks for your post lgarner, I appriciate everyones help!

I have just gone onto my server, deleted all of the dsn's and all of the SQL server users and started from scratch. And with a bit of playing around with the permissions (really I dont know how I have done it! ) But it now works!!!!

Thank you so much to everyone that has helped with this post, you are both life savers!!

Thanks again

Nick