Re: Retrieve new values of a database

Could you possibly use sqlserver as your driver instead. check into DTS (data transformation services) if you are not on sqlserver2005, otherwise on ss2005 you can look into SSIS (sqlserver integration services... replace DTS). you may have to experiment with the DTS/SSIS process flow tasks, but i bet you could get it to work. unless that is of course, you are not running a Sqlserver version that has these capabilities or like your informix DB, you don't have much control on your Sqlserver side either. Norma Jean luissol wrote: >Hello, I have the view from a table that keeps incrementing with new >values, I have no control of this database, but I need to retrieve the >new values to insert it on my table (sql server) and send some >parameters of the database to another application, I'm using C# to get >access to both databases, so does anybody know of an efficient way to >retrieve only the new values of the dtabase? > >Thanks a lot > >Luis Saavedra -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/informix/200610/1