Tag: Access

Stock import

Comersus Version: 705Database type: AccessFrequency: Permanent issue Hi! I am really curious how to import the stock level for the products? Everything else is just perfect, but, I don't want to type in stock for over 500 product manually. I am testing the store in Access, but, I need to have a final version in

Access works with Godaddy.com hosting

Comersus Version: 707Database type: AccessFrequency: Permanent issue Has anyone had luck using the cart with Godaddy.com hosting? I'm trying to get it set up, but the cart isn't recognizing the DSN and the example i find on godaddy uses a username and password to connect. Right now I'm getting – Microsoft OLE DB Provider for

Update Inventory from DBF file

Comersus Version: 705Database type: SQL ServerFrequency: Permanent issue Hi, I have a question on, how I can make the inventory to be update by a DBF file that will contain the inventory amount and it will be change on a weekly or montly basics. Also, which database is better for this Access or SQL? Thanks

Keyword Search

Comersus Version: 700Database type: AccessFrequency: Permanent issue Is there a way to set up the search feature to search the keywords I put into the keyword field in the product description? I noticed other posts with similar questions, but they are using SQL database – I am using Access.

error – updateable query

Comersus Version: 607Database type: AccessFrequency: Permanent issue The store looks and works great except when trying to view an item or view cart, I get the following error…I'm using Access so am a little confused about the error…Thanks in advance for your help. Sorry for the inconvenience. Error in sessionFunctions, error: [Microsoft][ODBC Microsoft Access Driver]

old records in cartRows table

Comersus Version: 705Database type: AccessFrequency: Permanent issue Using the Access database version, I've noticed that as the cart is used the "cartRows" table fills up for each new user that adds items to their cart. However, not every order is completed and some are abandoned due to session timeout. These cartRows records have unique idDbSessionCart

Access > MySQL

Comersus Version: 605Database type: AccessFrequency: Permanent issue Hi There, We're running our store using Comersus 6.0X with Access as the back end. We want to upgrade the database as it's starting to run on the slow side (>80MB). My question is this: is it feasible to migrate our entire access database onto a better performing

Maximum number of products using Access

Comersus Version: 705Database type: AccessFrequency: Permanent issue I can't find any definitive discussion about when you need to consider upgrading from Access to a professional db such as mySQL. I'm sure the mix of the number of customers, products, and transactions all play a part. I have a store using Access with 4,000 products but

PayPal Website Payments Pro Error

Comersus Version: 702Database type: OtherFrequency: Permanent issue This is the steps I've done, I refered to page 80 in your userguide and did all the steps except my host is handling the installation of the the api certificate (steps 4 and 5). When i go to place an order I get all the way to

Installation – falling at the first fence

Comersus Version: 705Database type: AccessFrequency: Permanent issue Hi, I'm using Windows 98, Access 2000 and Frontpage 2000. I've saved all the files to C drive in a folder named Comersus. I've created a new web in Frontpage and copied the files to the private folder (not sure if that's right but woth a try!) Now

error when adding items to cart

Comersus Version: 607Database type: OtherFrequency: Permanent issue Hi, I just completed moving my database from Access to MySQL. On the surface everything seems to be working fine until I try to add an item to the shopping cart and I receive this error. Sorry for the inconvenience. Error in itemFunctions, error: [MySQL][ODBC 3.51 Driver][mysqld-4.1.20-community-nt]Cannot add

MySQL Migration

Comersus Version: 607Database type: OtherFrequency: Random issue I recently moved my Comersus 6.07 to a new hosting company and also migrated from Access to MySQL. I converted the Access db in MSAccess and ran the SQL script to populate the MySQL db. Changed the settings.asp file to DSN connection. Set the MyODBC connection to point

Installation

Comersus Version: 702Database type: AccessFrequency: Permanent issue I've been troubleshooting my way through some installation problems for comersus (I still have yet to fully install the software). Currently, while running the initial default.asp file in the comersus folder, it exhibits the following behavior: 1) Forwards to the store/default.asp page 2) Forwards to the store/comersus_index.asp page

Temp Errors

Comersus Version: 705Database type: SQL ServerFrequency: Permanent issue I just set up my SQL Server from Access and now I am constantly getting these temp errors – See below. They all are in regards to teh screenmessages table – I checked the table and it appears to be fine. – HELP – this would drive

maintaining products

Comersus Version: 600Database type: AccessFrequency: Permanent issue Hello: we have over 2000 products entered into our PRODUCTS table. The prices change as do descriptions. Often times products are no longer available and must be removed. I would like to maintain our products outside of the application using Access queries that match on the SKU. I

error message

Comersus Version: 702Database type: AccessFrequency: Permanent issue I put up the shopping cart under a friends domain, and it works perfectly, but when I put it under my company's domain I get an error message when "adding to cart" (see below). Both domains are with godaddy.com and I have the database (Access) configured correctly on

PayPal Checkout Express

Comersus Version: 700Database type: AccessFrequency: Permanent issue Whe I tried to check out using PayPal Checkout Express I got this error. Error Type: msxml4.dll (0x80070005) Access is denied. /store/comersus_gatewayPayPalExpress3.asp, line 112 Thanks Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) Page: GET /store/comersus_gatewayPayPalExpress3.asp

Table 'test.settings' doesn't exist

Comersus Version: 603Database type: OtherFrequency: Permanent issue I switched our database from Access to mySQL. I have made the necessary changes to settings.asp and I have created a System DSN connection. When I access the store, I get the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [MySQL][ODBC 3.51 Driver][mysqld-5.0.22-community-nt]Table 'test.settings' doesn't

Converting Access to MySql

Comersus Version: 607Database type: AccessFrequency: Permanent issue We purchased Power Pack Premium and an Access database was included with it. If I convert the Access database to MySQL, what issues might I run into? I can search and replace each file to change it to the MySQL extension, but what else might I need to

Access shop with login and password

Comersus Version: 605Database type: AccessFrequency: Random issue I am using Comersus like a catalog and I would like use another session of Comersus to do a webshop, only used by clients. Please can you tell me how to open the webshot when a member enters his login and password ?