Re: D7 errors with complex dataset command text

Thanks for the info Kevin. That helps. I have a feeling it's some MDAC
thing. I did try changing this to a view but SQL won't let me update it if
it's a view. I need the dataset to be editable. So I tried indexing the view
and the subqueries I'm using won't allow for that. So I couldn't get any of
that to work either. TBetterADO solved the problem so far.

"Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:44621497$1@xxxxxxxxxxxxxxxxxxxxxxxxx
"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: ADO control and SQL Session
    ... I closed the form,reopen it, the number of sql session ... Recordset's connection object, using its ActiveConnection property. ... I drag and drop the ADO control to a user form. ...
    (microsoft.public.vb.controls)
  • Re: Any help here???
    ... I think MDAC Applies in this instance. ... > ADO.NET has its own SQL Server provider for data access. ... > could think of off hand for installing MDAC is for any old COM applications ... > then what does your connection string and connection object look like? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Any help here???
    ... ODBC is totally unnecessary here and even undesirable as ADO.NET's SQL ... ..NET - and I've never installed MDAC or tried to use ODBC. ... >> could think of off hand for installing MDAC is for any old COM ... >> then what does your connection string and connection object look like? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Strange Invalid Connection Error
    ... Have you tried using the MDAC Component Checker to determine which version of ADO is loaded on the machines? ... > To start the application you have to "sign in" to the SQL Server database ... > 2147418113 DBNMPNTW Invalid Connection ...
    (microsoft.public.sqlserver.setup)
  • Re: Any help here???
    ... >> could think of off hand for installing MDAC is for any old COM ... >> then what does your connection string and connection object look like? ... >> people who are posting here are NOT Microsoft employees. ...
    (microsoft.public.dotnet.framework.aspnet)