Welcome, Guest ( Customer Panel | Login )




 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-CART 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
0 Item(s)
$0.00