Updating a Siebel Database -
05-28-2004
, 08:57 PM
Hello, I have created a connection string to a siebel database and have
been able to connect and retrieve records using ADODB and the dbeng50.exe.
This works pretty good but it will not let me update any data from my .NET
Application. I am using the administrator password and have tried the user
password also. Both will let me retrieve information but neither will allow
for deleting records or updating.
I am Making reference to a System DSN
AConnectionString = "DSN=sse_Data;"
ADOConn.Open(AConnectionString, "DBA", "SQL")
Dim ACommand as new ADODB.Command
ACommand.CommandText = "DELETE FROM SIEBEL.CONTACT WHERE ROW_ID = '1+1+2+3'
ACommand.CommandType = adCmdText
ACommand.ActiveConnection = ADOConn
ACommand.Execute()
ADOConn.Close
Any Assistance will be greatly appreciated.
Thanks,
Chuck |