SEO

#1 (**permalink**) 03-28-2008, 04:40 AM

I am trying to create an SSIS package. I am using SQL Server 2005 and am
trying to connect to a progress 9.1E db. I have the Datadirect drivers setup
on the SQL server and can connect to the Progress db if I go through
Administrative Tools-ODBC.

I tried creating the import through SMS right clicking the SQL db - Tasks -
Import data. I used the .NET ODBC driver, created the dsn, uid and password
for the connection string. I then click NEXT until I reach the query dialog
box. For testing I am creating a trivially simple query where I am selecting
3 fields from my Progress db. I have tried both of the following queries:

SELECT prod
cono
whse
FROM PUB.icsw

SELECT PUB.icsw.prod
PUB.icsw.cono
PUB.icsw.whse
FROM PUB.icsw

I get the following error for all variations of the query:

SQL Server Inport & Export Wizard
The statement could not be parsed. ERROR [42000] [DataDIrect][ODBC PROGRESS
Driver][PROGRESS]Syntax Error (7587) (PGPRO918.DLL)

I ahve not been able to find any solutions to this problem. Does anyone have
any additional ideas as to why I am getting this error?

Thanks,

#2 (**permalink**) 03-28-2008, 04:40 AM

Try
SELECT prod, cono, whse
FROM PUB.icsw

Ross

"Bill Phillips" <BillPhillips@discussions.microsoft.com> wrote in message
news:4BAE2AF1-64E1-464C-83D2-AA8C49CB273B@microsoft.com...
>I am trying to create an SSIS package. I am using SQL Server 2005 and am
> trying to connect to a progress 9.1E db. I have the Datadirect drivers
> setup
> on the SQL server and can connect to the Progress db if I go through
> Administrative Tools-ODBC.
>
> I tried creating the import through SMS right clicking the SQL db -
> Tasks -
> Import data. I used the .NET ODBC driver, created the dsn, uid and
> password
> for the connection string. I then click NEXT until I reach the query
> dialog
> box. For testing I am creating a trivially simple query where I am
> selecting
> 3 fields from my Progress db. I have tried both of the following queries:
>
> SELECT prod
> cono
> whse
> FROM PUB.icsw
>
>
> SELECT PUB.icsw.prod
> PUB.icsw.cono
> PUB.icsw.whse
> FROM PUB.icsw
>
> I get the following error for all variations of the query:
>
> SQL Server Inport & Export Wizard
> The statement could not be parsed. ERROR [42000] [DataDIrect][ODBC
> PROGRESS
> Driver][PROGRESS]Syntax Error (7587) (PGPRO918.DLL)
>
> I ahve not been able to find any solutions to this problem. Does anyone
> have
> any additional ideas as to why I am getting this error?
>
> Thanks,

#3 (**permalink**) 04-07-2008, 08:38 AM

"Bill Phillips" <BillPhillips@discussions.microsoft.com> 写入消息
news:4BAE2AF1-64E1-464C-83D2-AA8C49CB273B@microsoft.com...
> I am trying to create an SSIS package. I am using SQL Server 2005 and am
> trying to connect to a progress 9.1E db. I have the Datadirect drivers
> setup
> on the SQL server and can connect to the Progress db if I go through
> Administrative Tools-ODBC.
>
> I tried creating the import through SMS right clicking the SQL db -
> Tasks -
> Import data. I used the .NET ODBC driver, created the dsn, uid and
> password
> for the connection string. I then click NEXT until I reach the query
> dialog
> box. For testing I am creating a trivially simple query where I am
> selecting
> 3 fields from my Progress db. I have tried both of the following queries:
>
> SELECT prod
> cono
> whse
> FROM PUB.icsw
>
>
> SELECT PUB.icsw.prod
> PUB.icsw.cono
> PUB.icsw.whse
> FROM PUB.icsw
>
> I get the following error for all variations of the query:
>
> SQL Server Inport & Export Wizard
> The statement could not be parsed. ERROR [42000] [DataDIrect][ODBC
> PROGRESS
> Driver][PROGRESS]Syntax Error (7587) (PGPRO918.DLL)
>
> I AM A CHINESE,I WANT LEARN ENGLISH, EVERYONE ALLOW TECHING WITH ME

> Thanks,

#4 (**permalink**) 04-29-2008, 08:26 PM

Try:
SELECT PUB."icsw"."prod", PUB."icsw"."cono", PUB."icsw"."whse"
FROM PUB."icsw"

"Bill Phillips" wrote:

> I am trying to create an SSIS package. I am using SQL Server 2005 and am
> trying to connect to a progress 9.1E db. I have the Datadirect drivers setup
> on the SQL server and can connect to the Progress db if I go through
> Administrative Tools-ODBC.
>
> I tried creating the import through SMS right clicking the SQL db - Tasks -
> Import data. I used the .NET ODBC driver, created the dsn, uid and password
> for the connection string. I then click NEXT until I reach the query dialog
> box. For testing I am creating a trivially simple query where I am selecting
> 3 fields from my Progress db. I have tried both of the following queries:
>
> SELECT prod
> cono
> whse
> FROM PUB.icsw
>
>
> SELECT PUB.icsw.prod
> PUB.icsw.cono
> PUB.icsw.whse
> FROM PUB.icsw
>
> I get the following error for all variations of the query:
>
> SQL Server Inport & Export Wizard
> The statement could not be parsed. ERROR [42000] [DataDIrect][ODBC PROGRESS
> Driver][PROGRESS]Syntax Error (7587) (PGPRO918.DLL)
>
> I ahve not been able to find any solutions to this problem. Does anyone have
> any additional ideas as to why I am getting this error?
>
> Thanks,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Progress ODBC Connection Problem