General SQL Error -2146824655

[Michael Broomhead]

I assume you are using the MSACCESS driver....

Open your BDE Administrator, click on the Configuration tab and select Drivers -
Native - MSACCESS.
In the definition screen (on the right) you see the field DLL32 and for Access97
it's value should be IDDA3532.DLL, and not IDDAO32.DLL.

HTH,
Michael

Bert Edens wrote:

> Greetings, all...
> When running a BDE application (created with Delphi 4 Pro using Access97
> for the database), we receive:
>
> General SQL Error
> -2146824655
> Alias
> Alias: SupportCalls
>
> I have checked the version of DAO and Jet we have installed (3.5) and
> this seems to be OK. I did a search on the web (Google), Inprise and Deja,
> and couldn't even find reference to this error number... Help please! :)
> Thanks in advance for your time and efforts.
>
> - Bert Edens

[Bert Edens]

Thanks for the help, Michael. Unfortunately, BDE is already configured that
way... :-/

This one just has me totally stumped... Sure would be nice to figure it
out...

- Bert Edens

"Michael Broomhead" <bro...@nospam.nlr.nl> wrote in message
news:3A067059...@nospam.nlr.nl...

[Jeff Overcash (TeamB)]

Borland has a FAQ on this at
http://community.borland.com/article/0,1410,15002,00.html. MS moved the link in
that
FAQ and Borland hasn't had a chance to update the link yet. Here is the updated
link

http://support.microsoft.com/support/kb/articles/Q141/2/94.asp

Bert Edens wrote:
>
> Thanks for the help, Michael. Unfortunately, BDE is already configured that
> way... :-/
>
> This one just has me totally stumped... Sure would be nice to figure it
> out...
>
> - Bert Edens
>

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
The fool escaped from paradise will look over his shoulder and cry
Sit and chew on daffodils and struggle to answer why?
As you grow up and leave the playground
Where you kissed your Prince and found your frog
Remember the jester that showed you tears, the script for tears. (Fish)

[Bert Edens]

Thanks for the note, Jeff. I totally uninstalled Access (it was version
2000, which has worked fine on other PCs) and reinstalled it. No go. Even
uninstalled it and installed just the MS Data Access Components (2.6). Still
no go. And the SQL error I am getting is different (2146824655) than the one
listed in the FAQ (2147221164). Does that make any difference? I
specifically unregistered the DAO and MSJet DLLs and re-registered them, and
that doesn't seem to have made a difference...

Help? Please? :-)

Thanks in advance...

- Bert

"Jeff Overcash (TeamB)" <over...@onramp.net> wrote in message
news:3A06E70D...@onramp.net...