Solved

Setting up ACT! as a linked server

Posted on 2006-06-30
10
424 Views
Last Modified: 2008-01-09
I am trying to set up ACT! as a linked server in SQL2000. I have lots of other linked servers (Sybase, Oracle)
I am using the ACT! OLE DB provider supplied with ACT.
I have registered the dll using regsrvr32
I have created a udl file that tests OK when i run a text connection.
However when I try to list tables in the linked server I get an Error 7403 - could not locate registry entry for OLE DB provider ACTOLEDB.1
help please !
0
Comment
Question by:JohnMalinowski
  • 5
  • 4
10 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17017034
<I have registered the dll using regsrvr32>
just make sure you did it on sql server - not your PC?
Did you try to create ODBC DSN on the sql server and create the linked server by usin the DSN?

BTW: who is the Act vendor?
0
 

Author Comment

by:JohnMalinowski
ID: 17017215
thanks for the feedback.
The dll has been registered on the server. ACT is installed on the same server. I am trying to set up the linked server on the SQL server (not via a workstation). Have tried both the wizard and sp_addlinkedserver.
As far as I can see you can't set up ACT using ODBC, it has to be OLEDB.
I'd prefer not to disclose the vendor.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17017273
Please use the steps in the articles mentioned below to check if you have the
provider in place.


http://support.microsoft.com/?id=216575 


http://support.microsoft.com/?id=200794 
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:JohnMalinowski
ID: 17017538
exec xp_enum_oledb_providers confirms that the ACT provider is present as 'ACTOLEDB.1'
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17017702
good,
Can you access the ACT database from the sql server box by any way (VB, VBS, etc.)

Check permissions, UID\PWD, TCP\IP port on the ACT box, etc.
if you have sql server 2000 with >=sp3
you can try to check to act connection:
OPENDATASOURCE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_oa-oz_2be1.asp
0
 

Author Comment

by:JohnMalinowski
ID: 17018362
Permissions are OK
I have no other apps on the server the try a connection. Might try installing excel.
The only connection that I have tried that works is a MS data link file (udl) and that just gives me a connection test OK.
I've tried OPENDATASOURCE but can't get past a syntax error. I'm beginning to suspect I need to know the precise syntax for the ACT OLEDB when running sp.addlinkedserver.
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 25 total points
ID: 17019539
try to check vendor help files about sql server
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 100 total points
ID: 17030188
Do you have any idea of a table name?

Possibly the facility to list tables doesn't work but you may be able to select from a table.

You could also try Regmon from sysinternals.com to try and identify where its looking in the registry.... maybe its getting it wrong?


But if you purchased the driver then you should be entitled to some support.



0
 

Author Comment

by:JohnMalinowski
ID: 17050065
Many thanks to all for the help - I have now solved the problem.
basically it is a registry entry issue.
The registry entry that gets created by the ACT OLEDB dll has the same data ('ACTOLEDB.1' ) for both the ProgId key and the VersionIndependentProgId key.
I noticed that for the Oracle OLEDB entry, the '.1' part was absent from the VersionIndependentProgId key, so I changed the ACT VersionIndependentProgId key to read 'ACTOLEDB'.
I then set up a new linked server using sp_addlinkedserver specifying @provider=N'ACTOLEDB' and hey presto it now works.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 17050599
you are welcome
but please read about Grade 'C':

http://www.experts-exchange.com/help.jsp#hi73
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
coldfusion upload spreadsheet into the databse 2 43
T-SQL: "HAVING CASE" Clause 1 23
Sql Server group by 10 26
Sql Query 6 64
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question