Recent content by Siffleu

  1. S

    importing progress db into MS SQL 2005

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

    sum(col2 - col3) as newnumber don't work

    I'm working with a Datadirect 4.10 sql92 v9.1E ODBC driver from my sql environement I am unable to perform the following : 'SELECT PIECE, DESC1, SUM(QTE_REQ - QTE_EXP ) AS nbrBO FROM PUB.VTCOMLIG WHERE CD_CIE = 1 AND CD_SUCC = 'RIV' AND (COMM_CL LIKE ''F%'') AND (QTE_REQ > QTE_EXP) AND...
  3. S

    importing progress db into MS SQL 2005

    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')
  4. S

    importing progress db into MS SQL 2005

    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
  5. S

    importing progress db into MS SQL 2005

    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
  6. S

    importing progress db into MS SQL 2005

    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...
See more
Top