Recent content by henky

I gave the wrong error, that one was from A Microsoft site. This is the error message I receive in SQL Server, but the native code does work in Progress. Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing the query "SELECT Store_no, App_date...

Hello ESquared, Thanks for your response! I got a table in progress "pub.appointement" which contains the 'wrong' date field "app_date". SBHPRO_GSK2 is my linked server "Progress 9.1E " SELECT TOP 1 * FROM OPENQUERY (SBHPRO_GSK2, 'SELECT Store_no, App_date...

Thanks for the replies again! LNBruno, The table I've to access, is a 'production' table, so I cant change the columntype into varchar. SQLDenis, The Openrowset won't work for me :( I am trying to create a public view in progress, which I hope to use in my select statement. The other problem...

Hello, I am trying to import data directly out of Progress 9.1E into SQL Server 2005. For many tables this is no problem, I created a Linked server and am able to connect the tables and can use T-SQL statements to select records out of the tables. SQL Server 2005 has a big F***-up in their...

Does anyone else got any idea how to solve this problem? Henky

should be

I still got the same error when I was trying the code you mentioned above. I did try that before:

Denis, Thanks for your reply. I will store it in a varchar, thats not a problem, but I cant 'read' the record out of the table from linked server. I can use SELECT TOP 1 field1, field2, datefield_with_a_few_invalid_values_for_SQL_Server FROM Table because there is...

At first thanks for the replies LNBruno and gmmastros! I am iusing the dateformat in the right way, the problem isn't in the dmy subject. The problem is founded in a application which excepts every date value (AD) which ever was at this world. So there are dates in that database like...

Hello, I am currently busy to build a datawarehouse and I am importing data out of a linked server (Progress 9.1E). I am working with SQL Server 2005. I will get an error: Msg 8114, Level 16, State 8, Line 1 Error converting data type DBTYPE_DBTIMESTAMP to datetime. The problem occures when...

Here two screenshots of my situation. I just tried the option AtomicWedgie gave me, but it won't work, even whitout the quotes, it won't work. Could the empty field create the troubles, near to the db-logo (cilinder)??

Hi, I am not sure if I am doing something wrong or if it is a bug but, I can not seem to parse a SQL querie in the DTS Wizard. I get the following message. "Unexpected Error occured.The provider has returned an Error result without an Error message". The syntax is: select...

Thanks for the support I'll give it a try... :)

How can I add an auto increment row in a query? Existing table: Names Name John Jamie Adolf Nelson Tony George Kevin I want to make a select ... into query (to create a new table) SELECT Name INTO NewNames FROM Names ORDER BY Name GO The result has to be ID Name 1| Adolf 2| George 3| Jamie...

@vongrunt From sample data it appears that (ref, cust, purch_date) are sorted and unique. Is that always true? ------ Yep. those 3 fields always are unique