where do i get drivers

[deecee]

OK i made a simple search and results page off a small databse to present to company president. It works fine on my CPU through PWS but when i upload it to our company site....which was made entirely in ASP the results dont show and the error says that no driver was specified. How do i get a driver onto the server?

 

[codestorm]

Yes, you'll need to contact the server administrator to arrange to add a DSN to the live box,

OR

you could change to a DSN-less connection .. in your case you'd have to add a few things like ..

connCascade.asp would contain
<%
MM_connCascade_STRING = &quot;driver=Microsoft Access Driver (*.mdb);dbq=&quot; & Server.MapPath(&quot;<name of your database here>&quot
dim obj_Connection
set obj_Connection = Server.CreateObject(&quot;ADODB.Connection&quot
obj_Connection.Open MM_connCascade_STRING
%>

and the line in the code you supplied above:
connCaAscade.ActiveConnection = MM_connCascade_STRING
would change to
connCaAscade.ActiveConnection = obj_Connection



codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>

 

[deecee]

thnx imma try dat

 

[Ovatvvon]

Hey, sorry I haven't been here for a bit. I was ordered to rifle range for annual qualification this week. I'm back now. Looks like codestorm is handling things nicely though, so you don't need me. -Ovatvvon :-Q

 

[deecee]

hmmmm....i know who not to mess with now