olzfindyour.blogg.se

It seems LINKED SERVER treat character '-' as a keyword or reserved word.

The query give me the error written below after the query. In any way i write below my query in LINKED SERVER too, in BOLD font the name field with MINUS. I have a query with a field name with MINUS character and this it does not like to LINKED SERVER.ĭo you ha ve any suggest to override the MINUS problem ?įor this reason, i am trying to solve problem with reading directly PROGRESS OPENEDGE I used also LINKED SERVER but with it, i encountered a syntax problem i was not able to solve. Then i selected DSN to my OpenEdge Progress that i create previuosly. I selected -.NET Providers /Odbc data Provider I also copied and paste all data connection to connection manager connection string,but nothing. If i try to connect to my OPENEDGE Progress DB from Powerpivot of Excel or with Reporting Services.i can do it. Test connection failed because of an error in initializing provider error Errors found! The specified DSN contains an architecture mismatch between the Driver and Application." My problem that i received an error when i create a connection manager to connect to DB PROGRESS. Me too i have installed OpendEdge Odbc Driver for Progress ,10.2b and not 10.1b as you,in you example of three years ago. I am writing to you because i read you are the only programmer that did a SSIS to transfer data From Openedge Progress DB to a SQL SERVER Database. Hi my name is Mauro and i am new of SSIS sql server 2008 r2.