SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Link Server Problem


Link Server Problem

Author
Message
day-476284
day-476284
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1558 Visits: 485
Hi everyone,



I created a link server from Server1 to Server2 to connect to a FoxPro database by using the sp_addlinkedserver stored procedure.



Server1 (Windows Server 2003 + SQL Server 2000)

Server2 (Windows Server 2000 + SQL Server 2000 + FoxPro 9)



I can run querries locally in Server1 and they retrieve results with no problem calling the link server.

However, when I try to run querries from a network machine by logining in SQL2000Server1 I have a problem.



Error 7302: Could not create an instance of OLEDB provider 'vfpoledb'

OLE DB error trace [Non-interface error: CoCreate of DSO for vfpoledb

returned 0x80040154]



Everyone can help me?



Thanks
Janet Keith-489067
Janet Keith-489067
SSC Eights!
SSC Eights! (992 reputation)SSC Eights! (992 reputation)SSC Eights! (992 reputation)SSC Eights! (992 reputation)SSC Eights! (992 reputation)SSC Eights! (992 reputation)SSC Eights! (992 reputation)SSC Eights! (992 reputation)

Group: General Forum Members
Points: 992 Visits: 85
sounds like an MDAC issue. make sure you have the latest MDAC installed on the client.
day-476284
day-476284
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1558 Visits: 485
Hi Janet,



I have the latest (MDAC) version.

However, (MDAC) 2.8 release does not include Microsoft Jet, the Microsoft Jet OLE DB Provider or ODBC driver, the Desktop Database ODBC Drivers, or the Visual FoxPro ODBC Driver.



I have installed vfpoledb.exe version8.2.



When I try to send a query to link server using administrator windows login, I can get the results. The problem if I try to login with a user login I cannot access.



Do you have any idea how to set permission for OLEDB driver vfpoledb.?



Thanks
day-476284
day-476284
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1558 Visits: 485
Finally,



I have solved my problem.



That was a WIN Server 2K3 security issue. This corresponds to MSDAINITIALIZE DCOM component. The The Solution is:

Change permission settings for the component.

{2206CDB0-19C1-11D1-89E0-00C04FD7A829}.



Thanks everyone.
mak101
mak101
SSC Eights!
SSC Eights! (861 reputation)SSC Eights! (861 reputation)SSC Eights! (861 reputation)SSC Eights! (861 reputation)SSC Eights! (861 reputation)SSC Eights! (861 reputation)SSC Eights! (861 reputation)SSC Eights! (861 reputation)

Group: General Forum Members
Points: 861 Visits: 218
Can you please explain in details. I am having similar issue but can't find the solution.
sbeach
sbeach
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 3
I think he's refering to this link::-)
==================
http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/05258d18-d7e5-411d-b591-d98ba6674448/
To resolve this I believe all you need to do is add the users who will be accessing the linked server (remotely or locally) to the "DB2USERS" (local group on the MSSQL server).

The db2cli.ini file (and others) in the directory where DB2 components are installed is restricted based on membership in "DB2USERS" and "DB2ADMNS" groups.
HTH.-Steve
==================
==================
Personally, I'm still stuck.Crazy
Here's the error I get.
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
"The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?"
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Cannot create an instance of OLE DB provider "Ifxoledbc" for linked server "INFORMIX". (Microsoft SQL Server, Error: 7302)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=7302&LinkId=20476
============

I clicked the "For Help" link and got: We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this t
LOL

Here are some other links that have at least helped me on the way.
http://publib.boulder.ibm.com/infocente ... ledb20.htm

Basics:
http://www-01.ibm.com/support/docview.w ... wg21195578

Helpful Link:
http://blog.biztalk-info.com/archive/20 ... ormix.aspx

MDAC download (installed in QA-D 5/21/2010):
http://www.microsoft.com/downloads/deta ... layLang=en

http://www.sqlservercentral.com/Forums/ ... 146-1.aspx

Other hints:
http://media.datadirect.com/download/do ... setifx.htm
http://social.msdn.microsoft.com/Forums ... ba6674448/

Any suggestions or helpful hints will earn you a beer if you are in the Littleton mass area. ;-)
Stephaniew00t
sbeach
sbeach
Valued Member
Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)Valued Member (71 reputation)

Group: General Forum Members
Points: 71 Visits: 3
Yeah Me
OK it worked. Not sure exactly what but here are two things that are important.
1) The Product Name. When You look into "MS SQL Server Mng Studio Express" under "Server Objects" -> "Linked Servers" -> Providers, you will see the provider Ifxoledbc.
First be sure you use a capital 'i'.

2) When you view the properties for this provider I enabled the following
"Dynamic parameter"
"Allow inprocess"
and
"Supports 'Like' operator"

3) I did a single quote in the "Provider String" in the Linked Server Properties.
ie:
username='informix';password='mypassword'

4) In Security in Linked Server Properties, I used:
"Be made using this security context" and entered the same username and password as in step 3.

So I clicked OK and did not receive any error messages.
WaHoo.
Hope this helps. I'm going for a beer now. I earned it.
Steph
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search