![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: SA 10.3 and OLE DB Topic Summary: SA 10.3 and OLE DB Created On: 16-Dec-2005 16:23 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
I'm trying to use OLE DB to transfer information from Microsoft Word to System Architect.
I can connect to SA and read information, but when I try to update some SA definition it gives the following error: "Run-time error '3251': Current recordset does not support updating. This may be a limitation of the provider, or the selected locktype." Does anyone knows if this limitation is from the provider or the locktype? I have tried several locktypes. Thanks, João Almeida Link Consulting Lisbon, Portugal |
|
![]() |
|
![]() |
|
The OLE DB interface to SA is read only. You will not be able to update a SA encyclopedia with it. If you want to update SA from Word I suggest using SA's object model.
|
|
![]() |
|
![]() |
|
Not even using an "Insert Into..." SQL Query?
"[...] I suggest using SA's object model. " do you mean parsing the word document using SA VBA? |
|
![]() |
|
![]() |
|
Yes, the OLE DB driver is only intended to read data from SA not update it.
I'm assuming that you have some data in your Word document that you want to get into SA. In Word you can make a reference to SA's object model (sa2001.exe) and then you can use this to create, update, or delete objects in SA. How you parse up the data in your Word document is up to you but Word's object model should give you plenty of options (although I'm no expert on Word). |
|
![]() |
|
![]() |
|
I have tried to use BusinessObjects XI with the new OLEDB interface of SA; However, when I choose the BOBJ OLEDB driver I am still unable to access the SA database. Any ideas?
I has worked fine from Excel where I am provided a selection for "System Architect OLEDB" or such.
Bill
|
|
![]() |
|
![]() |
|
Where can I find some additional documentation on using the OLD DB driver?
------------------------- Gary zebrook_joseph@bah.com 301-862-7027 |
|
![]() |
|
![]() |
|
I just use the ADODB COM provided with Windows. With connection_
With command_
Set rst = CreateObject("ADODB.Recordset")
|
|
![]() |
|
![]() |
|
Hi William,
did you have any sucess in using Business Objects and SA? Thanks, João Almeida Portugal |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.