Xojo Conferences
XDCMay2019MiamiUSA

Re: [MBS] SQLDatabaseMBS Transaction Fails (MBS Xojo Plugin Mailinglist archive)

Back to the thread list
Previous thread: [MBS] Xojo in the MacHeist bundle
Next thread: [MBS] [ANN] 14.2pr2


[MBS] [ANN] 14.2pr1   -   Christian Schmitz
  Re: [MBS] SQLDatabaseMBS Transaction Fails   -   Fotis Georgiadis
    Re: [MBS] SQLDatabaseMBS Transaction Fails   -   Fotis Georgiadis
    Re: [MBS] SQLDatabaseMBS Transaction Fails   -   Christian Schmitz
    Re: [MBS] SQLDatabaseMBS Transaction Fails   -   Fotis Georgiadis
    Re: [MBS] SQLDatabaseMBS Transaction Fails   -   Christian Schmitz
    Re: [MBS] SQLDatabaseMBS Transaction Fails   -   Fotis Georgiadis
    Re: [MBS] SQLDatabaseMBS Transaction Fails   -   Christian Schmitz
    [MBS] SQLDatabaseMBS Transaction Fails   -   Fotis Georgiadis

Re: [MBS] SQLDatabaseMBS Transaction Fails
Date: 03.04.14 16:20 (Thu, 03 Apr 2014 18:20:02 +0300)
From: Fotis Georgiadis
Christian hi,

No joy. Did all that, but still get the same error

"25000 [Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1."

Any more ideas?

Thank you in advance,
Fotis

On 3 Απρ 2014, at 5:58 μ.μ., Fotis Georgiadis <fotis.georgiadis@me.com> wrote:

> Ok, Thanks,
>
> I will do so and let you know...
>
> Cheers,
> Fotis
>
> On 3 Απρ 2014, at 5:58 μ.μ., Christian Schmitz <<email address removed>> wrote:
>
>>
>> Am 03.04.2014 um 16:54 schrieb Fotis Georgiadis <fotis.georgiadis@me.com>:
>>
>>> If I add
>>> db.Scrollable = False
>>> which by the way does not autocomplete, I get an error that "This item does not exist"
>>
>> Sorry, get 14.2pr2 please.
>>
>> Sincerely
>> Christian
>>
>> --
>> Read our blog about news on our plugins:
>>
>> http://www.mbsplugins.de/
>>
>> _______________________________________________
>> Mbsplugins_monkeybreadsoftware.info mailing list
>> <email address removed>
>> https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
>
> _______________________________________________
> Mbsplugins_monkeybreadsoftware.info mailing list
> <email address removed>
> https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Re: [MBS] SQLDatabaseMBS Transaction Fails
Date: 03.04.14 15:58 (Thu, 03 Apr 2014 17:58:49 +0300)
From: Fotis Georgiadis
Ok, Thanks,

I will do so and let you know...

Cheers,
Fotis

On 3 Απρ 2014, at 5:58 μ.μ., Christian Schmitz <<email address removed>> wrote:

>
> Am 03.04.2014 um 16:54 schrieb Fotis Georgiadis <fotis.georgiadis@me.com>:
>
>> If I add
>> db.Scrollable = False
>> which by the way does not autocomplete, I get an error that "This item does not exist"
>
> Sorry, get 14.2pr2 please.
>
> Sincerely
> Christian
>
> --
> Read our blog about news on our plugins:
>
> http://www.mbsplugins.de/
>
> _______________________________________________
> Mbsplugins_monkeybreadsoftware.info mailing list
> <email address removed>
> https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Re: [MBS] SQLDatabaseMBS Transaction Fails
Date: 03.04.14 15:58 (Thu, 3 Apr 2014 16:58:03 +0200)
From: Christian Schmitz

Am 03.04.2014 um 16:54 schrieb Fotis Georgiadis <fotis.georgiadis@me.com>:

> If I add
> db.Scrollable = False
> which by the way does not autocomplete, I get an error that "This item does not exist"

Sorry, get 14.2pr2 please.

Sincerely
Christian

