| Author |
asa 9 oledb provider and Delphi
|
|
| Manuel Rodriguez 2005-07-26, 9:23 am |
| Can anyone give an example of how to configure the
AdoConnection and Adoquery so the work the Asa Oledb provider using delphi?
I have tried all the options that I know and I cannot do
a simple data entry program with two fields and a dbgrid
| |
| Chris Keating \(iAnywhere Solutions\) 2005-07-26, 9:23 am |
| You should simply need to set the provider to ASAProv.9.
"Manuel Rodriguez" < ManuelRodriguez24@ya
hoo.com> wrote in message
news:42e63e52@forums
-1-dub...
> Can anyone give an example of how to configure the
> AdoConnection and Adoquery so the work the Asa Oledb provider using
> delphi?
>
> I have tried all the options that I know and I cannot do
> a simple data entry program with two fields and a dbgrid
>
>
>
| |
| Manuel Rodriguez 2005-07-26, 11:23 am |
| I have already done so
"Manuel Rodriguez" < ManuelRodriguez24@ya
hoo.com> wrote in message
news:42e63e52@forums
-1-dub...
> Can anyone give an example of how to configure the
> AdoConnection and Adoquery so the work the Asa Oledb provider using
delphi?
>
> I have tried all the options that I know and I cannot do
> a simple data entry program with two fields and a dbgrid
>
>
>
| |
| Chris Keating \(iAnywhere Solutions\) 2005-07-26, 1:23 pm |
| What errors or other issues do you encounter?
"Manuel Rodriguez" < ManuelRodriguez24@ya
hoo.com> wrote in message
news:42e66a6d@forums
-2-dub...
>I have already done so
> "Manuel Rodriguez" < ManuelRodriguez24@ya
hoo.com> wrote in message
> news:42e63e52@forums
-1-dub...
> delphi?
>
>
| |
| Ian McHardy 2005-07-26, 1:23 pm |
| I have this working with a TADOTable object with the ConnectionString
property set to:
Provider=ASAProv.90;Data Source=delphi_test
--
Ian McHardy (iAnywhere Solutions)
Please reply only to the newsgroup.
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"Chris Keating (iAnywhere Solutions)" < Spam_NoThanks_keatin
g@iAnywhere.com>
wrote in message news:42e66fa7$1@foru
ms-1-dub...
> What errors or other issues do you encounter?
>
> "Manuel Rodriguez" < ManuelRodriguez24@ya
hoo.com> wrote in message
> news:42e66a6d@forums
-2-dub...
>
>
| |
| Manuel Rodriguez 2005-07-26, 8:23 pm |
| I'm using delphi7 and ASA 9.0.2.3044
The AdoConnection is configured as follows
-----------------------------------------
1)ConnectionString = Provider=ASAProv.90;Data Source=Sample
2)ConnectOptios = coConnectUnspecified
3)CursorLocation = clUseServer
4)IsolationLevel = ilCursorStability
5)mode = cmReadWrite
6)Provider = ASAProv.90
The AdoQuery is configured as follows
------------------------------------------
1)ConnectOptios = coConnectUnspecified
2)CursorLocation = clUseServer
3)CursorType = ctKeyset
4)LockType = ltPessimistic
I have a sample table with 3 fields
I want to edit the table and use a dbgrid to view the records
With the above configuracion, Can edit a record, but when I save the
changes, the application freezes
If I change the AdoQuery options:
CursorLocation = clClient
CursorType = ctStatic
Locktype = ltBatchOptimistic
I can edit and insert records saving them, but When I try to
apply the updates using "adoquery1.UpdateBatch();"
the application freezes
I have played with different options on the AdoConnection and AdoQuery,
but none of them work as expected.
Can you send me a working sample?
ManuelRodriguez24@ya
hoo.com
"Ian McHardy" < mchardy_no@spam_iany
where.com> wrote in message
news:42e681c4$1@foru
ms-2-dub...
> I have this working with a TADOTable object with the ConnectionString
> property set to:
> Provider=ASAProv.90;Data Source=delphi_test
>
> --
>
> Ian McHardy (iAnywhere Solutions)
>
> Please reply only to the newsgroup.
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
> "Chris Keating (iAnywhere Solutions)"
< Spam_NoThanks_keatin
g@iAnywhere.com>
> wrote in message news:42e66fa7$1@foru
ms-1-dub...
>
>
| |
| Chris Keating \(iAnywhere Solutions\) 2005-07-27, 9:23 am |
| Are you blocked? I don't have ready access to Delphi but tried this in C++
Builder using TADOConnection, TADOQuery, and TDBGrid and did not experience
any hangs.
"Manuel Rodriguez" < ManuelRodriguez24@ya
hoo.com> wrote in message
news:42e6adb2@forums
-2-dub...
> I'm using delphi7 and ASA 9.0.2.3044
>
> The AdoConnection is configured as follows
> -----------------------------------------
> 1)ConnectionString = Provider=ASAProv.90;Data Source=Sample
> 2)ConnectOptios = coConnectUnspecified
> 3)CursorLocation = clUseServer
> 4)IsolationLevel = ilCursorStability
> 5)mode = cmReadWrite
> 6)Provider = ASAProv.90
>
> The AdoQuery is configured as follows
> ------------------------------------------
>
> 1)ConnectOptios = coConnectUnspecified
> 2)CursorLocation = clUseServer
> 3)CursorType = ctKeyset
> 4)LockType = ltPessimistic
>
>
> I have a sample table with 3 fields
> I want to edit the table and use a dbgrid to view the records
>
> With the above configuracion, Can edit a record, but when I save the
> changes, the application freezes
>
>
> If I change the AdoQuery options:
>
> CursorLocation = clClient
> CursorType = ctStatic
> Locktype = ltBatchOptimistic
>
> I can edit and insert records saving them, but When I try to
> apply the updates using "adoquery1.UpdateBatch();"
> the application freezes
>
> I have played with different options on the AdoConnection and AdoQuery,
> but none of them work as expected.
>
> Can you send me a working sample?
> ManuelRodriguez24@ya
hoo.com
>
> "Ian McHardy" < mchardy_no@spam_iany
where.com> wrote in message
> news:42e681c4$1@foru
ms-2-dub...
> < Spam_NoThanks_keatin
g@iAnywhere.com>
>
>
| |
| Chris Keating \(iAnywhere Solutions\) 2005-07-27, 9:23 am |
| To check for blocking, look at the output of sa_conn_info and checked the
BlockedOn column.
"Chris Keating (iAnywhere Solutions)" < Spam_NoThanks_keatin
g@iAnywhere.com>
wrote in message news:42e7986d@forums
-1-dub...
> Are you blocked? I don't have ready access to Delphi but tried this in C++
> Builder using TADOConnection, TADOQuery, and TDBGrid and did not
> experience any hangs.
>
>
> "Manuel Rodriguez" < ManuelRodriguez24@ya
hoo.com> wrote in message
> news:42e6adb2@forums
-2-dub...
>
>
| |
| Manuel Rodriguez 2005-07-29, 3:23 am |
| ----------------------------------------------------------------------------
------------------------------
Thanks for your samples. They all worked ok on the asademo.db,
but with my database they did not work. I was testing your demos on an
asademo.db version 7
My database is version 6.2. I think that's the problem. So I upgraded my
database to version 7,
but it did not help. So I tested on another database that was originally
created with asa version 7 and
they work ok. So I concluded that the database has to be originally create
with asa version 7 and up.
----------------------------------------------------------------------------
-----------------------------
"Ian McHardy" < mchardy_no@spam_iany
where.com> wrote in message
news:42e7a493@forums
-1-dub...
> I checked my code again and I was using DBText and DBNavigator, not
DBGrid.
> I did create some samples with Delphi7 using ADO and DBGrid, and they were
> able to update, but sometimes got a bookmark error when scrolling.
>
> I've seen problems before when using the Delphi ADO object with ASA's
oledb
> driver, so you may find that the DBExpress or NativeDB interfaces are more
> reliable.
>
> DBExpress is free and instructions on how to download it and set it up for
> ASA are here:
> http://www.ianywhere.com/developer/...es
s.html
> Info on how it is different from the BDE and ADO interfaces (you need a
> DataSetProvider and ClientDataSet object, and a call to
> ClientDataSet.ApplyUpdates) can be found here:
>
http://bdn.borland.com/article/imag.../>
ations_to_db
express.pdf
>
> I've attached working Delphi 7 samples for ADO and DBExpress. The samples
> need the asademo database to be running, and this line to create the DSN:
> dbdsn -w delphi_test -c " uid=dba;pwd=sql;dbn=
asademo"
>
> --
>
> Ian McHardy (iAnywhere Solutions)
>
> Please reply only to the newsgroup.
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
> "Manuel Rodriguez" < ManuelRodriguez24@ya
hoo.com> wrote in message
> news:42e6adb2@forums
-2-dub...
iAnywhere[color=dark
red]
>
>
>
| |
| Chris Keating \(iAnywhere Solutions\) 2005-07-29, 7:23 am |
| Support for ADO connections was introduced in ASA7 and later and as a result
ASA6 databases do not have all of the necessary 'schema' to address
connectivity via oledb. You could opt to use the OLEDB-ODBC bridge driver.
"Manuel Rodriguez" < ManuelRodriguez24@ya
hoo.com> wrote in message
news:42e99a06@forums
-1-dub...
> ----------------------------------------------------------------------------
> ------------------------------
> Thanks for your samples. They all worked ok on the asademo.db,
> but with my database they did not work. I was testing your demos on an
> asademo.db version 7
> My database is version 6.2. I think that's the problem. So I upgraded my
> database to version 7,
> but it did not help. So I tested on another database that was originally
> created with asa version 7 and
> they work ok. So I concluded that the database has to be originally
> create
> with asa version 7 and up.
> ----------------------------------------------------------------------------
> -----------------------------
> "Ian McHardy" < mchardy_no@spam_iany
where.com> wrote in message
> news:42e7a493@forums
-1-dub...
> DBGrid.
> oledb
> http://bdn.borland.com/article/imag.../>
ations_to_db
> express.pdf
> iAnywhere
>
>
|
|
|
|