|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
|
|||
|
|||
|
VB.NET and Interbase problems
Im doing a project in VB.NET using an INTERBASE database..
I'm able to show the info in the DB using the following code : Dim cN As New ADODB.Connection() Dim rS As New ADODB.Recordset() cN.ConnectionString = "provider=LCPI.IBProvider;data source=localhost:" & _ "C:\DINEM.gdb;ctype=" & _ "win1251;user id=SYSDBA;password=masterkey" cN.Open() rS.ActiveConnection = cN cN.BeginTrans() rS.Open("SELECT * FROM CUSTOMERS", cN, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic) rS.MoveFirst() My problem is when I try to update, delete or add - I get the following error message : Additional information: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. I have changed the locktype to pessimistic (and the other options) - still no go... Any help will be appreciated! BTW the provider I use (IBProvider) is freeware - the commercial one is $150... I looked in the help/readme but couldnt find anything that states the with the Free version you cannot update/add/delete... Maybe thats the problem??? |
|
#2
|
|||
|
|||
|
Sounds like a question for Interbase and the Interbase db driver folks.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > VB.NET and Interbase problems |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
![]() |
|