ODBC/OLE DB connections with Crystal Reports and Epicor

Hi Lin: We are on 8.03.408 and have been using ODBC with crystal since 2003 with 6.1. We use this for complicated reporting that we can't do using BAQ's.

I would be interested in your experiences as to why ODBC shouldn't be used with Crystal reports.


Thanks,
Virginia Joseph
Deep Hole Specialists
440-543-8157
440-543-4882 Fax

--- In vantage@yahoogroups.com, Lin <plmidnightpassage@...> wrote:
>
> By the way, you are not suppose to use ODBC via Crystal Reports
>
> Peace and tranquility,
>
> Lin
>
> --- On Tue, 3/2/10, wsnowfl <wbsnow@...> wrote:
>
> From: wsnowfl <wbsnow@...>
> Subject: [Vantage] ODBC/OLE DB connections with Crystal Reports and Epicor
> To: vantage@yahoogroups.com
> Date: Tuesday, March 2, 2010, 2:42 PM
>

>
> I am trying to do some reports that are complex so require ODBC â€" must use stored Procedures can't do it in BAQ. I am connecting using OLE DB for SQL Server. I can connect and run the reports fine from Vantage menu, but when other users do, the program exits after they click the print report or print preview icon.
>
>
>
> using Microsoft SQL Server
>
> OLE DB connection to database
>
> Using sysprogress
>
> Sysprogress has rights to the database
>
> Run from Vantage menu as Custom Report Link
>
>
>
> Any ideas? Is there a "standard" way to do this? I have never had to before being relatively new to vantage but not to report writing. It would seem that for complex reports most every Vantage customer would eventually need to use ODBC or OLE DB? But I cannot find any documentation from Epicor besides BAQ Reports. Help desk has been no help.
>
> Any ideas?
>
I am trying to do some reports that are complex so require ODBC – must use stored Procedures can't do it in BAQ. I am connecting using OLE DB for SQL Server. I can connect and run the reports fine from Vantage menu, but when other users do, the program exits after they click the print report or print preview icon.

using Microsoft SQL Server
OLE DB connection to database
Using sysprogress
Sysprogress has rights to the database
Run from Vantage menu as Custom Report Link

Any ideas? Is there a "standard" way to do this? I have never had to before being relatively new to vantage but not to report writing. It would seem that for complex reports most every Vantage customer would eventually need to use ODBC or OLE DB? But I cannot find any documentation from Epicor besides BAQ Reports. Help desk has been no help.
Any ideas?
Have you got the Crystal Reports 2008 Reader on the client PC's?



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of wsnowfl
Sent: Tuesday, March 02, 2010 2:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC/OLE DB connections with Crystal Reports and
Epicor





I am trying to do some reports that are complex so require ODBC - must
use stored Procedures can't do it in BAQ. I am connecting using OLE DB
for SQL Server. I can connect and run the reports fine from Vantage
menu, but when other users do, the program exits after they click the
print report or print preview icon.

using Microsoft SQL Server
OLE DB connection to database
Using sysprogress
Sysprogress has rights to the database
Run from Vantage menu as Custom Report Link

Any ideas? Is there a "standard" way to do this? I have never had to
before being relatively new to vantage but not to report writing. It
would seem that for complex reports most every Vantage customer would
eventually need to use ODBC or OLE DB? But I cannot find any
documentation from Epicor besides BAQ Reports. Help desk has been no
help.
Any ideas?





[Non-text portions of this message have been removed]
Hi,
I had the same thing just last week.

Do the other users have the DSN with the proper drivers installed?


Sebastien.-

