Re: How I can do a commit without loose my cursor with an rdo conn
From: Ralph (msnews.20.nt_consulting32_at_spamgourmet.com)
Date: 09/09/04
- Next message: Tim Baur: "Re: Dir command in VB"
- Previous message: Scott M.: "Re: Dir command in VB"
- In reply to: YvesLavoie: "Re: How I can do a commit without loose my cursor with an rdo conn"
- Next in thread: Ralph: "Re: How I can do a commit without loose my cursor with an rdo conn"
- Reply: Ralph: "Re: How I can do a commit without loose my cursor with an rdo conn"
- Reply: YvesLavoie: "Re: How I can do a commit without loose my cursor with an rdo conn"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Sep 2004 08:34:06 -0500
"YvesLavoie" <YvesLavoie@discussions.microsoft.com> wrote in message
news:E9566C39-B79B-441C-9947-C0DD6012B825@microsoft.com...
> Thank you for your help,
>
> I have another question, the code works when I use Oracle Odbc driver
> instead of Microsoft ODBC driver for Oracle to access my database. That's
why
> I was thinking
> maybe this is just a setting to set.
>
> thanks
> Yves Lavoie
>
You didn't mention your Oracle version, but don't use the Microsoft stuff
for ADO, DAO, RDO for any recent versions - Oracle 8i or better.
Be sure to check out the Oracle support site for updates to your client
software.
There will always be a certain amount of difference between the various
providers/drivers, so you may occasionally need to play around with
different versions.
If your budget can stand it take a look at the DataDirect stuff at
http://www.datadirect.com/download/index.ssp .
In general, it is NOT in the interest of either M$ or Oracle to provide the
'best' OLE DB providers. Oracle would prefer you used JDBC and M$ prefers
you to use SQLServer. DataDirect likes to keep everyone happy and has the
best support.
[Just in case you are planning on migrating - the jury appears to still be
out on .NET Data Providers. <g>]
hth
-ralph
- Next message: Tim Baur: "Re: Dir command in VB"
- Previous message: Scott M.: "Re: Dir command in VB"
- In reply to: YvesLavoie: "Re: How I can do a commit without loose my cursor with an rdo conn"
- Next in thread: Ralph: "Re: How I can do a commit without loose my cursor with an rdo conn"
- Reply: Ralph: "Re: How I can do a commit without loose my cursor with an rdo conn"
- Reply: YvesLavoie: "Re: How I can do a commit without loose my cursor with an rdo conn"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
