Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Linked Server Not Working Now...

 
   Database Help (Home) -> Programming RSS
Next:  free databases  
Author Message
Jody Baldwin

External


Since: Dec 08, 2010
Posts: 2



(Msg. 1) Posted: Wed Dec 08, 2010 10:10 am
Post subject: Linked Server Not Working Now...
Archived from groups: microsoft>public>sqlserver>programming (more info?)

Good Afternoon All,

I've got a problem I'm hoping someone can help me with. First I'm
running SQL Server 2008 and have a Linked Server to Informix. Two
weeks ago I was able to setup the Linked Server successfully and wrote
a Stored Proc to pull data from the Linked Server into a table in
SQL. The stored procedure was scheduled to run twice daily and did so
until 12/6 when it has stopped running but no errors are written to
the log.

Also today I tried to test the Linked Server using sp_testlinkedserver
and it ran for about 10 minutes before I tried to cancel it locking up
SSMS. I also tried using Openrowset instead of OpenQuery and the
statement never errors out but never returns the recordset.

I have WinSQL installed and the query returns in less than a second
against the Informix DB. So I'm not sure what is going on with SQL
Server.

Anyone have any ideas?

Thanks, Jody

 >> Stay informed about: Linked Server Not Working Now... 
Back to top
Login to vote
Jody Baldwin

External


Since: Dec 08, 2010
Posts: 2



(Msg. 2) Posted: Wed Dec 08, 2010 11:30 am
Post subject: Re: Linked Server Not Working Now... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Well sometimes the simplest of things correct the issue. Once I
stopped and restarted the SQL Server services my issues went away!

 >> Stay informed about: Linked Server Not Working Now... 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Linked server not working properly - I have two SQL Server 2000 instances running on our SBS2003 network. The second SQL Server is on a separate server box. Through Enterprise Manager, I can properly register the server and see all the tables, views, etc. I need to be able to pass..

Oracle Linked Server in 3-Hop Scenario not working in CRM .. - Hi, We have a SQL Server 2005 database that has an Oracle linked server defined. For that linked server, we are mapping all logins to a single Oracle login. We have a SQL Server view that uses OPENQUERY to pull back the Oracle data. That view is bein...

Linked server - HI, Is there a way to create a linked server to dbase files. I need to be able to import data from dbase files on a regular basis, once the data has been imported it then needs to go through a verification and transformation, then finally imported to th...

Self Linked Server - Hi, I am setting up a linked server on my local SQL server 2000 development machine. The server is linking to itself and I am setting this up soley for learning purposes. I first used the command Exec sp_addlinkedserver @server='link' ,..

Linked Server - I have connected a 3rd party ODBC via Linked Server How do I now reference a table in the Kinked Server using TSQL Eg Linked Server Name = Test1 Table name = testTBL select * from TestTBL what is the correct syntax Or is there a better way to do..
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]