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
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Suggestions for future release
 VP-ASP for Oracle
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

34 Posts

Posted - February 05 2004 :  17:36:26  Show Profile  Reply with Quote

VP-ASP's current database support is great :

* MS-Access
* SQL Server

But the one missing link is Oracle.

It would be great to see a version of VP-ASP for Oracle.

Then you'd have all the bases covered, in terms of databases.

VP-ASP New User

194 Posts

Posted - February 06 2004 :  09:29:56  Show Profile  Visit siraj's Homepage  Reply with Quote
That would be cool.. VP-ASP for Oracle. I have integrated VP-ASP in Prgress Database. But its a pain becucase the drivers for the progress database is pain in the wrong place and sometime its very slow. I am thinking about to migrate to or get a copy into SQL and go with.
But, VP-ASP for Oracle would be cool idea and its not hard to implement either.

[email protected]
Go to Top of Page

Starting Member

39 Posts

Posted - March 05 2004 :  07:01:18  Show Profile  Visit jsbeads's Homepage  Reply with Quote
Okay of course you would need the Oracle SQLNET Client on the host machine, the TNS names configured and you must KNOW the version of the ODBC driver loaded on the host machine

But simply change the ProcessSqlServer connection string in shop$db.asp

Sub ProcessSqlServer(connection)

/* For the current Oracle ODBC Driver from Microsoft */
oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
"Server=OracleServer.world;" & _
"Uid=myUsername;" & _

/* ODBC Driver for Oracle - from Oracle */
oConn.Open "Driver={Oracle ODBC Driver};" & _
"Dbq=myDBName;" & _
"Uid=myUsername;" & _

Then select SQL as you database type in the shop$config.asp depending on the hosting company you may want to use a DSN Name.

For more info, see this site http://www.able-consulting.com/ADO_Conn.htm

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000