How Do I Achieve - In SQL - Something Like On Error Resume Next In VB?

Oct 2, 2007

Often when I write a stored procedure, I encounter a situation where
it will be really convenient if I can ignore an error and continue the execution
of next SQL statement, especially when I know what kind of error it will generate.
It's just like the effect of "On Error Resume Next" in VB.

Does anyone have any idea or have some knowledge to share?
I would really appreciate.

I am using SQL Server 2005 and SQL Server 2000. Thanks.

Chris

View 5 Replies


ADVERTISEMENT

How To Achieve On Error Resume Next Login In SSIS For Loop

Apr 5, 2006

Hello All,

I am developing a package using SSIS which needs to do the following.

1. Read all flat file from a folder. I am doing this using For Loop task. I know the total number of files in that folder hence I am setting the loop counter = file count.

2. The next step is to import the data from flat file to SQL server destination table using data flow task.

3. Upon successful completion of data flow task there are some other tasks like SQL to do some checks/validation on the data, export it to another tables.

Upon successful completion of step 3 the iteration goes to next file.

I want to achieve the following

IF step 2 has error (for example corrupt file or incomplete data), I want to fail data transfer completely, skip step 3, and go to step 1 for next available file and do rest.

How do I do this in SSIS?

Thanks for your help.

SGK

View 1 Replies View Related

Resume Execution After Error

Nov 21, 2006

Hi,

I have a stored procedure containing iterating cursor in which iam inserting records in a table. My problem is that whenever any data mismatch occurs whole process gets stops. I want it should skip that error record and continue with next iteration. Like on error resume next in vb. Please suggest.

View 5 Replies View Related

Error 3926 , Server Failed To Resume Transaction

Aug 22, 2007

In a high load asp.net environment,  I am getting an error. The transation active in this session has been committed  or aborted by another session.Here is the code , I am getting error. 1 object returnObject = null;
2 SqlTransaction sqlTrans = null;
3 try
4 {
5 //Getting new SqlConnection
6 comm.Connection = GetConnection();
7 //Opening connection
8 OpenConn(comm.Connection);
9 //beginning transaction
10 sqlTrans = comm.Connection.BeginTransaction( IsolationLevel.ReadCommitted );
11 //setting transaction to SqlCommand object
12 comm.Transaction = sqlTrans;
13 //executing operation
14 returnObject = comm.ExecuteScalar();
15 //trying to commit.
16 sqlTrans.Commit();
17
18
19 }
20 catch (SqlException sex)
21 {
22 if (sqlTrans != null)
23 {
24 sqlTrans.Rollback();
25 }
26 }
27 finally
28 {
29 comm.Connection.Close();
30 }
  Could you please explain , am I doing smthg wrong ?

View 5 Replies View Related

Possible To Achieve In 1 Query?

Jun 20, 2001

Would like to derive a summary report like

WT<=0WT<=10WT<=20WT>20Min WTMax WTAvg WTTotal
---------------------------------------------
2001/06/0101001010101
2001/06/1802006872

from table

RecIDCreateTimeStampWT
----------------------
12001/06/01 08:0010
22001/06/18 08:308
32001/06/18 08:356


Is it possible to dervive the result in a single query? Or separate query needed like the followings :

SELECT CONVERT(CHAR(10), CreateTimeStamp, 111) AS Date, MIN(WT) AS MinWT, MAX(WT) AS MaxWT, AVG(WT) AS AvgWT, COUNT(RecID) AS TotalQ
FROM TAB_Name
GROUP BY CONVERT(CHAR(10), CreateTimeStamp, 111)

SELECT CONVERT(CHAR(10), CreateTimeStamp, 111) AS Date, COUNT(Qid) AS 'WT<=0'
FROM TAB_Name
WHERE WT <= 0
GROUP BY CONVERT(CHAR(10), CreateTimeStamp, 111)

SELECT CONVERT(CHAR(10), CreateTimeStamp, 111) AS Date, COUNT(Qid) AS 'WT<=10'
FROM TAB_Name
WHERE (WT > 0 AND WT <= 10)
GROUP BY CONVERT(CHAR(10), CreateTimeStamp, 111)

