RE: Progress ODBC Connection Problem
- From: Bruce <Bruce@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 25 Apr 2008 12:39:00 -0700
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,
- Prev by Date: Re: sp_prepexec and sys_comments
- Next by Date: Re: SQL Server Case Sensitivity
- Previous by thread: Re: Progress ODBC Connection Problem
- Next by thread: help,a difficult text how to sql table code ?
- Index(es):
Relevant Pages
|
