Invalid Character 00911 when creating sequence via VB

[nickjar2]

all i really have is the following:

dim sBeacon as string

sBeacon = "CREATE SEQUENCE beacon_seq;"

set cmd = new adodb.command

with cmd
.activeconnection = conn
.commandtext=sbeacon
.execute sBeacon
end with

That all looks OK to me. Cheers for any help. Nick (Everton Rool OK!)

 

[erre1p]

Hi,

I had the same problem a few months ago.

It's the connection string of the ADO control

that is probably set wrongly.

Hope this will help.

Regards. Pierre
Montreal,Quebec,Canada

 

[nickjar2]

Cheers for responding. You don't need the semi colon using ADO.

sBeacon = "CREATE SEQUENCE beacon_seq"
Nick (Everton Rool OK!)