Thanks for all your help in advance,
Ben

View 2 Replies View Related

How To Achieve Partition Parallelism?

Jun 16, 2006

Hi,

Is it possible to achieve partition parallelism in SSIS? What I am asking is, In DataStage, if I load some data like 'data reader -> trans1 -> trans2 -> destination' (and assume that I have 4 nodes configured), the tool divides the data into 4 different datasets and executes the package as 4 instances. This way the data load is very fast. Is it possible in SSIS?

Of course we can divide the dataset and load them thru multiple instances? But then dividing the dataset will differ for every load and so we need to modify the package all the time. Even if we divide the dataset, I am not sure 4 instances will run in 4 different nodes or in a same node? So anybody has any idea about it?

Thanks.

View 4 Replies View Related

Can I Achieve Same Functionallity Through Script Task?

Apr 22, 2008


I have a flat file source which going to write in a db table. There is lot of warning message, which based on different condition (CSPL) generate different message, which I achieved through lots of conditional split and derived columns dataflow object. My question is can I achieved same functionality by the script task?

Any help will be appreciating.

Thanks

View 3 Replies View Related

Can I Achieve These Things Using Reporting Services?

Apr 17, 2008

I have a main report and some subreports.
What i want to achieve is the subreports would be dynamically sent parameters to and the layout would change depending on some
parameters sent from the main report.
So there ia going to be a main report that is constant but the subreports data and layout could change.

Another question is can i have an expression that would hide a subreport if there is no data in the subreport?

Any ideas would be appreciated

View 4 Replies View Related

How To Retrieve Resume From Database

Mar 20, 2008

I stored resume in database with datatype Image. But now i want to retrieve the resume becoz if user wants to edit their resume and again i shud store the updated resume into my database.
Give me ideas...Thanks in adv!! 
 

View 4 Replies View Related

How To Set A Catalog To RESUME Status

Nov 7, 2012

I came across the following error message while backing up a database:

The backup of full-text catalog 'myCatalog' is not permitted because it is not online.

Changing the status to RESUME for full-text catalog "myCatalog" (5) in database "myDB"

View 1 Replies View Related

Log Shipping- How To Resume After Swap

Oct 30, 2006

I have setup logshipping in sql 2005. i have a primary and secondary server only.
Suppose for maintenace i bring primary down. . i have to manually bring the secondary server online. usnig restore databse with restore.

1) so far so good. But what now. How can i re-sync the old primary with the new primary?

2) can i return the original secondary back to standby mode so that the primary can resume its role and the log shipping process proceeds.

View 5 Replies View Related

Pause And Resume Mirroring

Dec 5, 2007



If we have a situation that the Mirror server is unavailable for a day....very unlikely, but it happens when servers are moved from one data center to another....Lets assume we are doing safety off (high performance mode)

Should we pause mirroring on the principal server?

When we pause, does the transaction log keeps growing ?
Can we backup the logs ?

If we don't pause mirroring

Does the transaction log keeps growing ?
Can we backup the logs ?

What we can expect we we bring online the mirror server next day! will there be any performanbce problems since mirroring will try to catch up....

Considering moving to mirroring from logshipping for our disaster recovery.

Thanks,


View 4 Replies View Related

SQL 2012 :: Resume Data Movement

May 28, 2015

The secondary server for my availability group was recycled. When SQL Server came back online the data movement for a database was suspended. The error log shows:

"AlwaysOn Availability Groups data movement for database 'XXXXXXXXX' has been suspended for the following reason: "system" (Source ID 5; Source string: 'SUSPEND_FROM_RESTART'). To resume data movement on the database, you will need to resume the database manually. For information about how to resume an availability database, see SQL Server Books Online."

I was able to resume data movement with no issue. I would like to understand the technical reason as to WHY the data movement was put in the suspended state and left there upon recycle. I searched for an article that would list possible reasons (BOL, Google, Bing, etc..). I just could not find much information out there on 'SUSPEND_FROM_RESTART'.

