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 ole db driver missing
Topic Summary: OLE db provider not listed as a data source driver
Created On: 31-May-2007 15:19
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.
 31-May-2007 15:19
User is offline View Users Profile Print this message


Patrick Harris

Posts: 3
Joined: 7-Sep-2006

I would like to connect Access or Excel 2003 via the SA OLE DB provider, per the instructions listed in the help. However it is not listed as a driver when I try to create a new data source. Is there any additional help documentation on how to add the driver or reinstall it? Thanks.
Report this to a Moderator Report this to a Moderator
 4-Jun-2007 17:12
User is offline View Users Profile Print this message


SA Team

Posts: 148
Joined: 18-Nov-2005


Hi

It should be there from the SA install. Note the driver will not be seen for Excel 2000.

Here is a test you can try:

1) On the desktop, create a new text document called test.udl.
2) Say yes on the rename prompt.
3) Double-click on test.udl. The Data Link Properties dialog opens.
4) Click on the Provider tab.
5) Scroll down the list. You should see "System Architect Provider for OLE DB". You can then select it, and click on Next. And then on the Connection tab, test the connection.
 
Now, if you still don't see "System Architect Provider for OLE DB, try the following:
 
In the System Architect directory, reregister the files SADriver.dll and SAHandler.dll. 
(drag and drop them individually onto c:\windows\system32\regsvr32.exe)
 
Then you can run the above test again, and the System Architect Provider for OLE DB should be seen there, and be available in Excel and Crystal Reports.



-------------------------

Senior Software Developer
Telelogic UK Ltd.
Report this to a Moderator Report this to a Moderator
 5-Jun-2007 14:21
User is offline View Users Profile Print this message


Patrick Harris

Posts: 3
Joined: 7-Sep-2006

Thanks!
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.