HighTechTalks DotNet Forums  

Updating a Siebel Database

Dotnet Framework (ODBC.net) microsoft.public.dotnet.framework.odbcnet


Discuss Updating a Siebel Database in the Dotnet Framework (ODBC.net) forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Charles A. Lackman
 
Posts: n/a

Default 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




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.