Visual Basic&database, HELP: Data Access Objects w/ ODBC connected to Oracle Database

HELP: Data Access Objects w/ ODBC connected to Oracle Database

Author	Message
Matthew Appl #1 / 4	HELP: Data Access Objects w/ ODBC connected to Oracle Database I am writing an application in VB4-ProEdition-16bit that will access and Oracle DBMS (running on a Sun) using ODBC and the VB Data Access Objects. I am new to programming with DAO's and have come across a problem that I cannot find a solution to. Speed is a major consideration in this project. Using SQL Passthrough, I can connect to the ODBC data source and retrieve a reasonable amount of records (read only) with no problems. I am using a snapshot dynaset to this. On our LAN (relatively traffic free), it takes about 12 seconds to initially connect, and about .5-1 seconds to perform the SQL query to retrieve records. However, since the recordset returned is read only, I am unable to add/update records in the table. It appears, that to do this I must do one of two things. 1) Not use SQL PassThrough. This causes the Jet engine to do the Queries on the database. I end up with an access time of 17-20 seconds!!! 2) Use the QueryDef Object. I would love to use this method, but I can't seem to get it to work. It always returns an error code saying Feature Not Available. Any help/suggestions on this would be appreciated. Thank you very much, Matthew Appler
Mon, 31 Aug 1998 03:00:00 GMT

Joel Corne #2 / 4	HELP: Data Access Objects w/ ODBC connected to Oracle Database Quote: >I am writing an application in VB4-ProEdition-16bit that will access and >Oracle DBMS (running on a Sun) using ODBC and the VB Data Access Objects. I >am new to programming with DAO's and have come across a problem that I cannot >find a solution to. >Speed is a major consideration in this project. Using SQL Passthrough, I can >connect to the ODBC data source and retrieve a reasonable amount of records >(read only) with no problems. >I am using a snapshot dynaset to this. On our LAN (relatively traffic free), >it takes about 12 seconds to initially connect, and about .5-1 seconds to >perform the SQL query to retrieve records. >However, since the recordset returned is read only, I am unable to add/update >records in the table. It appears, that to do this I must do one of two >things. >1) Not use SQL PassThrough. This causes the Jet engine to do the Queries on >the database. I end up with an access time of 17-20 seconds!!! >2) Use the QueryDef Object. I would love to use this method, but I can't seem >to get it to work. It always returns an error code saying Feature Not >Available. >Any help/suggestions on this would be appreciated. >Thank you very much, > Matthew Appler This problem goes away if you use RDO and VB4-32bit. I find it to be just as fast as pass-through queries (in most cases, anyway). Is this an option for you? Can't you use a dynaset instead of a snapshot for your DAO query? It would then be updatable. -- Joel Cornell
Tue, 01 Sep 1998 03:00:00 GMT

lw.. #3 / 4	HELP: Data Access Objects w/ ODBC connected to Oracle Database Quote: > I am writing an application in VB4-ProEdition-16bit that will access > am new to programming with DAO's and have come across a problem that I > cannot This problem goes away if you use RDO and VB4-32bit. I find it to be just as fast as pass-through queries (in most cases, anyway). Is this an option for you? Can't you use a dynaset instead of a snapshot for your DAO query? It would then be updatable. -- I have tried using a dynaset instead of a snapshot and I found it to be wickedly slow (though it is updatable). Any other suggestions besides using RDO since I'm limited to a 16 bit platform? BTW: I'm hitting a Sybase back-end Long Wong
Tue, 08 Sep 1998 03:00:00 GMT

patrick tan t. #4 / 4	HELP: Data Access Objects w/ ODBC connected to Oracle Database Hello, Wong, I need some help in connecting my VB 4.0 Professional running on Win-NT to my Database Engine running Oracle 7.2. I've just received ODBC 32 bit drivers from Intersolv. After installing it and creating the datasource, I'm quite lost on how to connect to my database engine. Which custom control do I use? This is all new to me. I would really appreciate if you could help point me the way to doing so. Best Regards, Patrick Tan Quote: > > I am writing an application in VB4-ProEdition-16bit that will access > > am new to programming with DAO's and have come across a problem that I > > cannot > This problem goes away if you use RDO and VB4-32bit. I find it to be > just as fast as pass-through queries (in most cases, anyway). Is this > an option for you? > Can't you use a dynaset instead of a snapshot for your DAO query? It > would then be updatable. > -- > I have tried using a dynaset instead of a snapshot and I found it to be > wickedly slow (though it is updatable). Any other suggestions besides > using RDO since I'm limited to a 16 bit platform? > BTW: I'm hitting a Sybase back-end > Long Wong -- Patrick Tan Senior Systems Engineer Motorola KLM Malaysia -- My views and opinions are solely my own. --- "Efficiency is doing sthe job right. Effectiveness is doing the right job." - Peter Drucker.
Mon, 14 Sep 1998 03:00:00 GMT

Page 1 of 1

[ 4 post ]