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
 VP-ASP 6.00 Questions
 SQL 2005 database issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

large
Starting Member

8 Posts

Posted - March 02 2007 :  16:21:32  Show Profile  Reply with Quote
***Server 2003 64bit and SQL 2005 database issue***

I've previously install vpasp6 on a Win2k3 and SQL 2k with great success.
However, I'm trying to set up VPASP from scratch on a clean server (fresh install of everythinglimited configuration) and receive the following error when configuring the site with SQL...

ADODB.Connection error '800a0ea9'
Provider is not specified and there is no designated default provider.
/shop$db.asp, line 345

Itís as if the DB is not being communicated with.
Any help would be appreciated...
Thanks,
Dan

Kidd
VP-ASP Super User

Australia
373 Posts

Posted - March 09 2007 :  01:42:46  Show Profile  Reply with Quote
i think sql2005 uses different connection string, you can try google
Go to Top of Page

large
Starting Member

8 Posts

Posted - March 09 2007 :  06:26:58  Show Profile  Reply with Quote
Thanks Kid,

I've searched high and low...

In doing some research, I've found that this may be a compatibility issue with products (OSx64, SQL2k5 x32, mdac/odbc/etc...) used. However, nothing concrete. I'm not convinced this is a VPASP issue, but thought maybe someone had come across this issue before.

I am not a DB guru and am looking for directions. I've spent considerable time researching and exercising all ideas, but still come back to the same error Ė it seems to be the connection string to the db Ė either the version of SQL doesnít like what VPASP is sending or the OS canít interpret correctly.

Any help would be appreciated.
Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000