"General SQL Error"

Bob Ackerman

Delphi Developer

Sun, 16 Sep 2001 03:00:00 GMT

"General SQL Error"

I just wrote a database app that works great on my machine, but will not run
on the two others that I've installed it on. I'm connecting to an Access
database via the BDE's native drivers. The error message that comes up on
the other machines is, "General SQL Error."
I ran the BDE Administrator and recreated the alias, but when I double-click
it, I see "Operation not supported." I would greatly appreciate any help...
thanks.

Bob

Bill Tod

Delphi Developer

Sun, 16 Sep 2001 03:00:00 GMT

Re:"General SQL Error"

Are you sure that Microsoft's DAO 3.5 (assuming you are using an Access 97
database) is installed on the other two machines? If they have any of the
Office apps installed it should be there.

Bill

Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
for any other reason remove nospam from my address.)

Ackerma

Delphi Developer

Mon, 17 Sep 2001 03:00:00 GMT

Re:"General SQL Error"

One machine has Access 97. I believe I may be overlooking something in the
InstallShield Express setup.... On a lark, I copied my entire BDE folder
(from my 'working' machine) and replaced the BDE folder on the other
machine. My app now works! Obviously, I don't want to do this for every
install; any thoughts on what's missing?

Quote

Bill Todd wrote in message <7dukag$d3...@forums.borland.com>...
>Are you sure that Microsoft's DAO 3.5 (assuming you are using an Access 97
>database) is installed on the other two machines? If they have any of the
>Office apps installed it should be there.

>Bill

>--

>Bill Todd - TeamB
>(TeamB cannot respond to email questions. To contact me
> for any other reason remove nospam from my address.)

Bill Tod

Delphi Developer

Tue, 18 Sep 2001 03:00:00 GMT

Re:"General SQL Error"

Do a sorted listing of all of the DLL's in both directories and see what is
missing from the one that does not work. Sorry I don't have a more elegant
solution<g>.

Bill

Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
for any other reason remove nospam from my address.)

Ackerma

Delphi Developer

Fri, 21 Sep 2001 03:00:00 GMT

Re:"General SQL Error"

Thanks Bill, I'll do that. I'll let you know what I turn up.

Quote

Bill Todd wrote in message <7e3th3$i...@forums.borland.com>...
>Do a sorted listing of all of the DLL's in both directories and see what is
>missing from the one that does not work. Sorry I don't have a more elegant
>solution<g>.

>Bill

>--

>Bill Todd - TeamB
>(TeamB cannot respond to email questions. To contact me
> for any other reason remove nospam from my address.)

Other Threads

1. CashedUpdates give error - "GENERAL SQL ERROR"

2. MSSQL 6.5 "General SQL Error "

3. "General SQL Error" with MSSQL2K

4. Problem with a "General SQL error"

5. "General SQL Error: Invalid Handle Request"

6. SQL explorer's data tab gives "general sql error"

7. Delphi 6 raise error "General SQL Error" when I am connecting to blob field in Oracle 8i

8. What does "General SQL Error" mean?

9. "General SQL Error" ?

10. Design time = OK; runtime = "general SQl error"