Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 16-Dec-2005 16:23
User is offline View Users Profile Print this message


João Almeida

Posts: 7
Joined: 25-Nov-2005

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
Report this to a Moderator Report this to a Moderator
 19-Dec-2005 17:09
User is offline View Users Profile Print this message


Kevin P. Calandrella

Posts: 52
Joined: 9-Sep-2005

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.
Report this to a Moderator Report this to a Moderator
 21-Dec-2005 12:23
User is offline View Users Profile Print this message


João Almeida

Posts: 7
Joined: 25-Nov-2005

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?
Report this to a Moderator Report this to a Moderator
 21-Dec-2005 20:36
User is offline View Users Profile Print this message


Kevin P. Calandrella

Posts: 52
Joined: 9-Sep-2005

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).
Report this to a Moderator Report this to a Moderator
 24-Feb-2006 17:59
User is offline View Users Profile Print this message


William Wimsatt

Posts: 17
Joined: 7-Nov-2005

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
Report this to a Moderator Report this to a Moderator
 2-May-2006 14:55
User is offline View Users Profile Print this message


Joseph Gary Zebrook

Posts: 3
Joined: 1-May-2006

Where can I find some additional documentation on using the OLD DB driver?

-------------------------
Gary
zebrook_joseph@bah.com
301-862-7027
Report this to a Moderator Report this to a Moderator
 18-May-2006 02:02
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

I just use the ADODB COM provided with Windows.
Below is an example of how this can be set up.

'http://www.devguru.com/Technologies/ado/quickref/connection.html
'Set up ADODB recordset objects.
connection_string = Split(encyclopedia_.ConnectString, "|")(1)
Set connection_ = CreateObject("ADODB.Connection")

With connection_
 .ConnectionString = connection_string
 .Provider = "SQLOLEDB"
 .ConnectionTimeOut = 15
 .Open
End With


Set command_ = CreateObject("ADODB.Command")

With command_
 .CommandType = 1 'adCmdText
 .Name = "bus_reqs"
 .CommandText = SQL
 .ActiveConnection = connection_
End With


If Not connection_ Is Nothing Then
 If connection_.State = 0 Then 'adStateClosed
 connection_.Open
 command_.ActiveConnection = connection_
 End If

 Set rst = CreateObject("ADODB.Recordset")
 With rst
  .Open command_
  If Not .BOF And Not .EOF Then
   connection_.BeginTrans
   .MoveFirst
   Do Until .EOF
    _CODE_GOES_HERE_
    .MoveNext
   Loop
  End If
  connection_.CommitTrans
  .Close
 End With
End If

 

Report this to a Moderator Report this to a Moderator
 21-Sep-2006 12:23
User is offline View Users Profile Print this message


João Almeida

Posts: 7
Joined: 25-Nov-2005

Hi William,
did you have any sucess in using Business Objects and SA?

Thanks,
João Almeida
Portugal
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.