View 2 Replies View Related

What Is The Best Way To Achieve Best Latency For Reads And Writes To SQL Server 2005?

Oct 18, 2007

I am looking into various options to improve latency of our application (we figured the latency is mainly because data persistence - writes and reads from DB). I am looking into In-Memory databases also. But, before making that decision (of using in memory databases), I would like to see if there is a way to configure SQL Server 2005 to get as close performance as in-memory databases?

My question:
1. Is there a way that I can configure SQL Server 2005 to use a CACHE that gets loaded as needed basis, so that future database reads/writes will happen to the cache as opposed to disk (db writes)?
2. Is SQL Server 2005 recoverable in such configurations?
3. Are there any ideas/resources where I can get more details? (Such as sample configurations with bench mark numbers, rpevious experiences..etc)

Thanks
Murthy

View 1 Replies View Related

Recovery :: How To Achieve Multi-site Cluster With 2 Node

Apr 27, 2015

We have two locations in US, I am thinking of having 2 node SQL cluster for Lync 2010, I alardy have One DB server running in one location, now we got new site where we are planning to have one more DB for redundancy.

View 5 Replies View Related

How To Store Resume And Cover Letter Into SQL Server?

Jun 6, 2005

Hi,
    I am trying to create an asp.net web recruiting application for HR, which will give the users the ability to both copy/paste the Resume and cover letter in textbox and upload resume and cover letter, then submit it (which will be saved into SQL Server 2000 table). 
I am thinking to save Resume and cover_letter as Image data type columns in SQL Server. 
.  Can someone give me a direction about how to save the uploaded resume and cover letter to table and if it's the easiest way to do it?
.  What to deal with different formats of uploaded resumes?  I hope to limit to only Word or HTML
.  Since I also give user another option - copy/paste the resume and coverletter into a textboxes.  Can I simply save the copy/paste resume and cover letter into text field column?  Later, say, if any HR recruiter retrieve the text from database, will it concatonates everything together without line break?
Any ideas is appreciated.

View 8 Replies View Related

SQLException The Server Failed To Resume The Transaction

Mar 24, 2008



Hello-

A customer has reported getting the following excpetion in our logs, and I have never seen it before and wanted to see if there was any insight you could provide to understand when you throw this exception.

The process is a "purging" process- it just executes a sequence of DELETE statements that should be fairly simple (delete a number of records from a table and CHECK some constraints, no cascading), after the sequence it commits. All of this occurs on the same connection. We use c3p0 for connection pooling.

Here is the exception:

