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.
Well, one thing is that the live site has a DSN setup on the server, so the code can connect. If you are trying to develop on your personal computer, then you need to create a DSN, but I can't remember if you can connect to a datasource over the wire.