--- In vantage@yahoogroups.com, "Dines, Tim" <tdines@...> wrote:
>
> Have you got the Crystal Reports 2008 Reader on the client PC's?
>
>
>
> Tim Dines
>
> Information Technology
>
> Steel Parts Manufacturing, Inc.
>
> 801 Berryman Pike
>
> Tipton, IN 46072
>
> Direct: 765-675-5201
>
> Cell: 765-437-1402
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of wsnowfl
> Sent: Tuesday, March 02, 2010 2:43 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] ODBC/OLE DB connections with Crystal Reports and
> Epicor
>
>
>
>
>
> I am trying to do some reports that are complex so require ODBC - must
> use stored Procedures can't do it in BAQ. I am connecting using OLE DB
> for SQL Server. I can connect and run the reports fine from Vantage
> menu, but when other users do, the program exits after they click the
> print report or print preview icon.
>
> using Microsoft SQL Server
> OLE DB connection to database
> Using sysprogress
> Sysprogress has rights to the database
> Run from Vantage menu as Custom Report Link
>
> Any ideas? Is there a "standard" way to do this? I have never had to
> before being relatively new to vantage but not to report writing. It
> would seem that for complex reports most every Vantage customer would
> eventually need to use ODBC or OLE DB? But I cannot find any
> documentation from Epicor besides BAQ Reports. Help desk has been no
> help.
> Any ideas?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Never mind. I found the reason for the problem. I was using the mapped drive letter rather than UNC path name for the rpt file. Used UNC (or if we had a standard drive mapping convention) and it worked.

--- In vantage@yahoogroups.com, "wsnowfl" <wbsnow@...> wrote:
>
> I am trying to do some reports that are complex so require ODBC – must use stored Procedures can't do it in BAQ. I am connecting using OLE DB for SQL Server. I can connect and run the reports fine from Vantage menu, but when other users do, the program exits after they click the print report or print preview icon.
>
> using Microsoft SQL Server
> OLE DB connection to database
> Using sysprogress
> Sysprogress has rights to the database
> Run from Vantage menu as Custom Report Link
>
> Any ideas? Is there a "standard" way to do this? I have never had to before being relatively new to vantage but not to report writing. It would seem that for complex reports most every Vantage customer would eventually need to use ODBC or OLE DB? But I cannot find any documentation from Epicor besides BAQ Reports. Help desk has been no help.
> Any ideas?
>
Have you set them up with ODBC connection on their computer as well?

Peace and tranquility,

Lin

--- On Tue, 3/2/10, wsnowfl <wbsnow@...> wrote:

From: wsnowfl <wbsnow@...>
Subject: [Vantage] ODBC/OLE DB connections with Crystal Reports and Epicor
To: vantage@yahoogroups.com
Date: Tuesday, March 2, 2010, 2:42 PM
















Â









I am trying to do some reports that are complex so require ODBC – must use stored Procedures can't do it in BAQ. I am connecting using OLE DB for SQL Server. I can connect and run the reports fine from Vantage menu, but when other users do, the program exits after they click the print report or print preview icon.



using Microsoft SQL Server

OLE DB connection to database

Using sysprogress

Sysprogress has rights to the database

Run from Vantage menu as Custom Report Link



Any ideas? Is there a "standard" way to do this? I have never had to before being relatively new to vantage but not to report writing. It would seem that for complex reports most every Vantage customer would eventually need to use ODBC or OLE DB? But I cannot find any documentation from Epicor besides BAQ Reports. Help desk has been no help.

Any ideas?






























[Non-text portions of this message have been removed]
By the way, you are not suppose to use ODBC via Crystal ReportsÂ

Peace and tranquility,

Lin

--- On Tue, 3/2/10, wsnowfl <wbsnow@...> wrote:

From: wsnowfl <wbsnow@...>
Subject: [Vantage] ODBC/OLE DB connections with Crystal Reports and Epicor
To: vantage@yahoogroups.com
Date: Tuesday, March 2, 2010, 2:42 PM
















Â









I am trying to do some reports that are complex so require ODBC – must use stored Procedures can't do it in BAQ. I am connecting using OLE DB for SQL Server. I can connect and run the reports fine from Vantage menu, but when other users do, the program exits after they click the print report or print preview icon.



using Microsoft SQL Server

OLE DB connection to database

Using sysprogress

Sysprogress has rights to the database

Run from Vantage menu as Custom Report Link



Any ideas? Is there a "standard" way to do this? I have never had to before being relatively new to vantage but not to report writing. It would seem that for complex reports most every Vantage customer would eventually need to use ODBC or OLE DB? But I cannot find any documentation from Epicor besides BAQ Reports. Help desk has been no help.

Any ideas?






























[Non-text portions of this message have been removed]
Why are you not supposed to use ODBC connections with Crystal Reports?
I have been using this for many years.



Jerry Rodden

SA - Production Planning/MRP

Cardington Yutaka Technologies Inc.

575 West Main Street

Cardington, OH 43315

Phone: 419-864-8777 ext. 6209

Fax: 419-864-7771

Email jrodden@...





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