importing progress db into MS SQL 2005

[Siffleu]

Hi
In the past, I was using ms sql 2000, and was able to import progress database with the merant ODBC drivers.

Since I am now on sql 2005, and a new version of progress ( 9.1E) I still need to import database into my ms sql server... but there is no more way to import database using ODBC into ms sql 2005

1-is it normal that I can't use anymore any user or machine ODBC into ms sql 2005 wizard ?

2-if it's normal that I can'T see existing odbc link into ms sql 2005 what is the best way to import progress database into my ms sql ?

thanks

 

[Casper]

Did you had a look at KB P120484:

A. Using Object Explorer
1. Setup an ODBC connection to the Progress Database in the ODBC
Administrator in the System DSN. Make sure the connection successfully
establishes.
2. Bring up SQL server 2005 Management Studio, connect to Object
explorer. Under Server Objects -> Linked Servers, Right click -> New

3. Provide the information to Following options
Linked server - Provide the name you will use to refer to this linked
server.
Server Type - Select Other data source as server type. Clicking this
option activates the options below it.
Provider - Microsoft OLE DB provider for ODBC driver.
Product name - it could be anything but better to use progress since
it is a progress database.
Data source - ODBC System DSN name The rest of the options can be
left blank
4. Go to the Security tab, choose the radio button associated with
"Be made using this security context" and enter the "Remote login" and
"With password" of the progress SQL92 user as supplied in the ODBC
DSN.
5. Click OK

Casper.

 

[Siffleu]

hmmm

been there done that...

then how do I use the data now ... ?

I was planing to import table into a ms sql database just like I was able to with sql 2000 and my merant 3.6 driver..

since I use now sql 2005 and merant 4.1 , well, I'm quite lost

 

[Siffleu]

serously, anyone can be more specific ?
the linked server is there, if I right click on it and do a "test connection" it's sucessful

but how do I use the database ?

In SQL 2005 studio, I want to import data from my progress DB into a SQL database and I can't figure out

 

[Siffleu]

I finaly figured out how to use the link server on ms sql 2005

just have to use
select * from openquery(linkservername, 'select * from table')

 

[heindhoven]

Hello,

I'm also using a linked server to access data from progress. But when i do a query like
select * from openquery(linkservername, 'select * from table')
I notice in the results the column order is different than it should be. Is there any way to influence the column order, but still using the asteriks like selec * ???.
When i make an ODBC connection from EXCEL or ACCESS tot the same progress table, the column order is OK.

 

[Siffleu]

I had few problem like that. I had to force using CAST AS DECIMAL in a lot of query
hope this help