A
asciibrajesh
Guest
Hi All, I got stuck in very wierd problem.Currently am facing an issue while inserting data in to Sybase database 15.7 with WMB code flow. Am currently using WMB7 Broker which is using DataDirect 6.0 Sybase Wire Protocol for connecting Sybase 15.7 Database.I have written code in our message flow which is trying to insert the data in the table directly . The data types used in database table is int and Image . But insert operation is not completing anyways. Whereas the same message flow code is inserting the data in Database table which is on Sybase 12.5 which is also using the same Data Direct 6.0 Sybase Wire Protocol. Also ASE Client is also inserting the data in database directly in to the table. Again I have changed th DataType for the table from Image to varbinary, So its behaving correctly for small amount of data (within the limit of page size of DB which is 2K in my case), but again its failing for large amount of data. I have also used text/unitext they all are behaving same as Image data type. I can sense this may be compatibility issue of ODBC drivers with Sybase 15.7 which are present in WMB7 Broker. Any kind of direction would be great help
Continue reading...
Continue reading...