Link Sever Is Not Working

Mar 10, 2008

I have a SQL Server 2000 running on win 2003 where there is Linked Sever.
Recently we have upgrade the SQL server 2000 to SQL 2005 and things were fine but suddenly one day things stopped working when I have tested the connection for link server. It failed and gave me this error. What could be the possible error .

The source it is linked is a System DSN which is linking is a remote server running Informix Database. The driver is Informix CLI-2.5 (32 bit). Is it the driver that is the cause of error or what ???


"The test connection to the linked server failed."
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(String cmd)
at Microsoft.SqlServer.Management.Smo.LinkedServer.Te stConnection()
at Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.LinkedServerConnectionTest.Invoke()
===================================
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "INFORMIX_LIBRARY".
OLE DB provider "MSDASQL" for linked server "INFORMIX_LIBRARY" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "INFORMIX_LIBRARY" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "INFORMIX_LIBRARY" returned message "[INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories.". (.Net SqlClient Data Provider)

View 2 Replies


ADVERTISEMENT

Drillthrough Report Link Not Working

Oct 25, 2007

Good morning all!

I am working on a Actuals vs Budget report which needs drillthrough capability. Right now the reports are not deployed, I am working on them in Visual Studio 2005.

My main report has a text box with the Navigation tab set to Jump to report: DrillThrough1025. I have set all the parameters to pass through to the drill through report.

When I preview my main report and click on the drillthrough textbox, the DrillThrough1025 Report opens, but it opens with the parameter bar at the top, waiting for the parameters to be filled in.

Am I making a basic newbie error somewhere?

Any ideas, references, or resources would be greatly appreciated.

Thanks,
Kathryn

View 1 Replies View Related

Download Link Of SQL Express 2005 Not Working

Feb 12, 2007

When I click Download, it show NOT FOUND

What happened ?

View 1 Replies View Related

Starter Kits And Sample Applications Link Not Working

Oct 19, 2007

I am new to sql server express editions.
starter kits and Sample applications link provided in the sites are not working.
Can anyone provide me the alternate link where I can dwnld them from

http://msdn2.microsoft.com/hi-in/express/bb403187.aspx

http://msdn2.microsoft.com/hi-in/express/aa718396.aspx

View 1 Replies View Related

View SQL Sever 2005 Express Database On SQL Sever Enterprise Manager

Apr 25, 2006

Is it possible to connect SQL Sever 2005 Express from SQL Sever 2000 Enterprise Manager? Tried to connect but got the error message "must use SQL Server management tools to connect this sever"

Thanks

View 3 Replies View Related

Access2003 Cannot Link (but Excel2003 Can Link) To Tables In Access97 Database

Feb 20, 2008

