Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


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-CART 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
0 Item(s)
$0.00
  • Your Cart Is Empty