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?

 

[Ovatvvon]

If you are loading onto an IIS server, more than likely you already have the driver on there...especially if it's a win2k server. It sounds like it's more of your "specified" driver for db access through ADO.

Please specify the type of database you're working with, and also post the connection code you currently have. -Ovatvvon :-Q

 

[deecee]

im using access and whats the connection code??

 

[Ovatvvon]

ACCESS DSN-Less connection...

connString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\InetPub\

http://wwwroot\db\database.mdb;UID=Admin;PWD=;"

Hope this helps. -Ovatvvon :-Q

 

[deecee]

now would this be in my search page or results page?

 

[Ovatvvon]

You would use this connection along with your all of your connection code ANYTIME you need to make a connection and pull, insert, change, or delete information within/from your database.

So, it really depends if you need to make a connection to your database on your search page, results page, or whatever. You need it anytime you're connecting to the db! -Ovatvvon :-Q

 

[durug]

In every page where you grab some information from the DB.
in order to pull out a recordset from a DB you create a connection, etc...
So if you display the information from the database in the resultpage then create the connection there.

 

[deecee]

ok i got that but it works fine on my computer but when i upload it to the web it wont work

 

[Ovatvvon]

well, you probably don't have the database in the same folder on your commercial server as you do on your development server.

It's probably a different folder-layout. Need to adjust it accordingly. -Ovatvvon :-Q

 

[deecee]

here is the exact error i get

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/cascade/cascade/results.asp, line 15


i moved everything off my HD to my server as is

http://www.cascadecorp.com/cascade/cascade/index.htm

 

[Ovatvvon]

ok, so look at line 15...what does it say?

Post your first approx. 30 lines of code here (or less if you have less). Again, as far as I can tell, it's a problem with your connection code.

You're using MS Access, correct? Make sure the driver and file location is correct.

And post your code. -Ovatvvon :-Q

 

[deecee]

her it is...about first 30 lines of my results.asp page

<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include file=&quot;Connections/connCascade.asp&quot; -->
<%
Dim connCaAscade__MMColParam
connCaAscade__MMColParam = &quot;1&quot;
if (Request.QueryString(&quot;Low&quot <> &quot;&quot then connCaAscade__MMColParam = Request.QueryString(&quot;Low&quot
%>
<%
Dim connCaAscade__High
connCaAscade__High = &quot;5000&quot;
if (Request.QueryString(&quot;High&quot <> &quot;&quot then connCaAscade__High = Request.QueryString(&quot;High&quot
%>
<%
set connCaAscade = Server.CreateObject(&quot;ADODB.Recordset&quot
connCaAscade.ActiveConnection = MM_connCascade_STRING
connCaAscade.Source = &quot;SELECT BRAND, SKU, DESCRIPTION, MSRP, PRICE FROM Cascade WHERE MSRP >= &quot; + Replace(connCaAscade__MMColParam, &quot;'&quot;, &quot;''&quot + &quot; AND MSRP <= &quot; + Replace(connCaAscade__High, &quot;'&quot;, &quot;''&quot + &quot;&quot;
connCaAscade.CursorType = 0
connCaAscade.CursorLocation = 2
connCaAscade.LockType = 3
connCaAscade.Open()
connCaAscade_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = 10
Dim Repeat1__index
Repeat1__index = 0
connCaAscade_numRows = connCaAscade_numRows + Repeat1__numRows
%>

 

[deecee]

**cough **cough

 

[codestorm]

How about posting the contents of connCascade.asp? codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>

 

[deecee]

<%
' FileName=&quot;Connection_odbc_conn_dsn.htm&quot;
' Type=&quot;ADO&quot;
' HTTP=&quot;false&quot;
' Catalog=&quot;&quot;
' Schema=&quot;&quot;
MM_connCascade_STRING = &quot;dsn=Cascade Products;&quot;
%>

 

[deecee]

**cough **cough

 

[codestorm]

OK so is the DSN Cascade Products created on the new box?
And are it's settings correct for that box? codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>

 

[deecee]

new box? whats the box and how do ic heck the settings?

 

[codestorm]

The pages were working on your computer and then you uploaded them to another computer, yes?

On the computer (&quot;box&quot you uploaded the pages (and database) to (&quot;live box&quot, you need to create a DSN so the page knows how to connect to the database, and where it is.

On the live box open the Control Panel (Start > Settings > Control Panel).
If the live box is using Windows 2000 you'll have to double-click on Administrative Tools, otherwise from memory I think it's directly in the Control Panel.
You're looking for something called Data Sources (ODBC) or similar.
If there are two, one will probably have 32bit or some such in the name. In this case run the 32bit one.

In either case once you run the ODBC Data Sources app it should guide you through setting up a DSN to connect the database to the pages.
Given the code you supplied I think it should probably be a User or System DSN, not a File DSN.

Let me know if you need more help. codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>

 

[deecee]

so its to a remote server where the site is hosted do i contact the server admin?