Hi
I'm in a bit of a situation. I've agreed to what I thought would be a very simple piece of development for a web designer friend of mine who has a dead line for tomorrow. It's just a very simple CMS for one page. However I haven't had a chance to start the coding yet because I have spent all day trying to connect to the client database. Here are the problems:
1. The sql server doesn't allow remote access. It's all done through a web interface
2. I have no ftp details, they are all encrypted in a dreamweaver export.
3. I've never used dreamweaver before.
4. All of their current pages are in asp.net and I only know asp.
Looking at the web.config file I can see the database server name/db name/user name and password. So I have tried to use these details in a classic asp page:
Set gobjDB = CreateObject("ADODB.Connection")
gobjDB.mode = 3
gobjDB.Open "DSN=dbname;UID=username;PWD=password;"
But I get the error "Data source name not found and no default driver specified" suggesting the DNS hasn't been set-up. But if this is the case why does it work with the current live asp.net pages?
Any help on how I can connect to the db using classic asp would be greatly appreciated.
Many thanks.
