Progress ODBC Connection Problem

[Bill Phillips]

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,

[Ross Culver]

Try
SELECT prod, cono, whse
FROM PUB.icsw

Ross

"Bill Phillips" <BillPh...@discussions.microsoft.com> wrote in message
news:4BAE2AF1-64E1-464C...@microsoft.com...

[刘俊谅]

"Bill Phillips" <BillPh...@discussions.microsoft.com> 写入消息
news:4BAE2AF1-64E1-464C...@microsoft.com...

> I AM A CHINESE,I WANT LEARN ENGLISH, EVERYONE ALLOW TECHING WITH ME:) :)
> Thanks,

[Bruce]

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

[Jesusma]

Hi, Try

SQL SELECT "prod", "cono", "whse"
FROM PUB.icsw