2008-03-22 08:30:08,699 WARN impl.NewPooledConnection : [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
2008-03-22 08:30:08,699 WARN impl.NewPooledConnection : [c3p0] Another error has occurred [ com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:9f00000002. ] which will not be reported to listeners!
com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:9f00000002.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
at $Proxy15.rollback(Unknown Source)
at

View 3 Replies View Related

How Can I Achieve The Functionality Of External Procedure Transformation(Informatica) In SSIS

Dec 26, 2006

Hi,

I worked with informatica before and bit new to SSIS,

i have one simple question..

How can i achieve the same functionality as External Procedure Transformation (Informatica) in SSIS?

like..i want to use a DLL in my package which contains some set of business rules.

Please let me know.



Charles

View 1 Replies View Related

The Server Failed To Resume The Transaction. Desc:d200000003

Apr 18, 2007

Hi,

We recently migrated our application from SQL Server 2000 to SQL Server 2005 and we also migrated from WAS5 to WAS6.

We are getting the following exception when we call any of the stored procedures.

The server failed to resume the transaction. Desc200000003.

Basically we call these stored procedures frequently using the Java thread scheduler.

We didnt face any problem when we use IBM drivers

I guess this is the problem with the drivers.We use JDBC 2005 driver Version 1.1.

But we didnt face this problems when we use JDBC 2000 driver when we used to connect to SQL Server 2000

The Microsoft says that it has fixed the date problems as well as the transaction problems in the version 1.1.But still are facing the issues.

Can anyone of you please help me in getting the solution for the same?

View 4 Replies View Related

How Long Takes To Do Resume Full Text Index Population

Aug 11, 2012

I have a table having 220 lakhs of records and one of the column is Full Text enabled.We have used ContainsTable() to search for data, but we are unable to get results as expected. so we done rebuild.During Index Rebuild, population is failed.I have found this error in error log and it is saying to do resume population.So I want to know how long it takes to complete Resume population process.

look at the below more details about FT Index table.

Row count - 22155112

Index space - 1,903.250 MB (1.9 GB)

Data space - 87,552.258 MB (87 GB)

sqlserver2008 R2

and the below query we have used

HTML Code:
SELECT Distinct top 50 cal.case_id,cal.cas_details
From g_case_action_log cal (READUNCOMMITTED)
inner join containstable(es.g_case_action_log, cas_details,
' ("235355" OR "<br>235355" OR "235355<br> ") ') as key_tbl on cal.log_id = key_tbl.[key]
Where cal.product_id = 38810 ORDER By cal.case_id DESC

This query is not going to search in recent inserted/updated rows. this is the actual issue we are facing.

how to fix this error and if population need to be resume, then how long takes to do resume population.

View 1 Replies View Related

Can The Implementation Of Database Shared File Method To Achieve The Objective Of High Availability?

May 2, 2008

Hi,
can I assign a NAS(Network Attached Storage) server to store the database file(readable and writable) and assign other several MS SQL database servers which will use the same database file in NAS to achieve the objective of high availability?

If it can, how can I set it up in MS SQL Server or it requires another 3rd patry software to set it up?

Thanks.

View 4 Replies View Related

Integration Services :: How To Achieve Check Point Like Functionality In Data Flow Task Itself In SSIS

Jun 4, 2015

I have huge data and i am loading data from EXCEL to database table, after loading 80 percent data i am getting some error. My package got failed and it has lots of transformation and took around 6 hours to process completely because of that i don't want it to reload from start. if i run it again it should start from next record from where i got the error.

View 3 Replies View Related

Resume Parent Package After Child Package Failure...

Apr 23, 2007

Hello All,



I have a SSIS Package with a "Execute Package Task" to call a child package. I am trying to have the master/parent package complete its execution regardless the outcome (failure or success) of the child package. The overall structure of the master package is:



1. Perform Pre-load tasks (stored procedure).

2. Execute Package Task (call child package)

3. Perform Post-load Tasks (stored procedure)



I have try everything and cannot get the results that I want... I have tried the combination of "failparentonfailure", "forceexecutionvalue", etc. The master package stops at childs failure. I would like to resume to completion



Any ideas out there?



Rohan

View 10 Replies View Related

How To Achieve Data Redunancy Across Data Centers?

May 2, 2008

We have two db servers running in different datacenters connected through 2 100Mb/s data links. Each db is connected to 12 application servers. The total transaction per day by each application server is between 150K to 200K. Our requirement is to have all application server write to single db on each location. Then these databases are merged into one using replication. So at any given instant db on either datacenter will contain not only entries from its native application server but also from other datacenter. We tried using peer-to-peer replication but it caused severe blocking and few of our application servers crashed. We have to sync each table manually using after production in case we stop distribution agent during production. Is there any easy way to achieve above requirement within SQLServer 2005? Can we eliminate blocking in replication(don't tell me to use snapshot isolation or reducing commitbatchthreshold / commitbatchsize, we have already tried it; blocking is reduce but not eliminated)?

View 2 Replies View Related

SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. )

Jun 12, 2007

I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.

Extract from log:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).

I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.

Any ideas?

View 3 Replies View Related

[File System Task] Error: An Error Occurred With The Following Error Message: Access To The Path Is Denied

Sep 7, 2007

Hi -

I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:

