ADO 2.5 connection problem
Dale Strickland-Clark
dale at out-think.NOSPAMco.uk
Wed Jul 19 13:05:32 EDT 2000
Totally brilliant. Thanks!
I thought that the Python interface to win32com was case insensitive unless
you did early binding - which I wasn't.
Also why did this work on 2.1?
But what a daft fucking error message. God knows what's going on inside for
it to come up with that message. I have wasted so much time on this.
There should be a law against wasting people's time with daft error
messages. My favourite is 'Internal error' with a 'details' button. Click on
the 'details' button and it says 'Internal error'. Which I didn't think was
much more help.
There's also a good one you can get out of Lotus Notes which is: "!"
Priceless!
Thanks again for the help.
--
Dale Strickland-Clark
Out-Think Ltd, UK
Business Technology Consultants
Geoff Talvola <gtalvola at nameconnector.com> wrote in message
news:3975D66D.8B5F46A2 at NameConnector.com...
> Dale Strickland-Clark wrote:
>
> > I've just knocked up a JavaScript equivalent of this as a Windows
Scripting
> > Component and it works a treat.
> >
> > Is it me or is Python Win32Com doing something stupid?
>
> Both :-) You need to use rs.Open, not rs.open. Case matters. The error
> message is about as misleading as can be, though.
>
> Incidentally, I use the following to create a connection to an Access db:
>
> db = win32com.client.Dispatch("ADODB.Connection")
> db.Mode = win32com.client.constants.adModeReadWrite # if we want
to be
> able to write
> db.Provider = 'Microsoft.Jet.OLEDB.3.51'
> db.Open(dbfile)
>
> I don't know if there are any advantages or disadvantages compared to what
> you're doing, but who knows, it may help you out somewhere down the road
to know
> this method...
>
> --
>
>
> - Geoff Talvola
> Parlance Corporation
> gtalvola at NameConnector.com
>
>
More information about the Python-list
mailing list