Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

[MBS] ODBC Function Sequence Error (MBS Xojo Plugin Mailinglist archive)

Back to the thread list
Previous thread: [MBS] asBLob.CopyBinaryData returns black square in web edition
Next thread: [MBS] Dyan PDF Question


Re: [MBS] IconImageMBS slow 10.9   -   Garth Hjelte
  [MBS] ODBC Function Sequence Error   -   Anthony Dellos
   Re: [MBS] ODBC Function Sequence Error   -   Anthony Dellos
   Re: [MBS] ODBC Function Sequence Error   -   Christian Schmitz
   Re: [MBS] ODBC Function Sequence Error   -   Christian Schmitz
   Re: [MBS] ODBC Function Sequence Error   -   Anthony Dellos

[MBS] ODBC Function Sequence Error
Date: 06.01.15 16:24 (Tue, 6 Jan 2015 07:24:29 -0800)
From: Anthony Dellos
On attempting to connect to a FileMaker Server (13.0.5) with the latest MBS
Xojo SQL Plugin.xojo_plugin version 14.4 (18444) the following error occurs:

S1010 [iODBC][Driver Manager]Function sequence error

This does not occur with MBS Xojo SQL Plugin.xojo_plugin version 14.0
(18163).

This is in Xojo 2014r3.1.
_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Re: [MBS] ODBC Function Sequence Error
Date: 07.01.15 22:58 (Wed, 7 Jan 2015 13:58:12 -0800)
From: Anthony Dellos
Thank you! Will give it a try.

On Tue, Jan 6, 2015 at 2:06 PM, Christian Schmitz <
<email address removed>> wrote:

>
> > On attempting to connect to a FileMaker Server (13.0.5) with the latest
> MBS
> > Xojo SQL Plugin.xojo_plugin version 14.4 (18444) the following error
> occurs:
> >
> > S1010 [iODBC][Driver Manager]Function sequence error
>
> I could reproduce it. After a select, the command object is not a result
> set, so you can't query next record.
>
> Ah, it's scrollable:
>
> con.Scrollable = false
>
> please set to false.
>
> Greetings
> 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] ODBC Function Sequence Error
Date: 06.01.15 23:06 (Tue, 6 Jan 2015 23:06:40 +0100)
From: Christian Schmitz

> On attempting to connect to a FileMaker Server (13.0.5) with the latest MBS
> Xojo SQL Plugin.xojo_plugin version 14.4 (18444) the following error occurs:
>
> S1010 [iODBC][Driver Manager]Function sequence error

I could reproduce it. After a select, the command object is not a result set, so you can't query next record.

Ah, it's scrollable:

con.Scrollable = false

please set to false.


Greetings
Christian

Re: [MBS] ODBC Function Sequence Error
Date: 03.02.15 22:42 (Tue, 3 Feb 2015 22:42:25 +0100)
From: Christian Schmitz

> Am 03.02.2015 um 22:41 schrieb Anthony Dellos <<email address removed>>:
>
> Christian - trying the code below and still getting the function sequence
> error.
>

did you check if cmd.isResultSet is true after Execute?

Normally we get sequence errors if you access a resultset and there is none.

Sincerely
Christian

Re: [MBS] ODBC Function Sequence Error
Date: 03.02.15 22:41 (Tue, 3 Feb 2015 13:41:28 -0800)
From: Anthony Dellos
Christian - trying the code below and still getting the function sequence
error.

The ErrorNumber property is -1341584476

dim con as SQLConnectionMBS = new SQLConnectionMBS
>
> try
>
> dim connectionString as string _
> = "Driver={FileMaker ODBC};" _
> + "Database=energy_snapshot_data_store;" _
> + "Server=****;" _
> + "PRT=2399;" _
> + “UID=****;" _
> + “PWD=****"
>
> con.Connect(connectionString, "", "", SQLConnectionMBS.kODBCClient)
>
> catch r as SQLErrorExceptionMBS
> return
> end try
>
> if con = nil then Return
>
> dim cmd as SQLCommandMBS
> cmd = new SQLCommandMBS
> cmd.Connection = con
>
> if cmd = nil then Return
>
> dim sql as string
> sql = "SELECT GetAs(image,'JPEG') as photo FROM images " _
> + "WHERE assessment_id = '" + self.unique_id + "' and image_type_id = 5"
>
> // select images using sql above
> cmd.setCommandText(sql)
> cmd.Execute
>
> con.Scrollable = False
>
> Try
> while cmd.FetchNext
>
> dim mb as MemoryBlock = cmd.Field("photo").asBLob.CopyBinaryData
> if mb.Size > 0 then
> Try
> dim p as Picture = Picture.FromData(mb)
> self.utility_bill = p
> End Try
> end if
> wend
>
> End Try
>
> cmd.Close
> con.Disconnect
> cmd = nil
> con = nil
>
> Return

On Wed, Jan 7, 2015 at 1:58 PM, Anthony Dellos <<email address removed>> wrote:

> Thank you! Will give it a try.
>
> On Tue, Jan 6, 2015 at 2:06 PM, Christian Schmitz <
> <email address removed>> wrote:
>
>>
>> > On attempting to connect to a FileMaker Server (13.0.5) with the latest
>> MBS
>> > Xojo SQL Plugin.xojo_plugin version 14.4 (18444) the following error
>> occurs:
>> >
>> > S1010 [iODBC][Driver Manager]Function sequence error
>>
>> I could reproduce it. After a select, the command object is not a result
>> set, so you can't query next record.
>>
>> Ah, it's scrollable:
>>
>> con.Scrollable = false
>>
>> please set to false.
>>
>> Greetings
>> 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