[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".

Where do I change the security settings?

Thanks - Grace

View 5 Replies View Related

Exec Pkg Task: Error 0xC0202009 While Preparing To Load The Package. An OLE DB Error Has Occurred. Error Code: 0x%1!8.8X!.

Feb 21, 2007

I cannot execute a package by using Execute Package task.
I supplied sa credentials to connection manager, and it shows the list of Packages on SQL Server but when running the task it says

Error 0xC0202009 while preparing to load the package. An OLE DB error has occurred. Error code: 0x%1!8.8X!.



Any clue ?


Thanks,
Fahad

View 1 Replies View Related

Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error Accessing Windows Event Log

Dec 13, 2007



Hi,

I am running dts in Sql Server 2005 management studio from Management, Legacy and data Transformation Services.

Once the dts has run, I get this error message "Error Source : Microsoft Data Transformation Services (DTS) Package Error Description : Error accessing Windows Event Log."

Please help me

thanks in advance

Srinivas



View 1 Replies View Related

An Internal Error Occurred On The Report Server. See The Error Log For More Details. RsInternal Error)

May 20, 2008

We have reports deployed in the Report Server. While connecting from client, we are getting the error
"An internal error occurred on the report server. See the error log for more details. rsInternal Error)"

Then we went to Report Server, Reporting Service and SQL Server service are all are running fine.

Important thing is some time the reports are working fine, sometimes i am receiving this error. Please help.

We predict whether the services are automatically restarted or transaction logs exceeding the limit or any other parameters to set to avaoid this error?

Please help.

View 1 Replies View Related

[XML Task] Error: An Error Occurred With The Following Error Message: There Are Multiple Root Elements.

Aug 18, 2006

I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message:

[XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.".

The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it:

<?xml version="1.0" encoding="UTF-8"?>
<ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract>

There is only 1 ESDU root element and only 1 package element.

Of course, the XSLT stylesheet is also an XML document in its own right. I specify it directly in the XML Task:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"/>

<xsl:template name="identity" match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="kw">
<xsl:copy>
<xsl:apply-templates select="@*"/>
<xsl:attribute name="ihs_cats_seq" select="position()"/>
<xsl:apply-templates select="node()"/>
</xsl:copy>
</xsl:template>

</xsl:stylesheet>


Its 5th line is the first xsl:template element.

What is going on here? I do not see multiple root elements in either the XML document or the XSLT stylesheet.

Thanks!

View 5 Replies View Related

I Have The Dreaded Internal Error Occured On The Report Server. See Error Log For More Details No Error Log

Apr 9, 2008

I have the error above, but no error log. I can preview the sub report - but this main report fails after working this morning. This is for internal company reports and I rebuilt this one after converting from access.
I have looked where the error logs should be, but there are no error logs.
I rebuilt the query as I needed to change this, but this did not help.
Is there someone who could point me in the correct direction.

Thanks!
Terry

View 4 Replies View Related

Just Started Getting This Error When Trying To Connect To SQL From ASP.NET--error: 26 - Error Locating Server/Instance Specified

Apr 3, 2007

This has worked fine for weeks, and months.

I'm running Vista Ultimate. SQL 2005 is set as my Default instance, and SQL2000 is set as (local)SQL2000.

Today, actually half way through today, I restarted my computer after installing Photoshop Updates.

Upon getting my computer back up and running, I cannot access SQL2000 from any website on my computer, nor can I access it from SQL2005 Management Stdio. I CAN access it from Enterprise Manager (SQL2000 tool).

Whenever I run an web app that connects to it I get this error:


An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Now I usually get these when ASP.NET can't point to the right spot, but in this case I'm pointing exactly where I need to go. Any thoughts?

--Edit

I should also add my password got changed a few days ago on our Domain. This was the first time restarting after the PW change.

View 1 Replies View Related

Error 7399: OLE DB Provider 'MSDAORA' Reported An Error. OLE DB Error

Feb 18, 2007

My link server was working just fine until friday evening.
It stopped worked over the week end.
with and error Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error .

---my oracle 10g client is working just fine
--TNS names looks fine
---i recreated the link but i am still getting the same error.

I need your help because a lot of jobs are using that link on Monday it is going to be crazzzy.

View 7 Replies View Related







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