SQL 2.0 and CVI 5.5 Problem - Help please!

[RBL]

Hi All,

I have recently updated to CVI 5.5. Over the last week I have been update
my programs to 5.5. However, I am having problems with the SQL toolbox -
more specifically the "DBImmediateSQL" function. When the line of code runs
which contains this function, it returns the error code -11, and an
Automation Error code -2147352573, Unknown error.

I am stuck, as this program has been running in 5.0.1 for about a year.
Does anyone have any idea what could be wrong?

Richard

[Bill Groenwald]

Richard,
I don't have an answer but maybe a clue. I am still running 5.0.1 and have
just run into the same problem. I'm suspecting a recent install of a software
inventory management package effected some Oracle library file that LabWindows
goes through. I found that if I switched to the DBActivateSQL for my insert,
that worked. I have asked support what could allow DBActivateSQL to work
and DBImmediateSQL to fail but have no answer yet. If you can, try that workaround
to see if it helps. Good Luck.
Bill Groenwald

[RBL]

Bill,

After some discussion with the folk from NI, we discovered that it was
caused by the installation of SP4 for MSVS. I found I had to reverse all
changes made by this upgrade to the OBDC and database access. Once this was
done, I reloaded an older version and things worked fine.

Sorry for the delay in replying - been on holidays.

Richard

"Bill Groenwald" wrote in message
news:3a0c7794@newsgroups.ni.com...
>
> Richard,
> I don't have an answer but maybe a clue. I am still running 5.0.1 and have
> just run into the same problem. I'm suspecting a recent install of a
software
> inventory management package effected some Oracle library file that
LabWindows
> goes through. I found that if I switched to the DBActivateSQL for my
insert,

> that worked. I have asked support what could allow DBActivateSQL to work
> and DBImmediateSQL to fail but have no answer yet. If you can, try that
workaround
> to see if it helps. Good Luck.
> Bill Groenwald
>

[jpozo]

Once I have detected that my problem is similar to this one I have desinstall the MSVS, I have re-installed the SQL Toolkit and the Microsoft Office, but still I have the same problem.
What else can I do??? Should I format the hard disk ???

Thanks in advance