ASP HELP URGENTLY NEEDED (ultrradev error)

I know this is not a help forum and I know this should not be posted there but this msg will be closed in a couple of hours.

I have a site using asp created in Dreamweaver Ultradev 4. It works locally using pws but whenever I upload, I get this error msg:

Code:

---

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/valhalla/html/default.asp, line 102

---

heres the code from default.asp (starting with line 101)

set val = Server.CreateObject("ADODB.Recordset")
val.ActiveConnection = MM_comp_STRING
val.Source = "SELECT * FROM Contestant"
val.CursorType = 0
val.CursorLocation = 2
val.LockType = 3
val.Open()
val_numRows = 0
%>


anyone who can help me fix this in the next few hours receives a season pass to blackpool pleasure beach (home of one of the largest roller coasters in the world).

Bruce

(if mg33 is reading this I am very sorry!!!)

Well, did you define the ODBC connection on your server?

Sorry if this sounds obvious, but have you defined the DSN on the server that's hosting your site?

Quote:

---

Originally posted by loydall
Sorry if this sounds obvious, but have you defined the DSN on the server that's hosting your site?

---

Yeah thats basically what i said. ;)

Yeah sorry, didn't notice...

Quote:

---

Originally posted by loydall
Yeah sorry, didn't notice...

---

Doesnt matter, but I would love that pass to the Blackpool pleasure beach! :D

Quote:

---

Originally posted by wouter999
Well, did you define the ODBC connection on your server?

---

??? I am an ultradev newbie, ???

the DNS is your 'keycard' to the database, you must correctly define its parameters otherwise you wont gain access.

You have defined the database in the ODBC (DSN), on your personal computer. Else it doesnt work.

You must also define the ODBC (DSN) on your remote server. Else the ASP can't make a connection to the database. If you dont know how to define the connection, email the server administrator or something. :)

if its working with pws and iss then the dns is correct. I have tested it (localhost) and it works fine, it connects to the databaase and adds records. Its when I upload it all, it falls over. try it here

http://www.intereurope.co.uk/valhalla

and then click on the competition

Yeah on your computer, you defined the ODBC connection. But you also need to do that on the remote host. :)

Then it should work, because the error message says the ODBC connection can't be found. :)


PS get that typewriter effect out of the status bar, I hate that. ;)

If your hosting company doesn't allow you access to their control pannel, you will have to ask them to set up the DSN for you. I have to call the company I use to host my sites if I ever need anything like that doing although I know some hosts will let you do it yourself.

Quote:

---

Originally posted by loydall
If your hosting company doesn't allow you access to their control pannel, you will have to ask them to set up the DSN for you. I have to call the company I use to host my sites if I ever need anything like that doing although I know some hosts will let you do it yourself.

---

Yeah, http://www.mediatemple.net lets it do yourself.

but, the easiest way is to call/email the hosting service.

Razo, here's a custom made email to send the fellas at the hosting company:

Quote:

---

Dear sir/madam,

I would like you to create a DSN (ODBC) connection to my database, I've uploaded it to http://www.blabla.com/bla/database.mdb. Please let me know how you are going to call the connection, so I can modify my ASP pages to match it.

Thank you in advance.

Many regards,
RazoRmedia

---

Nice ehh? :D

Green is the color of nature. In latin, nature means surroundings. You will find that your surroundings are most likely, green. Thus, green is a calming color, a color of relaxation and tranquility. Nature is also growing, evloving, expanding. So green is also the color of hope, and the beginning of something new.


- wot a load of crap wooter

Quote:

---

Originally posted by djswerve

Green is the color of nature. In latin, nature means surroundings. You will find that your surroundings are most likely, green. Thus, green is a calming color, a color of relaxation and tranquility. Nature is also growing, evloving, expanding. So green is also the color of hope, and the beginning of something new.


- wot a load of crap wooter

---

I didnt make it up! check http://www.turtleshell.com

color psychology :D

now I'm getting an 80004005 error - connection not open. please help people, I'm tearing my hair out here

Quote:

---

Originally posted by RazoRmedia
now I'm getting an 80004005 error - connection not open. please help people, I'm tearing my hair out here

---

well I hate to be a jackass, but why arent you asking in the scripting and backend forum????

Quote:

---

Originally posted by wouter999

Quote:

---

Originally posted by djswerve

Green is the color of nature. In latin, nature means surroundings. You will find that your surroundings are most likely, green. Thus, green is a calming color, a color of relaxation and tranquility. Nature is also growing, evloving, expanding. So green is also the color of hope, and the beginning of something new.


- wot a load of crap wooter

---

I didnt make it up! check http://www.turtleshell.com

color psychology :D

---

yes, wouter has that for a footer and "I want some Trashbags!" as an avatar :D He is a man of deep thought :)

Quote:

---

Originally posted by killabry

Quote:

---

Originally posted by wouter999

Quote:

---

Originally posted by djswerve

Green is the color of nature. In latin, nature means surroundings. You will find that your surroundings are most likely, green. Thus, green is a calming color, a color of relaxation and tranquility. Nature is also growing, evloving, expanding. So green is also the color of hope, and the beginning of something new.


- wot a load of crap wooter

---

I didnt make it up! check http://www.turtleshell.com

color psychology :D

---

yes, wouter has that for a footer and "I want some Trashbags!" as an avatar :D He is a man of deep thought :)

---

I emailed trav today, to change it. :)

thanks people. sorry it was here, i was in a rush.

wouter , i'll be in touch,

closed