ODBC error

Yahoo Archive
1
I'm getting an error when trying to update links in an Access97 database
using the Merant driver. I get the error -- 3146 ODBC call failed --

Access help states this is a metwork connectivity problem but the system is
connected to the network and the ODBC configuration checks out ok when I
test it in the ODBC configuration. Has anyone had experiance averting this
error? thanks



John Yohannan
MIS, Bracalente Mfg. Co., inc.
215-536-3077
<mailto:JYohann@...>
2
I've been trying to create a new report in Crystal.
Each time I insert a field having linked to a third table the following
error appears.
ODBC error [MERANT] [ODBC PROGRESS driver] [PROGRESS]** unable
to understand after- ''DECLARE''.247
-error detected by database.DLL
Has anyone else experienced this error under similar circumstances?

Merant ODBC is installed and we're running Vantage 4.00.811

Thanks in advance.
Sophie
3
I have gotten this error in the past on crystal 7. I think it had something
to do with crystal not handling the joins properly. Unfortunately, it was
several months ago, and I don't remember what fixed it. I called both
Vantage Tech support and also Seagate software support and one of them sent
me some kind of executable that fixed the problem. I don't have that
anymore either.

Sarah
4
Hi Karen,

I just had that problem yesterday and got it fixed. Crystal sent me a Registry file (outjoin.reg) from their website. You double-click it and it updates the Seagate portion of your registry. That first attempt didn't work, however. They next directed me to run the Crystal tool called. SQLCONN32.exe from the Crystal CD, which gave me the name of the driver that connects to Progress. They then had me edit the oujoin.reg file to add that filename to the "OpenIngress" line. That didn't work either. Finally, I sent all the stuff to Crystal, they put the filename on a separate line in a "custom" file, aptly named "troy.reg" after yours truly. That time it worked.

I think you might want to give Crystal a call. I talked to Ken (x 299) about all this, by the way.

Troy


----- Original Message -----
From: Karen Taylor
To: 'OneList'
Sent: Wednesday, October 11, 2000 7:31 AM
Subject: [Vantage] ODBC error


I've been trying to create a new report in Crystal.
Each time I insert a field having linked to a third table the following
error appears.
ODBC error [MERANT] [ODBC PROGRESS driver] [PROGRESS]** unable
to understand after- ''DECLARE''.247
-error detected by database.DLL
Has anyone else experienced this error under similar circumstances?

Merant ODBC is installed and we're running Vantage 4.00.811

Thanks in advance.
Sophie




eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
5
Sophie;

Vantage support is helpful with this error, the have documentation and work
arounds.



Warren



Warren.Eddy@...

219 478-2363 ext 217





-----Original Message-----
From: Karen Taylor [mailto:KarenTaylor@...]
Sent: Wednesday, October 11, 2000 6:31 AM
To: 'OneList'
Subject: [Vantage] ODBC error


I've been trying to create a new report in Crystal.

Each time I insert a field having linked to a third table the following

error appears.

ODBC error [MERANT] [ODBC PROGRESS driver] [PROGRESS]** unable

to understand after- ''DECLARE''.247

-error detected by database.DLL

Has anyone else experienced this error under similar circumstances?



Merant ODBC is installed and we're running Vantage 4.00.811



Thanks in advance.

Sophie












We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/

(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)