Re: D7 errors with complex dataset command text

"Keith G Hicks" <krh@xxxxxxxxxxx> wrote in message
news:446205e0$1@xxxxxxxxxxxxxxxxxxxxxxxxx

Causes various errors in the IDE? My MDAC is up to date. It even causes D7
to lock up on me when I try to set the connection object back to connected
=
false. When setting the dataset object active = true I get errors like
"Access violation at address 77FCD989 in module ntdll.dll. Read of address
FFFFFFFF." Also when I try to turn my connection object to connected or
not
connected (which I can normally do just fine withuot any errors) I get a
similar AV but in module msado15.dll.

Happens to me also in D6 and D2005 (ex. using aggregate functions in
sub-selects). I've also seen posts on the MS newsgroups with VBer's
experiencing the same problem, so it's not just a "Delphi" thing. The weird
part is other developers in our shop have no problems at all (similar
hardware, similar software installations).
A workaround I use is to create views, udfs, and stored procedures to return
the result set I need.

Good luck,
krf


.

Relevant Pages

  • Re: D7 errors with complex dataset command text
    ... I have a feeling it's some MDAC ... I did try changing this to a view but SQL won't let me update it if ... to lock up on me when I try to set the connection object back to connected ...
    (borland.public.delphi.database.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.oledb)
  • Re: Garbage Collection and Visual Studio
    ... Don't create the connection object on ... dispose of it. ... >> then use the Dispose method of that class. ... > the same connection object until the form is unloaded. ...
    (microsoft.public.dotnet.languages.csharp)