I have installed SAP Database Manager 7,4 and SAP SQL Studio 7,4 in XP and I connect using vb.net with odbc, everything goes well but I have been trying to keep data in xml in a field long but when doing it I am that the data are corrupt. When exporting one of the cells with the data xml ( with the SQL studio) to a window, they are well until offset 38152 from here to offset 76304 there are strange simbols and from offset 114456 returns to appear the xml data. Somebody knows if it is bug of odbc, I am making something bad, or is a configuration problem? Also it has happened to me that when executing insert sometimes jumps an exception to me of "instance non found" but other times it is executed well
Code that I use is the following one:
Dim myConnString as String "DSN=SAPTM;UID=sa;PWD=password;Trusted_connection=true;"
Dim conn4 as New OdbcConnection(myConnString)
conn4.Open()
Dim cmdInsert as New OdbcCommand()
Dim cmdtext as String cmdtext = "INSERT INTO SA.PRUEBA (DS) VALUES (:DSET)"
Dim param = New OdbcParameter("DSET ", OdbcType.NVarChar)
param.direction = ParameterDirection.Input
param.value = _ ds.GetXml
Dim MyCommand as New OdbcCommand()
MyCommand.Connection = conn4
MyCommand.CommandText = cmdtext
MyCommand.CommandTimeout = 60
MyCommand.Parameters.Add(param)
MyCommand.ExecuteNonQuery()
where _ ds.getXML contains the data in xml
regards Christian
_________________________________________________________________
Charla con tus amigos en l�nea mediante MSN Messenger: http://messenger.yupimsn.com/
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
