Hi I am currently trying to get a script component to write data into a openedge database. Iam stumped by the below message. Validation error. Bulk Load ProjPeriod Bplan: Script Component [9378]: System.Data.Odbc.OdbcException: ERROR [HYC00] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented. ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server rejects connection on attach. ERROR [IM006] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed. ERROR [HYC00] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented. ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server rejects connection on attach. ERROR [IM006] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed. at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction) Package.dtsx 0 0 The two areas that I have found that might be causing this is transaction and codepage, however I have triedsetting these appropriately with no success. Any help would be much appreciated. Cheers, Ken C

Does the connectionwork correctly if you use the connection manager from a DataReader source?

Hi jwelch As far asI can tell, using this connection fromconnection managerwith Datareader does work. I created the connection and used in a datareader and it displayed the field names from the supplied sql. Cheers, Ken

Hi Again A bit wierd.... I changed the Fetch Array Size, in the odbc connectionto 0 .....this seemed to remove the error from ssis. (This seemed to work for somone else connecting to Oracle db) Since then i have put the value back to50 and the error messege has not returned ???????? Will develop futher and post back Cheers

I had the same error messages as KenCou, and a similar resolution experience. I was trying to query Progress from SQL Express, kept getting the same messages, in reverse order "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed."."[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server rejects connection on attach."."[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.". I had a working example on another server, and noticed that the "default isolation level" in the ODBC DSN definition was set differently. So I changed it from the default "Repeatable Read" to "Read Uncommitted." Still failed. Then I tried the above advice, changed Fetch Array Size from 50 to 0, still failed. After much searching, I was setting up to do an ODBC trace of my working example vs non-working, figured I'd change the 0 back to 50. Then it magically began working.

Hi, I´m getting the same message: OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed.] [OLE/DB provider returned message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server rejects connection on attach.] [OLE/DB provider returned message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.] I´ve tried the workaround of put 0 and then 50 again, but it didn´t work... Any suggestion?