Re: [MBS] SQLDatabaseMBS Transaction Fails
Date: 03.04.14 15:54 (Thu, 03 Apr 2014 17:54:23 +0300)
From: Fotis Georgiadis
Yes Christian.

The Code is:

Dim db As New SQLDatabaseMBS
db.Option("OLEDBProvider") = "SQLNCLI10"
db.DatabaseName = "SQLServer:(local)@myDb"
db.UserName = "sa"
db.Password = "111111"

If I add
db.Scrollable = False
which by the way does not autocomplete, I get an error that "This item does not exist"

Any Ideas?

Warm regards,
Fotis

On 3 Απρ 2014, at 5:46 μ.μ., Christian Schmitz <<email address removed>> wrote:

>
> Am 03.04.2014 um 16:42 schrieb Fotis Georgiadis <fotis.georgiadis@me.com>:
>
>> Hi Christian,
>>
>> I don't seem to see a Scrollable property. Where is it?
>
> 14.1 plugins in use?
>
> There SQLDatabaseMBS should have such a property.
>
> Sincerely
> Christian
>
> --
> Read our blog about news on our plugins:
>
> http://www.mbsplugins.de/
>
> _______________________________________________
> Mbsplugins_monkeybreadsoftware.info mailing list
> <email address removed>
> https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Re: [MBS] SQLDatabaseMBS Transaction Fails
Date: 03.04.14 15:46 (Thu, 3 Apr 2014 16:46:32 +0200)
From: Christian Schmitz

Am 03.04.2014 um 16:42 schrieb Fotis Georgiadis <fotis.georgiadis@me.com>:

> Hi Christian,
>
> I don't seem to see a Scrollable property. Where is it?

14.1 plugins in use?

There SQLDatabaseMBS should have such a property.

Sincerely
Christian

Re: [MBS] SQLDatabaseMBS Transaction Fails
Date: 03.04.14 15:42 (Thu, 03 Apr 2014 17:42:14 +0300)
From: Fotis Georgiadis
Hi Christian,

I don't seem to see a Scrollable property. Where is it?

Thank you very much,
Fotis

On 3 Απρ 2014, at 5:36 μ.μ., Christian Schmitz <<email address removed>> wrote:

>
> Am 03.04.2014 um 10:34 schrieb Fotis Georgiadis <fotis.georgiadis@me.com>:
>
>> Hello everyone,
>>
>> I am using the SQLDatabaseMBS and I tried to make a transaction. When I issue the command:
>> db.SQLExecute("BEGIN TRANSACTION") (db is a SQLDatabaseMBS)
>> I get the error:
>> "Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1."
>
> Microsoft SQL Server?
>
> For that please use the new Scrollable property and set to false.
>
> Sincerely
> Christian
>
> --
> Read our blog about news on our plugins:
>
> http://www.mbsplugins.de/
>
> _______________________________________________
> Mbsplugins_monkeybreadsoftware.info mailing list
> <email address removed>
> https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Re: [MBS] SQLDatabaseMBS Transaction Fails
Date: 03.04.14 15:36 (Thu, 3 Apr 2014 16:36:24 +0200)
From: Christian Schmitz

Am 03.04.2014 um 10:34 schrieb Fotis Georgiadis <fotis.georgiadis@me.com>:

> Hello everyone,
>
> I am using the SQLDatabaseMBS and I tried to make a transaction. When I issue the command:
> db.SQLExecute("BEGIN TRANSACTION") (db is a SQLDatabaseMBS)
> I get the error:
> "Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1."

Microsoft SQL Server?

For that please use the new Scrollable property and set to false.

Sincerely
Christian

[MBS] SQLDatabaseMBS Transaction Fails
Date: 03.04.14 09:34 (Thu, 03 Apr 2014 11:34:53 +0300)
From: Fotis Georgiadis
Hello everyone,

I am using the SQLDatabaseMBS and I tried to make a transaction. When I issue the command:
db.SQLExecute("BEGIN TRANSACTION") (db is a SQLDatabaseMBS)
I get the error:
"Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1."

The same method works with PostgresqlDatabase and SQLiteDatabase (the Xojo plugins).

Any idea what I should do?

Thank you in advance,

Fotis Georgiadis
_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info