VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Quite a few errors
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

parapa
Starting Member

United Kingdom
6 Posts

Posted - March 15 2012 :  10:46:24  Show Profile  Reply with Quote
Hi,

I'm using V6.5. This site works fine on our dedicated server, but now we're moving it to shared hosting and are getting no end of errors.
Firstly, when I browse to default.asp, I get:

ADODB.Connection error '800a0e78'

Operation is not allowed when the object is closed.

shop$db.asp, line 1423

My settings in shop$config.asp as follows:

<%
Response.CacheControl = "no-cache"
' VP-ASP Shopping Cart Database Configuration 6.50.1
const xDatabase="***"  'Database name
const xdblocation="localhost"    'location of database relative to VP-ASP files

'NOTE - XDATABASETYPE SHOULD BE ENTERED IN UPPER CASE LETTERS
const xdatabasetype="MYSQL"         ' Database type: leave empty for Access or change to one of the options shown below
'const xdatabasetype="ODBC"    
'const xdatabasetype="DRIVE" 
'const xdatabasetype="SQLSERVER"
'const xdatabasetype="MYSQL"
'const xdatabasetype="MYSQL351"
'const xdatabasetype="ACCESS2007"


const xSQLUser="***"              ' SQL Server user
const xSQLPwd="*****"               ' SQL Server password
const xSQLServer="localhost"            ' SQL Server name or IP address


Now, when I run diag_dbtest.asp, regardless of whether I enter any credentials, or use the shop$config ones, I receive:

Database Read	FAIL
Please ensure the database is at the physical location shown below.
Open Messages
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 
 	 
Database Write	FAIL
Open Messages
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
even though the MySQL details are valid and working.

Any ideas? Thanks :)

support
Administrator

4266 Posts

Posted - March 15 2012 :  20:34:26  Show Profile  Visit support's Homepage  Reply with Quote
Hi there,

You need to make sure that you are using the correct MySQL driver.

Do you know what version your host is using?

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp

************************************
Did you know VPASP now offers premium Cloud based e-commerce web hosting?

Ask me for more details on how we can help you with a complete solution to your
online needs.
************************************

Go to Top of Page

parapa
Starting Member

United Kingdom
6 Posts

Posted - March 16 2012 :  06:48:33  Show Profile  Reply with Quote
Hi,

They are saying their MySQL driver is version 5.1. Can you confirm if this is OK? Thanks :)
Go to Top of Page

g3nnin
VP-ASP Super User

209 Posts

Posted - March 16 2012 :  15:44:04  Show Profile  Reply with Quote
Hi,

The "xdatabasetype" setting should already correct. I would suggest to look into this code in shop$db.asp:
- line 463, in ProcessMYSqlServer routine

mysqlconn=mysqlconn & " Server=" & varServerIP & "; Database=" & varDataBaseName & "; UID=" & varUserName & "; PWD=" & varPassword

You might need modify the above code so it would match the connection string that provided by your hosting.


Hope this helps!
Go to Top of Page

elammers
VP-ASP Super User

USA
256 Posts

Posted - March 16 2012 :  16:30:48  Show Profile  Visit elammers's Homepage  Reply with Quote
On the shared server, are you sure xSQLServer="localhost" is correct? In a shared hosting environment, the db server probably isn't on the web server at all.


Regards,
Eric Lammers
www.KrackMedia.com
Building More Than Web Sites . . . Building a Web Presence

Edited by - elammers on March 16 2012 16:31:31
Go to Top of Page

support
Administrator

4266 Posts

Posted - March 16 2012 :  19:03:07  Show Profile  Visit support's Homepage  Reply with Quote
Hi there,
We have created a helpnote for you on how to upgrade your site to use the latest drivers.

http://helpnotes.vpasp.com/kb/604-Tips-and-Tricks/1092-Using-MySQL-510-Driver-with-VP-ASP-v650/

If you have any issues pelase feel free to post a ticket i nthe helpdesk at:

https://helpdesk.vpasp.com

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp

************************************
Did you know VPASP now offers premium Cloud based e-commerce web hosting?

Ask me for more details on how we can help you with a complete solution to your
online needs.
************************************
Go to Top of Page

parapa
Starting Member

United Kingdom
6 Posts

Posted - March 19 2012 :  06:37:03  Show Profile  Reply with Quote
Hi,

Thanks for all the replies.

quote:
On the shared server, are you sure xSQLServer="localhost" is correct? In a shared hosting environment, the db server probably isn't on the web server at all.


Yeah it's definately localhost. PHP scripts etc from the box work fine.

quote:
We have created a helpnote for you on how to upgrade your site to use the latest drivers.


I have run through this and am now receiving:

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.


Seems we are getting closer. Any more ideas? :)
Thanks
Go to Top of Page

support
Administrator

4266 Posts

Posted - March 19 2012 :  07:51:27  Show Profile  Visit support's Homepage  Reply with Quote
There are a lot of returns when you Google the error, each though referring to different things.

I have not seen this so it may either mean some time spent trawling through other peoples posts using Google or if you want to see if the support desk can assist try posting in:

https://helpdesk.vpasp.com

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp

************************************
Did you know VPASP now offers premium Cloud based e-commerce web hosting?

Ask me for more details on how we can help you with a complete solution to your
online needs.
************************************
Go to Top of Page

parapa
Starting Member

United Kingdom
6 Posts

Posted - March 19 2012 :  08:06:56  Show Profile  Reply with Quote
Hi,

Thanks for the quick reply. This error does seem specific to some changes we made just now though, as I have a VPS running Win2k8 which has a similar set up to the shared hosting, which exhibits the same problem. If I upload a direct copy of the site on the old host (Win 2k3) it works fine, so still seems something software specific.
Go to Top of Page

support
Administrator

4266 Posts

Posted - March 19 2012 :  08:10:04  Show Profile  Visit support's Homepage  Reply with Quote
If there is custom coding in the site it will make it a bit more challenging to track down for you.

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp

************************************
Did you know VPASP now offers premium Cloud based e-commerce web hosting?

Ask me for more details on how we can help you with a complete solution to your
online needs.
************************************
Go to Top of Page

parapa
Starting Member

United Kingdom
6 Posts

Posted - March 19 2012 :  08:16:08  Show Profile  Reply with Quote
Hi again Cam,

I don't believe there is any custom coding as the errors I am showing are being displayed when viewing the diag_dbtest.asp file.
The error:
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

is shown when I click "Use shop$config settings".
Go to Top of Page

parapa
Starting Member

United Kingdom
6 Posts

Posted - March 20 2012 :  10:55:25  Show Profile  Reply with Quote
Hi,

I've gone through lots of posts on Google, but none of the suggestions seem to work. I am still receiving the problem mentioned on 2 separate Win2k8 Servers.

Do you have any more suggestions here?

Thanks :)
Go to Top of Page

support
Administrator

4266 Posts

Posted - March 21 2012 :  22:47:16  Show Profile  Visit support's Homepage  Reply with Quote
Best bet would be to post this in the helpdesk so our support team can review for you to see if they can debug the problem for you.

Thank you.

Cam Flanigan
VP-ASP Cart Support

Follow us on Twitter:
http://www.twitter.com/vpasp

************************************
Did you know VPASP now offers premium Cloud based e-commerce web hosting?

Ask me for more details on how we can help you with a complete solution to your
online needs.
************************************
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000