Re: Progress ODBC Connection Problem
- From: "Ross Culver" <rculver@xxxxxxxxxxxxxxx>
- Date: Thu, 27 Mar 2008 08:10:25 -0500
Try
SELECT prod, cono, whse
FROM PUB.icsw
Ross
"Bill Phillips" <BillPhillips@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4BAE2AF1-64E1-464C-83D2-AA8C49CB273B@xxxxxxxxxxxxxxxx
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,
.
- References:
- Progress ODBC Connection Problem
- From: Bill Phillips
- Progress ODBC Connection Problem
- Prev by Date: ODBC DSN created via script is not visible in "ODBC Datasource Administrator"
- Next by Date: All TCPIP Connections No Longer Connect
- Previous by thread: Progress ODBC Connection Problem
- Next by thread: ODBC DSN created via script is not visible in "ODBC Datasource Administrator"
- Index(es):
Relevant Pages
|
