This topic is locked

Error number 3001 on live server

3/11/2005 10:16:02 AM
ASPRunnerPro General questions
garydee author

Hi guys - I'm having a problem running my code on a particular server.
My code works locally (on my machine - Win 2000 with ADO v 2.5 on it)
and it also works on a hosted server from Fasthosts.co.uk
BUT however - where the site is hosted - on a company called NewNet.co.uk my code totally falls over
When I try to go into any of the list pages I get the following error:
Error number 3001

Error description Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

URL /cmtest/Products_list.asp

SQL query select [AutoID], [Name], [Price], [SaleItem], [SalePrice], [VAT], [Image], [ShowOnSite], [Cat1A], [Cat2A] From [Products]
The MDAC version on there is 2.5 also but I think its a windows 2003 server.
This is totally doing my head in because the code works in two test locations but not on the live server!
The host company will do very little unless I can tell them exactly what is wrong. At the moment I'm trying to get them to upgrade the MDAC version to the latest 2.8 but other than that I have no idea.
Have you any idea Sergy? Or anyone else ever experience this??
Thanks in advance guys
GaryDee

garydee author 3/11/2005

I've determined that this error ONLY seems to be happening on the LIST pages.
Is there something on the list pages Sergey that would cause this not to work on one server but to work on another?
Any thoughts?
Thanks in advance
GaryDee

IReland

Admin 3/12/2005

Hi,
what is the website URL where I can see it? Also I need to know your connection string and what database do you use.
If you have more info about Web server enviroment you can post it here as well.

R
Robert 3/12/2005

I had this same problem too...

On my original host, it still doesn't work; On a second I became a member it just worked after ages. Chances to connection string ended solving the problem. On a third host it worked from moment one.

I would also like to understand this issue...my first host is richer in many other resources and I would like to make it work there...

garydee author 3/13/2005

Sergey - I've sent an email to support@xlinesoft.com with all the info you asked.
Hoping you can help me.
Many thanks
GaryDee <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3697&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />

500214 3/18/2005

I am having the same problem. It seems I recall seeing somewhere on my host's web site that ASP is supported, but that their default system is Linix blah blah .... and that if a user needed ASP, that user would need to contact them and they would move the sight over to another type of server. My web site host is christianwebhost.com.
I hope this is not the problem, and the solution is really just a quick and easy fix in the code. Has anyone come up with a solution yet?

500215 3/18/2005

Here is the error I am getting:
ASP error happened
Technical information

Error number 3001

Error description The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.

URL /myweb/Project_Information_list.asp

SQL query select [Job#], [Job Name], [Customer], [Contact], [City], [Address], [State], [JobSite Address], [JobSite City], [JobSite State], [Phone Number], [Fax Number], [Accessories], [Submittals IN], [Submittals OUT], [Date Sold] From [Project Information]

500216 3/22/2005

Man, I am just totaly stumped. Has anyone found an answer?

Admin 3/22/2005

Hi,
Windows-based Web server is preferred way to run ASP pages. If don't like to switch hosting company or plan you can use PHPRunner which does the same for PHP and MySQL.
If you still need to make it working on Linux box post your connection string here.

500217 3/22/2005

Admin, thank you for your reply. Using the other program may be the trick. However, just out of curiosity I have posted my connection string (I think) to see what you would change to make it work on Linux. Is this what you meant?
<%@ Language=VBScript %>

<%

strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("db\db6[1].mdb") & ";UID=admin1;PWD=2131"

500218 3/22/2005

Well I just tried the demo version of the PHPrunner. I got it working with my database online. However I realized that I was getting away from the MSAccess databse that I made which was pretty simple. Using the phprunner I can't use the MSAccess database.

I would really prefer to find a solution that would correct the original question. I have fought it for a while and still can not get the ASPRunner to work. I keep getting the same error mentioned above.

Admin 3/23/2005

Sorry, ASP doesn't work with MS Access files on Linux box.
You still can switch to Windows hosting or wait until we release PHPRunner that supports MS Access databases also. This version will be available in April.

500219 7/12/2005

strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (.mdb)};DBQ=" & Server.Mappath ("data.mdb")
vs
strConnection = "Driver={Microsoft Access Driver (
.mdb)};DBQ=" & Server.Mappath ("data.mdb")
one works on one server the other on my other server.

501149 8/24/2005

Hi
Did anyone finally resolve this issue, I get the exact same error.
I am getting nowhere fast.
Tried everything, change the conn string in (login) and both include/db conn files, to use DNS and login is fine, but cannot get any list data at all, just keep getting this error.
Help!!!!!

Admin 8/25/2005

Nathan,
could you send me an URL where I can see this error?

Also please describe your web server environment.

501150 8/25/2005

Hi Sergey
The URL is www.do-my-nails.co.uk/members/
Basically I have a MS Access database in the Private folder
Host is Windows and ODBC is setup in my control panel - in fact I already connect to it online through www....co.uk/login.asp
The database is called domynails.mdb , I couldnt connect directly to it from my PC thru ASPrunner PRo so I connected using the file option. The asp files couldnt connect with the generated script so I have manually change the connection string. as you'll see.
I can use Asprunner pro easily to replicate the databse to a DB folder and it all works fine, but I need to connect to the actual database, as it is constantly changing.
I basically need for browsers to register their details to the database,(which they do daily now) and be able to login and change them after we have supplied a password. But I only want them to see and edit their own data.
I feel I may be getting the relationship part slightly wrong between the two tables I am using, Users and Technicians?
I would buy you one LARGE beer if you can get this going for me!
Thanks
Nath

Admin 8/29/2005

Nathan,
I can not get access to your tables without login/password. Please send them to support@xlinesoft.com.