tonymeadors
User
Fresh Boarder
| Posts: 2 |   |
Karma: 0
|
|
Basic Questions
|
|
Posted: 2005/08/04 03:40 |
|
|
|
|
We have a couple programmer's evaluating anyDAC. Our products must operate similarly using several different DBs...you know the story.
After 2 days there are some basic questions.
Let me throw out the first 2.
1. Pooling. Is it possible to set the pooling parameter to TRUE in the external connection file and then have the connection behave as desired? When we do that and attempt to open the connection we get a designed exception, due to there being more that 0 params defined. Exception reads:
"Connection cannot be pooled. Either is not named or it has additional parameters". The additional param is added automatically it appears, defining the conneciondef string.
2. DB2 - The primary reason we are checking out anyDAC is all the problems with the DB2 dbexpress driver.
The following two editing methods work fine with all DBs except DB2.
We make an ADConnection to our DB2 8.1 database.
connection <- query <-dataset <- dbgrid
We execute "select * from xxxxxx" to show data in the dbgrid.
Now, if we:
have cachedupdates to true
change a value in the dbgrid
post the change
call applyupdates
close the connection
Upon inspection, the changes were not made to the DB2 data,
Alternately, if we,
leave cachedupdates false
set requestlive to true
post the change
On the post we get that annoying error:
"Record has be changed/delete by another user" - updated [0] records"
Again, both these methods work with Oracle and SQL Server. BTW the table contains only simple datatypes varchars, integers and numerics.
Thanks in advance,
I hope I can be a part of this forum.
tonyM
|
|
