Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Setting up ACT! as a linked server

Posted on 2006-06-30
10
Medium Priority
?
432 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 43

Expert Comment

by:Eugene Z
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 43

Expert Comment

by:Eugene Z
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

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

Expert Comment

by:Eugene Z
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 43

Assisted Solution

by:Eugene Z
Eugene Z earned 50 total points
ID: 17019539
try to check vendor help files about sql server
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 200 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 43

Expert Comment

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

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

636 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