Author |
Topic |
|
parapa
Starting Member
United Kingdom
6 Posts |
Posted - March 15 2012 : 10:46:24
|
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
4679 Posts |
Posted - March 15 2012 : 20:34:26
|
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. ************************************
|
|
|
parapa
Starting Member
United Kingdom
6 Posts |
Posted - March 16 2012 : 06:48:33
|
Hi,
They are saying their MySQL driver is version 5.1. Can you confirm if this is OK? Thanks :) |
|
|
g3nnin
VP-CART Super User
209 Posts |
Posted - March 16 2012 : 15:44:04
|
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! |
|
|
elammers
VP-CART Super User
USA
256 Posts |
Posted - March 16 2012 : 16:30:48
|
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 |
|
|
support
Administrator
4679 Posts |
|
parapa
Starting Member
United Kingdom
6 Posts |
Posted - March 19 2012 : 06:37:03
|
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 |
|
|
support
Administrator
4679 Posts |
Posted - March 19 2012 : 07:51:27
|
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. ************************************ |
|
|
parapa
Starting Member
United Kingdom
6 Posts |
Posted - March 19 2012 : 08:06:56
|
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. |
|
|
support
Administrator
4679 Posts |
Posted - March 19 2012 : 08:10:04
|
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. ************************************ |
|
|
parapa
Starting Member
United Kingdom
6 Posts |
Posted - March 19 2012 : 08:16:08
|
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". |
|
|
parapa
Starting Member
United Kingdom
6 Posts |
Posted - March 20 2012 : 10:55:25
|
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 :) |
|
|
support
Administrator
4679 Posts |
Posted - March 21 2012 : 22:47:16
|
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. ************************************ |
|
|
|
Topic |
|