Does a .NET driver has to be 100% CLR/C# or could you use C++ libraries? If the latter is allowed, you should start with the SQLDBC library: http://www.sapdb.org/7.4/pdf/sqldbc_eng.pdf
This library handles all the low level details of the SAP DB communication package. This library also handles other details like the transportation protocol (which is also used by dbmcli) and the conversion of the SAP DB specific number format. > 3. What does support look like for SAPdb 7.4 and earlier in > light of the > relationship with MySql? What I really want to know is will the wire > protocol for communicating with Sapdb change as a result of > work with MySql? > I don't want to invest a good deal of time implementing a > protocol that is > getting thrown away. There won't be any major changes to the protocol. And these changes will be mainly enhancements, old clients will remain valid. So be prepared to ignore new 'parts'. These are very rarely added to the protocol, mainly to provide additional information (like "last serial added") > 5. What docs are available to understand the protocol? If the the db > running on Linux and have vtrace working. Also, I have the > following url: > http://sapdb.2scale.net/moin.cgi/NetworkProtocol > > I have looked at the sources a bit but could not really make > good progress > understanding the flow. I have been making ok progress with > the protocol > specs. VTrace is probably the most important tool. Be sure to use the option 'diagnose vtrace ORDER on' to see the complete packet. You should also try the same statements with several clients, as not all the clients use all the features of the protocol. For example, the Precompiler and ODBC read LONG values by requesting several values at once for maximal throughput, whereas JDBC and Python read each LONG value separately for maximum flexibility. ODBC and Python don't implement batch inserts at the protocol level. Some hints if you really want to create a 100% C# driver: - start with the transportation layer to connect to dbm server. The application layer of the dbm protocol uses UTF8/ASCCI, so it's easy to implement. The transportation layer can best be learned from the JDBC sources (com.sap.dbtech.rte.comm - write your own packet trace, this is always a great learning tool Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
