complete newbie needs help uploading asp files

[neilyboy]

I have just created my first asp pages which are a basic search page and insert new record page, they are linked to a little .mdb database.
everything works fine on my local win2k machine, but when i upload the files to my companmy intranet server i get a blank page when i click search, i then added a .mdb DSN on the server exactly the same as the one on the local machine (except the path to the .mdb files is different) and then the error i got when i clicked search is the following:
error type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
{Microsoft}[ODBC Microsoft Access Driver] too few parameters, expected 2.
/ultraddevtest/results.asp, line 15

Any ideas or help would be very much appreciated, as i said i am very new to this database stuff!!!!

Many Thanks in advance

Neil.

 

[Cheech]

This error message usually points to an error in your SQL statement.

Post the code and db field names Live long and make your kids suffer..

 

[neilyboy]

My database is called test.mdb it is a very simple table with 4 fields format,title,condition and release, the search is done via the format field. the Access DSN is also called test.
<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include file=&quot;Connections/test.asp&quot; -->
<%
Dim albumcollection__MMColParam
albumcollection__MMColParam = &quot;1&quot;
if (Request.QueryString(&quot;Format&quot <> &quot;&quot then albumcollection__MMColParam = Request.QueryString(&quot;Format&quot
%>
<%
set albumcollection = Server.CreateObject(&quot;ADODB.Recordset&quot
albumcollection.ActiveConnection = MM_test_STRING
albumcollection.Source = &quot;SELECT Format, Title, Release, Condition FROM Table1 WHERE Format = '&quot; + Replace(albumcollection__MMColParam, &quot;'&quot;, &quot;''&quot + &quot;'&quot;
albumcollection.CursorType = 0
albumcollection.CursorLocation = 2
albumcollection.LockType = 3
albumcollection.Open() (THIS IS LINE 15 OF THE CODE!!)
albumcollection_numRows = 0
%>

Please excuse my ignorance if i haven't supplied enough or the right info but this is totally new to me.

Hope you can help

Kind Regards

neil

 

[Cheech]

not sure but I think Release may be a reserved word try changing your db column names to my_*** or something along those lines and redo your results page.

Cheech Live long and make your kids suffer..

 

[neilyboy]

This doesn't make sense though if it works on my local machine though, does it?
I do appreciate your help anyway.

 

[Cheech]

PWS is a lot more forgiving than IIS Live long and make your kids suffer..

 

[Cheech]

& if you dont want to try suggestions why post on a forum Live long and make your kids suffer..

 

[neilyboy]

I tried what you said but to no avail!!!
I'm using IIS on my local machine and it works fine!!!
Could it be that the pages are looking for the databse in a certain directory yet when i upload the site to the server the database is in a different directory and thus it can't find it?

 

[Cheech]

Your using a DSN if they are called the same in both places as long as the DSN on your remote is set to point to the correct file then should be okay. Who set up the DSN on the Intranet server?

Live long and make your kids suffer..

 

[neilyboy]

I configured my intranet server access DSN with the exact same pathname as i did on my local machine i.e. c:\inetpub\

http://wwwroot\database\test.mdb

and it worked fine!!
This was how the dsn was on my local machine, on the server i had uploaded the pages to a different page and the dsn was setup to point to c:\inetpub\

http://wwwroot\testdatabase\test.mdb.

I guess thats why i didn't work as the command was looking for the database in a different place!!!
Many thanks for your help