Hah... I have yet to try again... I'll give it another shot this
afternoon... thanks!
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kennedy, Jim
Sent: Friday, March 17, 2006 11:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Okay Ben...
Just dying of curiosity...
Did you get past the syntax error you were experiencing?
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kennedy, Jim
Sent: Wednesday, March 15, 2006 2:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Okay. I found that using Microsoft query, the only way I could
successfully query the PartTran table was to open a new query, edit it
in Microsoft query, turn of the "Auto Query" function, add the PartTran
table, then select the columns you want to retrieve and add specific
criteria to limit the dataset that's returned.
For example (I just did this now to prove it out...)
SELECT DISTINCT PartTran_0.TranType, PartTran_0.PartNum,
PartTran_0.TranQty, PartTran_0.PartDescription
FROM PUB.PartTran PartTran_0
WHERE (PartTran_0.TranDate Between ? And ?) AND (PartTran_0.TranType
Like ?)
Then I input "3/1/06 & 3/14/06" for the date range and "adj-qty" for the
transaction type.
This is the only way I know to get around that error.
Good luck!
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Wednesday, March 15, 2006 2:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Steps to reproduce my error:
Open Excel
Click Import External Data / New Database Query
Choose Vantage
Enter Password
Choose the PartTran table and the TranType field
Click next a few times until "View Data or edit Query in Microsoft
Query"
Click finish
SYNTAX ERROR 7587
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Wednesday, March 15, 2006 9:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Ben,
What is the full error message?
I have been seeing failed to open row set details:42000 Merant odbc
Progress driver [Progress] syntax error 7587. I too applied the
uncommitted suggestion without any luck.
My situation is I have both Crystal 8.5 and Crystal 9.0 on my client. I
recall having to roll back some dll's after installing 9.0 in order get
canned Vantage reports to work. I also have Crystal 9.0 installed on my
server to support eportal lite, a report application server (a watered
down Crystal Enterprise application). Opening the same report on my
server does not produce the error. both DSN are configured the same I
concluded that it must be a dll issue on my client.
Hope this helps.
Dan Shallbetter
States Electric Mfg.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Wednesday, March 15, 2006 10:37 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
I switched it over to read uncommitted and no luck. Syntax Error 7587.
Any other ideas? It would be most appreciated...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kennedy, Jim
Sent: Wednesday, March 15, 2006 5:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Open your ODBC Data Source Administrator, select the Vantage ODBC driver
(Most probably identified as MERANT 3.60 32-BIT Progress SQL92 if you're
using progress DB). Then click on the configure button, select the
"Advanced" tab and change the "Default Isolation Level" to "Read
Uncommitted"
You might also want to increase the "Fetch Array Size" while your in
that screen as well.
I know certain users like to use various size fetch arrays, but you'll
find out what works best for you...
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, March 14, 2006 5:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Can you please explain how to switch it to read uncommitted?
Thanks!
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kennedy, Jim
Sent: Tuesday, March 14, 2006 11:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
The PartTran is almost always being accessed by a number of programs.
I found that as long as I'm in the "read uncommitted" mode with my ODBC
it won't fail me.
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RICH WAGNER
Sent: Tuesday, March 14, 2006 2:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
I encounter the same error
-----Original Message-----
From: Ben Belzer [mailto:bbelzer@...]
Sent: Tuesday, March 14, 2006 2:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Syntax Error 7587
I am trying to access the PartTran table using ODBC and I am getting a
syntax error 7587.
Has anyone ever encountered this? This is the only table that gives me
this error.
Thanks!
Ben Belzer
IT Manager
TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
afternoon... thanks!
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kennedy, Jim
Sent: Friday, March 17, 2006 11:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Okay Ben...
Just dying of curiosity...
Did you get past the syntax error you were experiencing?
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kennedy, Jim
Sent: Wednesday, March 15, 2006 2:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Okay. I found that using Microsoft query, the only way I could
successfully query the PartTran table was to open a new query, edit it
in Microsoft query, turn of the "Auto Query" function, add the PartTran
table, then select the columns you want to retrieve and add specific
criteria to limit the dataset that's returned.
For example (I just did this now to prove it out...)
SELECT DISTINCT PartTran_0.TranType, PartTran_0.PartNum,
PartTran_0.TranQty, PartTran_0.PartDescription
FROM PUB.PartTran PartTran_0
WHERE (PartTran_0.TranDate Between ? And ?) AND (PartTran_0.TranType
Like ?)
Then I input "3/1/06 & 3/14/06" for the date range and "adj-qty" for the
transaction type.
This is the only way I know to get around that error.
Good luck!
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Wednesday, March 15, 2006 2:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Steps to reproduce my error:
Open Excel
Click Import External Data / New Database Query
Choose Vantage
Enter Password
Choose the PartTran table and the TranType field
Click next a few times until "View Data or edit Query in Microsoft
Query"
Click finish
SYNTAX ERROR 7587
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Shallbetter
Sent: Wednesday, March 15, 2006 9:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Ben,
What is the full error message?
I have been seeing failed to open row set details:42000 Merant odbc
Progress driver [Progress] syntax error 7587. I too applied the
uncommitted suggestion without any luck.
My situation is I have both Crystal 8.5 and Crystal 9.0 on my client. I
recall having to roll back some dll's after installing 9.0 in order get
canned Vantage reports to work. I also have Crystal 9.0 installed on my
server to support eportal lite, a report application server (a watered
down Crystal Enterprise application). Opening the same report on my
server does not produce the error. both DSN are configured the same I
concluded that it must be a dll issue on my client.
Hope this helps.
Dan Shallbetter
States Electric Mfg.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Wednesday, March 15, 2006 10:37 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
I switched it over to read uncommitted and no luck. Syntax Error 7587.
Any other ideas? It would be most appreciated...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kennedy, Jim
Sent: Wednesday, March 15, 2006 5:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Open your ODBC Data Source Administrator, select the Vantage ODBC driver
(Most probably identified as MERANT 3.60 32-BIT Progress SQL92 if you're
using progress DB). Then click on the configure button, select the
"Advanced" tab and change the "Default Isolation Level" to "Read
Uncommitted"
You might also want to increase the "Fetch Array Size" while your in
that screen as well.
I know certain users like to use various size fetch arrays, but you'll
find out what works best for you...
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ben Belzer
Sent: Tuesday, March 14, 2006 5:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
Can you please explain how to switch it to read uncommitted?
Thanks!
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kennedy, Jim
Sent: Tuesday, March 14, 2006 11:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
The PartTran is almost always being accessed by a number of programs.
I found that as long as I'm in the "read uncommitted" mode with my ODBC
it won't fail me.
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of RICH WAGNER
Sent: Tuesday, March 14, 2006 2:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Syntax Error 7587
I encounter the same error
-----Original Message-----
From: Ben Belzer [mailto:bbelzer@...]
Sent: Tuesday, March 14, 2006 2:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Syntax Error 7587
I am trying to access the PartTran table using ODBC and I am getting a
syntax error 7587.
Has anyone ever encountered this? This is the only table that gives me
this error.
Thanks!
Ben Belzer
IT Manager
TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links