Re: ADODB: Server will not allow .Mode=adModeShareDenyNone
From: Mugunthan Mugundan[MS] (mugunm-nospambegone_at_microsoft.com)
Date: 07/20/04
- Next message: William \(Bill\) Vaughn: "Re: Stores Procedures.."
- Previous message: Coneection OLAP: "Stores Procedures.."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 17:42:20 -0700
How does the server deny you changing the mode before you open. What
provider you are using. What error you are getting?
"Peter Gruendler" <usenetspam@fahr-zur-hoelle.org> wrote in message
news:1m8crc12se7us$.o11na4r0suos$.dlg@40tude.net...
> I have to deal with a remote Server that will not allow
> .Mode=adModeShareDenyNone (16) (or any other change) on an
> ADODB.Connection Object after creation and before .Open.
>
> This wouldn't be a problem, had not this Server somehow set the default
> Value to adModeShareExclusive (12) instead of adModeShareDenyNone.
>
> I have to use two independent Recordsets on this Connection Object, one
> created in a nested manner while working on the Records of the first
> Recordset.
>
> Obviously, adModeShareExclusive will prevent me from both executing a
> second .Open on the same Connection Object, as well as from creating a
> second Connection Object.
>
>
> Where is this behaviour configured? I could not find a way to change the
> default values on my test server. I would prefer to be able to tell the
> Company running the 'weird' server what they should do.
>
> Can anyone point me to the right info regarding this issue?
>
> Thx,
> Peter
- Next message: William \(Bill\) Vaughn: "Re: Stores Procedures.."
- Previous message: Coneection OLAP: "Stores Procedures.."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
