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
 Suggestions for future release
 VP-ASP for Oracle
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

advancedasia
Starting Member

34 Posts

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

VP-ASP's current database support is great :

* MS-Access
* SQL Server
* MYSQL

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.

siraj
VP-ASP New User

USA
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.
GOOD LUCK.
SJ.

[email protected]
Go to Top of Page

jsbeads
Starting Member

USA
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;" & _
"Pwd=myPassword"

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

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