Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: ocean10000
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
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.
That allows any windows user to connect using that DSN. If it is setup as a 'User DSN' under your Windows account then the IUSR account that IIS uses cannot see it.
Looking at the web.config file I can see the database server name/db name/user name and password.
Then the site isnt using a dsn is it, if it was those details would be in the dsn not in web.config.
The connection you wrote tries to use a dsn that doesnt exist thats why you get an error.
Ask for some info from the database person, once you know how the SQL authenticates requests from the web app you can decide how to connect & write the appropriate connection string.