etoshop Creator
 Program FAQ
B2BReverse Auction

 

Install pws and IIS

Webserver is required to execute the asp program.

Please install PWS for windows 98 system and install IIS for windows NT system.

PWS is available in windows98 second Edition [Add-on] folder.

after installed PWS, place ASP scripts in the webserver root directory(default "C:\Inetpub\WWWroot")

and type in "Http://Localhost/b2breverseauction/reverse/default.asp" to run asp

How to specify database path?
Example:

If your PWS or IIS webserver root directory is "C:\Inetpub\WWWRoot" and your database file located at "C:\Inetpub\WWWRoot\b2breverseauction\b2breverseauction.mdb"


************************************************************************************************
fpath="DBQ="&Server.MapPath("/b2breverseauction/b2breverseauction.mdb")
************************************************************************************************

*Note
Server.mappath will bring your program to your server Root directory.

 

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x418 Thread 0x798 DBC 0xedb0fcc Jet'.
Solution:

The database path specified in Opendatabase.asp is incorrect.  Program cannot find the database file.

************************************************************************************************
fpath="DBQ="&Server.MapPath("/b2bReverseAuction/b2bReverseAuction.mdb")
************************************************************************************************

Check the database path in Opendatabase.asp and database file location.  Make sure the database path is correctly specified.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.
Solution:

The database path specified in Opendatabase.asp is incorrect.  Program cannot find the database file.

************************************************************************************************
fpath="DBQ="&Server.MapPath("/b2bReverseAuction/b2bReverseAuction.mdb")
************************************************************************************************

Check the database path in Opendatabase.asp and database file location.  Make sure the database path is correctly specified.

"Run time error '3706'  
ADO could not find the specified provider."
Solution:

ODBC Driver corrupted or MDAC version incorrect.

Download and install later MDAC  Version to solve this problem.

Download MDAC:
http://www.microsoft.com/data/whatcom.htm

http://www.microsoft.com/data/download.htm

Unspecified Error
Solution:
  1. Open opendatabase.asp with Text Editor e.g. Notepad
  2. Change the database path:
    ********************************************************************************************
    fpath="DBQ="&Server.MapPath("/b2bReverseAuction/b2bReverseAuction.mdb")
    ********************************************************************************************
    To:
    ********************************************************************************************
    fpath="DB="&Server.MapPath("/b2bReverseAuction/b2bReverseAuction.mdb")
    ********************************************************************************************
  3. run the asp program and browser display a different error message.
  4. change the database path in opendatabase.asp to original database path:
  5. Change the database path:
    ********************************************************************************************
    fpath="DB="&Server.MapPath("/b2bReverseAuction/b2bReverseAuction.mdb")
    ********************************************************************************************
    To:
    ********************************************************************************************
    fpath="DBQ="&Server.MapPath("/b2bReverseAuction/b2bReverseAuction.mdb")
    ********************************************************************************************
  6. Run the asp program again and the unspecified error shall be solved.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers(0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Invalid SQL
Statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', OR 'UPDATE'.
Solution :
Download b2breverseauction.zip http://www.etoshop.com/support/b2breverseauction.zip, extract the b2breverseauction.mdb file and replace current database.
Error In Row
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]Error in row



/B2BReverseAuction/auction/asp/proread.asp, line 187

Solution:

please go to http://www.etoshop.com/support/b2breverseauction.zip downlaod the file and unzip it to replace the existing database file.
 
Problem:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

/B2breverseAuction/auction/asp/registration.asp, line 168

Solution:

you need set the folder of B2breverseAuction permission is enable to everyone write and readable, if not, our asp script will cannot update the data to database.

and also make sure all the files is no readonly.

 

Contact Sales, Support or Send Question To
etoShop Contact Email