I have created an Access2003 project (existing data) that links to external data. First I connected to a SQL Server 2000 database. Success. Then I tried to set up a Transact SQL data connection to a legacy MDW-secured Access97 database. (A third-party VB6 application goes against it, and we don't have the source code, so we cannot upgrade it.)

The Transact SQL link tests OK but I cannot select any of the tables or queries from the list presented. However, with the same credentials, I can use these same objects in Excel 2003.

When setting up the link in Access2003, I specify JET 4.0 OLE DB Provider, I enter the MDW file on the All tab, a username and a password on the Connection tab where I browse to the MDB file, and specify Shared Deny None on the Advanced tab. When I test the connection, it tests OK ("Test connection succeeded"). Yet on the "Select the Database and Table/Cube which contains the data you want" dialog, "(Default)" appears in the grayed-out dropdown. Then, beneath that dropdown, there is a grid with Name and Description columns. The grid contains query names but the grid is not enabled. The list of queries is this table is grayed out. Neither of the scrollbars works.

BUT... if I use the SAME username and password in Excel2003, and specify the same MDW, there is no problem working with these same database objects in the legacy Access97 database. WHAT IS DIFFERENT ABOUT THE WIZARD IN EXCEL THAT ALLOWS IT TO SUCCEED AND THE WIZARD IN ACCESS THAT CAUSES IT TO FAIL HERE? In Excel, the list of available providers says Microsoft Access Driver, not JET 4.0 OLE DB Provider.

Thanks
TR

View 1 Replies View Related

Cannot Link To SQL Tables Using ODBC Link Table In Access 2003

Feb 3, 2006

When trying to link to an SQL table in Access 2003, the software appears to be malfunctioning. 

The sequence of events is File - Get External Data - Link Tables - Files of Type: ODBC Databases().

The Problem: On two of my computers, the select data source window does not pop up, preventing me from linking to any ODBC data source. 

Observations:  This function has worked normally in the recent past and works on other computers running Access 2003.  One difference between the computers working and non-working computers is Norton Antivirus 2006 (recent upgrade).

Has anyone experienced anything like this?  What's going on?

View 8 Replies View Related

Sql Sever

Feb 9, 2008

 Hello, I'm trying to locate the Sql Server MyCompany database. Does anyone one know where I can get a copy for download? Thanks in advance for your help.GreaseLightning  

View 2 Replies View Related

SQL Sever Name!

Sep 6, 2005

Hello,I'm wondering if someone could help me to find the answer for this questionI'm connecting to SQL server database using the server name. When i remove or type the server name in wrong spelling, no errors being catched or even rised!!!!!How can i catch if the server name is incorrect?regards

View 3 Replies View Related

Need Help Connecting To Sql Sever

Nov 16, 2003

Hi

I am able to connect to an sql server from my server explorer. Can't seem to connect
to an sql server from my code.

this is what i am doing

String strConnection = "server=FRANK;database=Northwind;integrated security=true;";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open
objConnection.Close();

error Login Failure for user FRANK

I know that my server name is FRANK because thats what it says on my Sql Service manager.

And i use that same server name when i connect from my Server Explorer(using Visual Studio.NET) and then i get a listing of the the Databases that are associated with my SQL Server.

I have no problems coonecting to an Access dataBase using OLedbConnection

View 1 Replies View Related

Sql Sever Connection

Dec 2, 2004

I did not use Sql server for 2 weeks and now it shows the red small square on the server icon for SQL Server indication it is stopped. I can not now start it, it says access denies or not exist. Can you please help me to connect to it again as i do not want to re-install and los the databases. I have done nothing to it apart from i change my windows password as the system in the company you have to change it every 3 months, Do you think that might affects?


Please help!!!!!

View 4 Replies View Related

Upgrade To Sql Sever 7.0

Aug 30, 1999

hi, I do have a couple of database and store procedures in 6.5... I want to confirm that I will not run into any problems before I upgrade to 7.0 .
Is the upgrade pain free?
By using the wizard, I will make sure that all upgrade will go right?

any feedback from guys who have already upgraded.. Please give me feeback

Thanks

Ali

View 1 Replies View Related

Can Not Connect To SQL Sever

Apr 21, 2003

After restarting the SQL Sever agents, I can not connect to the server from my desktop via Enterprise manager or analyzer, but everything seems find on the server side. the error message is as follows: "a connection could not be established to [servername]
reason: SQL Server does not exist or access denied ConnectionOpen (Connect())..
I have not attempted to reboot the server yet, I would like to try to resolve the problem withoutout having to do this (last alternative)
setup:
SQL Server 2000 Service pack 3
running on Server 2000.
any help would be appreciated, thank you

View 2 Replies View Related

SQL Sever 2000 And DB2

May 17, 2002

I have a situation where I might want to pull(select) some information from a DB2 database, and possibly push(insert) some data to the same DB2 database. I am sure this is being done in the real world. WHat software, infrastrucure, etc would I need to accomplish this. Is it as simple as using DTS and the proper drivers, or are their better products and solutions. ANy
input appreciated.

View 3 Replies View Related

SQL Sever 2000

Jun 6, 2004

Hi, I have installed SQL 2000 on my system and when I try to start it gives me an error saying 'ordinal 29 cant be found in the dynamic link library odbcbcp.dll.
Please advice!!

View 1 Replies View Related

SQL Sever Book

Jul 28, 2004

Does anybody recomand me good book for sql server administrator and programmer?

View 1 Replies View Related

Sql Mail Sever

May 5, 2004

When i try 2 start the sql mail server
i am unable to do so as it throws the following error

MAPI login failure


wat shld i do now??

View 1 Replies View Related

Sql Sever Job Steps

Dec 3, 2006

I am trying to create a SQL Agent job with 3 steps.

I want to delete three tables.

Step 1 ...delete table "X"

Step 2 ...delete table "X"

Step 3 ...delete table "X"

problem is that afer i create the three steps and start the job it never seems to finish the first steps and non of the other steps run, the job looks like is executing and never finishes. I break the job into three jobs each completes fine. I need this to runs one job, any ideas?

perplexed for sure.....

View 1 Replies View Related

SQL Sever Computer Name

Feb 26, 2007

I don't have any errors to share, but I have a question.

What kind of problems (if any) would I encounter if the computer name where SQL Server 2000 or 2005 was installed included special characters? An example would be FNB_(1).



View 4 Replies View Related

How To Insert A Datetime To Sql Sever

Aug 30, 2006

Hi everyone,I need help in inserting a date time string to sql sever.  For example, how do you insert textbox1.text="2006-08-30 09:00:00" into a datatable column names starttime (type datetime) in sql sever?  How do I covert the format of this string before I do the insert?Thanks.a123.

View 2 Replies View Related

How To Insert A Datetime Into Sql Sever

Aug 30, 2006

Hi everyone,How do you insert this string value lable1.text="2006-08-30 09:00:00" into  a data column like startdate (type: datetime) in sql sever?How do I convert this string value before I insert it into sql sever? Thank you very much.a123.

View 1 Replies View Related

Error In Connect To SQL Sever

Dec 1, 2007

I have a problem with the connection to the DB…
I wrote this connection string in the web.config
<add name="dbConnectionString" connectionString="server=(local);database=2C2M;Trusted_connection = True" providerName="System.Data.SqlClient"/>But then when I creat ( SQLdataSource ) and chose this connection , this message is appeared 
  DataBase schema could not be retrieved for this connection . Please make sure the connection setting are correct and that the database is online. An error has occurred while establishing a connection to the sever . When connection to SQL Server 2005 , this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections. ( provider : Named Pipes provider , error : 40 – Could not open connection to SQL Server )
 How I can solve this problem ? 
Note : I use SQL EXRESS SERVER

View 1 Replies View Related

Saving To SQL Sever Database Using ASP.net(VB.net)

Feb 6, 2008

hi
I have two questions:
1. I want a code to save data typed in a textbox during runtime using SQL server database. The database has a table with several colums where i have to reference the necessary column.
2. Can i use a Gridview to enter data during runtime and save the same data to the database? that is, INSERTING data to the database.
 

View 1 Replies View Related

SQL Sever Error: 18452

Jul 23, 2001

The error is:

Connection failed:
SQL State '37000'
SQL Sever Error: 18452
[Microsoft][ODBC SQL Sever Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I have verified in Enterprise Manager that the concerened login is using a Windows 2000 Authentication and has the correct grant access permissions set up for the default database. Also switching to SQL Server Authentication or disabling security are not the options available in this case.

How to resolve this please-any help is welcome.

thanks
Sanjeev

View 1 Replies View Related

MS SQl Sever 2000 Question

May 14, 2003

i need write a Feasibility report about MS SQL 2000
Easy of use?
Cost?
Development speed?
Features

View 1 Replies View Related

Sever Registration Problem In Ent. Mgr.

Oct 18, 2006

One of my developers is trying to register a SQLServer server (Win 2000,
SQL 2000) using Enterprise Manager. He receives the message below;

A connection could not be established to sever_name.
Reason: "EXECUTE permission denied on objedt 'sp_MSSQLDMO80_version'.

His login is in an NT group and I added the login the way I've always
done. I even tried adding his login alone. No luck.
He can register other servers, just not this one. He can connect and
run queries on this server using Query Analyzer without issue.

I tried granting explicit execute rights to the sp but the error pops
up again but on a different sp this time.

This is not my server and is under the direct control of another dba
and IT group. I spoke with them and they were clueless about any
security setup/configuration that may have been done.

I'm clueless. If you have a clue please advise.

Thanks in advance.

View 4 Replies View Related

SQL Sever Performance Tests

Jul 28, 1998

I am currently investigating tools that are available that would enable us to performance test SQL tables/databases- can anyone recommend any?

Thanks

View 1 Replies View Related

Running Query From Two Sql Sever

Aug 24, 2004

Hi Everybody,

I have two SQL server one in the office and other on remote location. I have some data on SQL in the office and some data on remote location and need to query the data.

how can I do that ?

Thanks for your help in advacne

View 1 Replies View Related

Reinstall SQL Sever 2000

Sep 22, 2004

Hi all,

I have a server that is missing some important files, and instead of doing process of elimination, I feel it is best just to reinstall 2000.

Now is there a way to reinstall 2000 and just getting the files that the server is missing?

Is there any guidelines or steps for reinstalling 2000 out there?

Thanking you in advance.

Lystra

View 7 Replies View Related

Sever With Sql2000 && Sql2005

Jul 23, 2007

Hi,
Can a sever with OS win2003 install both sql2000 & sql2005? is there any problems with 2 differenct versions in one sever.

Thank you. :)

View 3 Replies View Related

Sql Sever Problem Solve

Aug 20, 2007

there is table...student

stu_id,stu_name,math_marks,phy_marks,che_marks,percentage,grade

percentage & grade will be calulated field.
If the percentage is >= 60
the grade wiill be 'A'

like that....solve this problem

View 2 Replies View Related

Sql Sever Problem Solve

Aug 20, 2007

studnet table...

fileds are...Id,name,math,physics,chemistry marks,percentage,grade

percentage & grade will aumated field

if percentage is more than 60 then the grade will be 'A'

View 14 Replies View Related

SQL Sever Agent Job Step !!

Mar 2, 2008

Hi pals,

I have stored procedure which dynamically creates a job with 3 job steps which will eventually runs 3 SSIS packages in a sequence.
But i dont know why it is skipping the 2nd step and executing the 3rd step.
I can clearly observe it in the logs.

And if comment the 3rd step and re-run the job, now it is executing the 1st and 2nd step in a sequence.
I can see the log for 2nd package also.
Again i uncommented the code for calling the 3rd step which loads data into Oracle tables.
This time again it is skipping the 2nd step.
I dont know the reason why it is happening so.
It is really frustrating me a lot.
IS there any precedence/ priority given while loading data into Oracle database?

Job steps
First step loads data from staging database to ODS
Second step loads data from ODS to DataMart
Third step loads data from DataMart to Oracle Tables

Can anyone please help me out.

I have tried all options.

Here is my stored procedure.
Is anything wrong in the below stored procedure.

CREATE PROCEDURE [dbo].[spExecDTSPackage]
as
declare @jid uniqueidentifier
declare @cmd1 varchar(4000)
declare @cmd2 varchar(4000)
declare @cmd3 varchar(4000)

SET @cmd1 = '"C:Program FilesMicrosoft SQL Server90DTSBinnDTExec.exe" /F "D:Package1.dtsx" '

SET @cmd2 = '"C:Program FilesMicrosoft SQL Server90DTSBinnDTExec.exe" /F "D:Package2.dtsx" '

SET @cmd3 = '"C:Program FilesMicrosoft SQL Server90DTSBinnDTExec.exe" /F "D:Package3.dtsx" '

declare @jname varchar(128)
set @jname = cast(newid() as char(36))


exec msdb.dbo.sp_add_job
@job_name = @jname,
@enabled = 1,
@delete_level = 1,
@job_id = @jid OUTPUT

exec msdb.dbo.sp_add_jobserver
@job_id = @jid,
@server_name = '(local)'

exec msdb.dbo.sp_add_jobstep
@job_id = @jid,
@step_name= N'step1',
@step_id = 1,
@on_success_action=4,
@on_success_step_id=2,
@subsystem= N'CMDEXEC',
@proxy_name= N'Proxyname',
@command= @cmd1,
@on_fail_action = 2 -- quit with failure

exec msdb.dbo.sp_add_jobstep
@job_id = @jid,
@step_name = N'step2',
@step_id = 2,
@on_success_action=4,
@on_success_step_id=3,
@subsystem = N'CMDEXEC',
@proxy_name= N'Proxyname',
@command= @cmd2

exec msdb.dbo.sp_add_jobstep
@job_id = @jid,
@step_name = N'step3',
@step_id = 3,
@on_success_action=1,
@on_success_step_id=0,
@subsystem = N'CMDEXEC',
@proxy_name= N'Proxyname',
@command= @cmd3

-- Start job
exec msdb.dbo.sp_start_job
@job_id = @jid,
@step_name= N'step1'


I have also tried out with an simple example , a job with 3 steps which basically inserts 3 recs into a table.

Here is the code and this one is executing fine.
I dont why the above code is not Functioning properly.

Any thoughts?

Thanks!



USE [msdb]
GO
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0

DECLARE @jobId BINARY(16)
EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'2D4474C9-2B4F-45C2-8640-EB8DE30A5276',
@enabled=1,
@notify_level_eventlog=2,
@notify_level_email=0,
@notify_level_netsend=0,
@notify_level_page=0,
@delete_level=1,
@description=N'No description available.',
@category_name=N'SRM',
@owner_login_name=N'sa',
@job_id = @jobId OUTPUT

IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Step_1',
@step_id=1,
@cmdexec_success_code=0,
@on_success_action=4,
@on_success_step_id=2,
@on_fail_action=2,
@on_fail_step_id=0,
@retry_attempts=0,
@retry_interval=0,
@os_run_priority=0,
@subsystem=N'TSQL',
@command=N'use ods
go
insert into test select 1,''ram''
go',
@database_name=N'master',
@flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Step_2',
@step_id=2,
@cmdexec_success_code=0,
@on_success_action=4,
@on_success_step_id=3,
@on_fail_action=2,
@on_fail_step_id=0,
@retry_attempts=0,
@retry_interval=0,
@os_run_priority=0,
@subsystem=N'TSQL',
@command=N'use ods
go
insert into test select 2, ''ganesh''
go',
@database_name=N'master',
@flags=0


IF (@@ERROR <> 0 OR @ReturnCode <> 0)
GOTO QuitWithRollback

EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId,
@step_name=N'Step_3',
@step_id=3,
@cmdexec_success_code=0,
@on_success_action=1,
@on_success_step_id=0,
@on_fail_action=2,
@on_fail_step_id=0,
@retry_attempts=0,
@retry_interval=0,
@os_run_priority=0,
@subsystem=N'TSQL',
@command=N'use ods
go
insert into test select 3,''Vinod''
go',
@database_name=N'master',
@flags=0


IF (@@ERROR <> 0 OR @ReturnCode <> 0)
GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId,
@start_step_id = 1


IF (@@ERROR <> 0 OR @ReturnCode <> 0)
GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'

IF (@@ERROR <> 0 OR @ReturnCode <> 0)
GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:

Any suggestions please let me know.

Thanks in advance!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved