Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Deleting Data In A Linked Table Is Not Supported By This ISAM.


Hi,
 
I am trying to delete a row in excel [Sheet1$], where this data in that row is used in a pivot table in same excel [Sheet2$] which should also get deleted, when i try to delete that row using "delete ... from [Sheet1$] " it is throwing an error message "Deleting data in a linked table is not supported by this ISAM. (Microsoft Office Access Database Engine)"
Can you please guide me in overcoming this error...........
 
Thanks in advance,
 
Warm Regards,
gchanduu


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
ISAM : Excel Linked Server In Sql Server 2005
Dear Friends,

I am getting error when trying to make excel file as the linked server in my sql server the details are as under:

 

os: windows xp and also tried on windows server 2003

server: sql server 2005 sp2

excel: office 2003 and also tried with .xls file of office 2007

 

tried to add the remote as well as file on the same computer as linked server, but error was:

 

could not find installable ISAM and error no was 7303.

 

Please help me up.

I got the idea to make it as linked server from microsoft article and followed the neat steps and got the errors.

Thanks,

View Replies !   View Related
Deleting Data By Comparing To Another Table
I have an entry form allowing customers to enter up to 15 skus (productid) at a time, so they can make a multiple order, instead of enteringone sku, then submitting it, then returing to the form to submit thesecond one, and so forth.From time to time, the sku they enter will be wrong, or discontiued, soit will not submit an order.Therefore, when they are done submitting their 15 skus through the orderform, I want a list showing them all of those skus that came back blank,or were not found in the database.I'm doing this by creating two tables. A shopping cart, which holds allthe skus that were returned, and a holding table, that holds all theskus that were submitted. I want to then delete all the skus in theholding page that match the skus in teh cart (because they are goodskus) which will then leave the unmatched skus in the holding table.I'll then scroll out the contents of the holding table, to show them theskus that were not found in the database.(confused yet?)So what I want to do is have some sql that will delete from the holdingtable where the sku = the sku in the cart. I've tried writing this, butit dosn't work.I tiried this delete from holding_table where sku = cart.skuI was hoping this would work, but it dosn't. Is there a way for me to dothis?Thanks!Bill*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View Replies !   View Related
Trouble Deleting Data In Table
I have a table where I want to delete some data from but I get this error.

You might have a record that has a foreign key value related to it, or you might have violated a check constraint.

What to do????

View Replies !   View Related
Data From The Table Deleting Automaticaly.
Hi gurus,

The data is automaticaly deleting from one perticular table at every night from last week onwords. I have created a delete trigger to find it out. But Nothing was recorded. There is no jobs except maintainance plans. Nothing in event viewer too. The database recovery model is simple. How can i solve this problem
Please advise me to solve this problem

Thanks
Krishna.

View Replies !   View Related
Deleting Data Using Table Prefix
 

I can run a select to retrieve data using a prefix 'a' for the specific table involved. However when I try to run a delete using the same criteria it fails telling me

Msg 102, Level 15, State 1,.......Line 1

Incorrect syntax near 'a'

 

The Select statement looks like:

select count(*) from schema.table a where a.customer_id=1234

The Delete looks like:

delete from schema.table a where a.customer_id=1234

What am I doing wrong here? and how can I prefix the table, because the command I want to run is much more complicated than the example above and it needs the prefix

View Replies !   View Related
Deleting Data From Primary Table
 

Hi Everybody,
 
Kindly let me know if there is a way of deleting data from primary table without deleting data from its corresponding foreign key table.
 
Thanks & Regards
 
 

View Replies !   View Related
Reduce Table Size Without Deleting Data
We are using SQL Server 2000 Standard ed, sp4 on Server 2000 Advanced.We have one table that is three times as large as the rest of the database.Most of the data is static after approximately 3-6 months, but we arerequired to keep it for 8 years. I would like to archive this table (A), butthere are complications.1. the only way to access the data is through the application (they areimages produced by the application-built on Power-Builder)2. there are multiple tables refrencing this table and vise-versa3. we restore the entire db to two other servers for testing and trainingregularly4. there might be more complications that have not been thought ofCurrently, our only plan is to setup a seperate server with a copy of this dbon it and the application. Leave only the tables necessary to access the data,and if this 'archive' works, remove from production the data from the table Aand all references to the table A from rows on the other tables.I mentioned #3 because someone mentioned a third party tool that may be ableto pull the data from the table, archive it elsewhere, and at the same time,place a 'pointer' in the table to the new storage location. The tool theymentioned only works on Oracle and we have not explored beyond that yet.I am ready to explore ideas and suggestions; I am still new to the DBA world,I am out of ideas.Thank you!--Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forum...eneral/200607/1

View Replies !   View Related
Urgent! Please Help! Deleting Data From A Huge Table
I have a huge table with 4 primary keys on it. I need to delete the data from this table ( approx. 5.6 millions records to be deleted). It takes a hell lot of time to delete it by normal query.
Can someone please suggest me a better way?
Any help will be appreciated.

View Replies !   View Related
Deleting Large Amount Of Data From The Table......
I need to delete data from a particular table which has more than half a million records. The data needs to be deleted is more than 200,000 records from the table. What is the best way to delete the data from the table other than importing into a temporary table and performing the same operation?

Let me know if the strategy to be followed is okay.

1. Drop all the triggers
2. Drop all the indexes
3. Write a procedure with a loop setting ROWCOUNT to 1000 and delete the records. ( since if I try to delete all the rows it will give timeout error )
The above procedure will delete 1000 records for each batch inside the loop till it wipes out all the data for the specified condition.
4. Recreate Indexes and Triggers.

Please let me know if there are any other optimal solution.

Thanx,
Zombie

View Replies !   View Related
Deleting The Master Table Withour Deleting The Child Tables
Hi
i have to delete the master table data without deleting the child table records,is there any solution for this,  parent table has relation with the child table.
regards
vinod.t.v

View Replies !   View Related
Deleting Data From Sql 2005 Table But No Resource Released
 

I'm Working in a Simple picture Gallery  On My web site.
When I add my pictures To the table Using Binary Writer and Delete
]

DELETE FROM [Photos]

WHERE [PhotoID] = @PhotoID
 
 It From My Table this Transact Delete the Pictures
but After some work I found That My database File size is increassing  day To day I'm very confused
so please tell me where is the problem ?

View Replies !   View Related
Query To Return Records Where One Table Is Void Of Linked Data In Another Table
I have two tables that share a common identity row.  I need to build a query where data that exists in one table does not contain data in the other table.  For example, table 1 has columns of Owner_ID, LastName, FirstName and table 2 has columns Auto_ID, Owner_ID, AutoMake.  Both tables are joined by the Owner_ID column.  I need a query that provides all owners from table 1 who do not have an entry in table 2.
 
Thanks in advance,
 
Mark

View Replies !   View Related
Data Into Linked Table
Hey there!  I've take a look around the forum and didn't find anything about my problem.  The SelectCommand of my SqlDataSource get data from 3 tables. SqlDataSource.SelectCommand = "SELECT [sa_Profil].[ID], [Nom], [Prenom], [Telephone], [ID_Reference], [ID_Appel], [Nom_Reference], [Type_Appel] FROM [sa_Profil], [sa_Suivi], [sa_Reference], [sa_Appel] WHERE [sa_Profil].[ID] = [ID_Profil] AND [ID_Reference] = [sa_Reference].[ID] AND [ID_Appel] = [sa_Appel].[ID]"   How can I wrote my InsertCommand & UpdateCommand ? I mean, INSERT INTO Table1 Table2 ... doesn't exist ... Thanks for your help! 

View Replies !   View Related
Running A Distributed Query Against A Loopback Linked Server In SQL Server 2005 Is Not Supported
I receive the following error message when I run a distributed query against a loopback linked server in SQL Server 2005:
The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
 
To resolve this problem, I was told that running a distributed query against a loopback linked server is not supported in SQL Server 2005. And I am suggested to use a remote server definition (sp_addserver) instead of a linked server definition to resolve this problem. (Although this is only a temporary resolution, which will deprecate in Katmai)
 
However, I run into another problem when I use the remote server definition. I receive the following error message:
Msg 18483, Level 14, State 1, Line 1
Could not connect to server 'ServerNameSQL2005' because '' is not defined as a remote login at the server. Verify that you have specified the correct login name.
 
Could anyone please help me out?
(I include the reproduce steps for the first error message, followed by my resolution that generates the second error message)
======
Reproduce steps for the first error message
======


On the ComputerAInstanceA instance, run the following statement to create a database and a table:
CREATE DATABASE DatabaseA
GO
USE DatabaseA
GO
CREATE TABLE TestTable(Col1 int, Col2 varchar(50))
GO
INSERT INTO TestTable VALUES (1, 'Hello World')
GO

On the ComputerBInstanceB instance, run the following statement to create a database and a table:
CREATE DATABASE DatabaseB
GO
USE DatabaseB
GO
CREATE TABLE TestTable (Col1 int, Col2 varchar(50))
GO

On the ComputerAInstanceA instance, create a linked server that links to the ComputerBInstanceB instance. Assume the name of the linked server is LNK_ServerB.

On the ComputerBInstanceB instance, create a linked server that links to the ComputerAInstanceA instance. Assume the name of the linked server is LNK_ServerA.

On the ComputerBInstanceB instance, run the following statement:
USE DatabaseB
GO
CREATE PROCEDURE InsertA AS
    BEGIN
        SELECT * from LNK_ServerA.DatabaseA.dbo.TestTable
    END
GO

On the ComputerAInstanceA instance, run the following statement:
USE DatabaseA
GO
INSERT INTO TestTable
EXEC LNK_ServerB.DatabaseB.dbo.InsertA
GO
Then I receive the first error message.
 
=======
My resolution that generates the second error message
=======


On the ComputerBInstanceB instance, run the following statement:
sp_addserver 'ComputerAInstanceA'
GO
sp_serveroption 'ComputerAInstanceA', 'Data Access', 'TRUE'
GO
USE DatabaseB
GO
CREATE PROCEDURE InsertA AS
BEGIN
    SELECT * FROM [ComputerAInstanceA].DatabaseA.dbo.TestTable
END
GO

On the ComputerAInstanceA instance, run the following statement:
USE DatabaseA
GO
INSERT INTO TestTable
EXECUTE [ComputerBInstanceB].[DatabaseB].[dbo].[InsertA]
GO
Then I receive the second error message.

View Replies !   View Related
Query To Get Linked List Kind Of Data From The Table
hi Experts,

 

I have a Issue table which stores the below data for many issue. some issue are duplicate to other and they are stored in a field Duplicate_of









ID
Duplicate_of 
State

77637
65702
Duplicate

65702
42217
Duplicate

42217
-
Verified

i wanted to write a query or some stored procedure when passed 77637 should help me get 42217.

 

Hint : 77637 when passed has field Duplicate_of which point to 65702 and his state will be Duplicate, 65702 will be duplicate to 42217 and state will be duplicate and 44217 is not duplicate to anything and state will be other then Duplicate

i appreciate if somebody can help me think in some line to give me some idea.

 

/soni

View Replies !   View Related
Query To Get Linked List Kind Of Data From The Table
hi Experts,

 

I have a Issue table which stores the below data for many issue. some issue are duplicate to other and they are stored in a field Duplicate_of









ID
Duplicate_of 
State

77637
65702
Duplicate

65702
42217
Duplicate

42217
-
Verified

i wanted to write a query or some stored procedure when passed 77637 should help me get 42217.

 

Hint : 77637 when passed has field Duplicate_of which point to 65702 and his state will be Duplicate, 65702 will be duplicate to 42217 and state will be duplicate and 44217 is not duplicate to anything and state will be other then Duplicate

i appreciate if somebody can help me think in some line to give me some idea.

 

/soni

View Replies !   View Related
List Of Table Name That Not Supported By SQL Database ???
Is anyone know about waht type of table or database name

that not supported or will have error during execution of SQL statement

in SQL or MS Access database. For my, I know only two ,

i.) cannot put table name that same as the the database name

ii.) cannot put database name like "RETURN", "POSITION",etc.

Is there any reference site that show out a list of table about the

table or database name ??? Thank You ... :)

View Replies !   View Related
'Use Encryption For Data' Is Not Supported
The error in the subject line "The property 'Use Encryption for Data' is not supported" is encountered when running a DTS package via a job step in SQL Server 7.0. The problem is not encountered when executing the DTS package interactively via Enterprise Manager from my PC. When I view the Advanced Properties of the OLE DB driver from Enterprise Manager on my PC, I notice a Use Encryption for Data Property. When I view the Advanced Properties of the OLE DB driver from Enterprise Manager on the Server, the Use Encryption for Data Property does not appear. Service Pack 3 for SQL 7.0 is installed on both my PC and on the SQL Server. I suspect this Property difference for OLE DB could be related to the fact that I installed Enterprise Manager for SQL 2000 on my PC at one time and then uninstalled. Any ideas how to correct this situation?

View Replies !   View Related
Data Type Not Supported Issue.
EXEC master.dbo.sp_addlinkedserver @server = N'DM', @srvproduct=N'DM Association', @provider=N'MSDMine', @datasrc=N'ray620', @catalog=N'DM Association'

select * from openquery (DM,'SELECT * FROM [Model Association TB].Content where NODE_TYPE = 8;')

Msg 7354, Level 16, State 1, Line 2

The OLE DB provider "MSDMine" for linked server "DM" supplied invalid metadata for column "NODE_DISTRIBUTION". The data type is not supported.I'm getting an error with the metadata. Appreciate any assistance. Thank you in advance.

View Replies !   View Related
Import From INFORMIX (Cannot Get The Supported Data Types)
Hi!

I'm trying to import data from an Informix Database to my SQL Server 2005 database with the import/export wizard.
I have an ODBC-connection that works, Access fetches data with no errors.  From the wizard I can only choose to use the IBM Informix OLE DB Provider as datasource. As fare as I know the OLE DB Provider is using settings from the ODBC-driver?

In SQL Server 2000 there is a posibillity to choose Other(ODBC provider) as datasource which works against this database. Any ideas how i can use an ODBC-datasource?

If I try to use the IBM Informix OLE DB Provider I get an error message after the first step of the wizard:

Cannot get the supported data types from the database connection "Provider=Ifxoledbc;Password=;Persist Security Info=True;User ID=uid;Data Source=db@server".

------------------------------
ADDITIONAL INFORMATION:

IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002).
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002). (System.Data)

------------------------------

Anyone have any experience with this problem? I can't find any information that will solve this, but I have seen several questions about this.

I would be very grateful for some help!

Best Regards

View Replies !   View Related
Data Conversion Supported On Standard Edition?
I created an Integration Services Package that runs fine from my local computer using BIDS.  However when I imported into our SQL Server and try to run it from there I get the following error:

 

DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Data Conversion"

 

We are running SQL Server 2005 Standard Edition 64-bit. 

 

We have integration services installed on the server.  Is data conversion something that is not supported on Standard Edition? 

 

Also have a similar message for "Send Mail Task." 

 

Is there anywhere that outlines what features are supported on each version? 

View Replies !   View Related
MySAP Business Suite ERROR: Table Class INTTAB Is Not Supported.
Hi there,

we collect data from SAP via the Data Provider for MySAP Business Suite.
Everything works fine for Standard objects like KNA1 etc. but if we try to read data from a custom table we get the following error:





Code Snippet

Fehler bei Get ZZEUSGRP_WA [SAP ZZEUSGRP_WA [1]]: Microsoft.Adapter.SAP.SAPManagedProviderException: Table class INTTAB is not supported.
bei Microsoft.Adapter.SAP.SAPSelectHandler.CheckResult(SAPTable returnTab)
bei Microsoft.Adapter.SAP.SAPSelectHandler.ExecuteSelect(SAPTable tabFields, SAPTable tabStruct_Tab....
The error message tells me not to use a specific table type. So far so good.
The question is: What would be the workaround? What should I tell the SAP team who cares for the data structures?

Thank you for your advice in advance
Fridtjof

View Replies !   View Related
Truncate Table In Linked Server Linked To (MS Access)
Dear Experts,

when i try to truncate table in the linked server ( linked to MS Access database) like:
truncate table LSchools...Payment
it will give the error:
maximum number of prefixes. The maximum is 2

when i use the statement like :

delete from LSchools...Payment

it will give the error like

File sharing lock count exceeded. Increase MaxLocksPerFile registry entry

( where payment may have more than 100.000 records)

I increase the MaxLocksPerFile to 120.0000 on the server registry

it works , but it is taking long time to execute.

1.Is there a way to use truncate?
2.Is there a way to execute MS ACCESS Query from (query analyzer), like ('Delete * from payment') where this is fast and no record locking encountered

Many Thanks

View Replies !   View Related
Gridview - Updating Is Not Supported By Data Source 'SqlDataSourceGridView' Unless UpdateCommand Is Specified
 Hi all,I have a gridview that bound to a SqlDataSource called SqlDataSourceGridView. I have enabled Edit in my GridView, but I do all the updating in code behind with stored procedure (using onRowUpdating). Now each time when I click "Update", the update went through and all the data got updated, but I received this error: Updating is not supported by data source 'SqlDataSourceGridView' unless UpdateCommand is specified.



Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.

Exception Details: System.NotSupportedException:
Updating is not supported by data source 'SqlDataSourceGridView' unless
UpdateCommand is specified. What do I need to do to fix this problem?Thanks a lot. 

View Replies !   View Related
Could Not Find Installable ISAM
  Hello, can u plz tell me why this error come and what is the solution of this error....  i m trying to impot data from excel sheet into SQl Server database.protected void Button1_Click(object sender, EventArgs e)    {        try        {            string excelConnectionString = @"Provider = Microsoft.Jet.OLEDB.4.0;DataSource=C:Documents and SettingsBonerich44Desktopusername.xls;Extended Properties=8.0";            //create connection to the excel workbook            using (OleDbConnection connection = new OleDbConnection(excelConnectionString))            {                OleDbCommand cmd = new OleDbCommand("Select * from [Sheet1$]", connection);                connection.Open();                //create DBreader to DataWorksheet                using (OleDbDataReader dr = cmd.ExecuteReader())                {                    //SqlServer connection string                    SqlConnection myconnection = new SqlConnection();                    myconnection.ConnectionString = "server=SYS20;database=Instantmessenger;userid=sa";                    myconnection.Open();                    //bulkcopy to SqlServer                    using (SqlBulkCopy bulkcopy = new SqlBulkCopy(myconnection))                    {                        bulkcopy.DestinationTableName = "username";                        bulkcopy.WriteToServer(dr);                    }                    myconnection.Close();                }            }        }        catch (Exception ex)        {            Response.Write(ex.Message);        }        finally        {        } 

View Replies !   View Related
Could Not Find Installable ISAM
Pls Can someone tell me why this code is giving me "Could not find installable ISAM"
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadDim strConn As New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & Server.MapPath("~/App_Data/WK 48-2007.xls") & ";" & "Extended Properties=""EXEL 8.0;HDR=YES""")strConn.Open()Dim StrSelect As String = "SELECT * FROM [Sheet1$]"Dim Comm As New OleDbCommand(StrSelect, strConn)Dim reader As IDataReader = Comm.ExecuteReaderGRD.DataSource = readerGRD.DataBind()reader.Close()strConn.Close()End Sub

View Replies !   View Related
Could Not Find Installable ISAM.
Hello,
I am trying to get VB to take the information from an Excel and upload to a SQL database.  This is my code:
Dim exlConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Extended Properties=Excel 8.0; Data Source=c:inetpubwwwrootPartsDBApp_DataPNINFO.xls")Dim exlCmd As New OleDbCommandexlConn.Open()exlCmd = New OleDbCommand("SELECT * INTO [Provider=MSDASQL;Driver={SQL Server};" & _"Server=localhost;Database=parts;" & _"UID=waiguest;PWD=wai].tbl_partstable FROM [PN INFO$]", exlConn)exlCmd.ExecuteNonQuery()exlConn.Close()
And it gives me this error:
Could not find installable ISAM.
How do I fix this?
Thanks,

View Replies !   View Related
Cannot Find Installable ISAM
Hi All,

I am trying to create a DTS package through EM Wizard. It is trying to get data from a table into an Excel. While doing so , it gives an error Error Source : Microsoft Jet Database Engine
Error : Could Not Find Installable ISAM

Can some one please help !!
Thanking you in advance.

Regards

Nat

View Replies !   View Related
Could Not Find Installable ISAM
I'm new here and this is my first post. I am not sure if this is the right place for me to post this problem but I really need your help guys. I've been looking for a solution of this problem for almost a week now. I'd googled a lot but of no result.

What I want to do is to import records from access 2000 database to SQL 2005 Express. I use the following statement to import records:

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Data Source="D:SamplesMydatabase.mdb";User ID=Admin;JET OLEDB:Database Password=mypass', 'tblTab1')

The following error shows:

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

I dont know if the statement is correct or I am missing something. I had reinstalled my MS Access but this does not help either. By the way I'm using Access 2003 and my database is 2000 access version.

Hope somebody can help me get out of this.

thanks,
bodjo

View Replies !   View Related
Can Not Find Installable ISAM
Installed Office 2007 and I am trying to develop an import by developing a Integration Project.  If I use SQL2005 to import the data to create the table or I try to develop the Integration Project I keep getting a Can not find installable ISAM.  I have tried to update the MDAC but either the SP is not supported in XP SP2 or it would do anything since there is a later version already installed.  This is the same when I try and install / update the Jet database engine.(4.0).  Does anyone have a clue, the only thing I can find info on is Access and other db's.  This appears to be a product issue but which one I don't know.

View Replies !   View Related
Archive Data Instead Of Deleting It To Prevent 4GB Data Limit
We are running SQL Server 2005 express on Windows 2003. The database server gets significant amounts of data.

 

Because of the 4GB data limit we have a daily cron task which goes through and deletes data older then 90 days.

 

We would like a way to archive this data instead of deleting it. Is there any way to take data and compress it and store it in a different way, so that if needed, customers can query directly out from the compressed data? Cleary querying from compressed would be slower but that is ok.

 

Any other solutions that would allow us to archive data instead of deleting it? Thanks.

View Replies !   View Related
Code Page Translations Are Not Supported For The Text Data Type. From: 1252 To: 950.
Code page translations are not supported for the text data type. From:1252 To: 950.I would like to know what this message means. I also installed thelanguage packs in advanced settings, Everything is set to English. Mywindows XP computer is XP English. For some reason I cant get an updateto go thru using ADO. like Recordset.UpdateAlthough other routines using .update workAny ideas?

View Replies !   View Related
Unable To Find Installable ISAM
I have a program written in VB 6.0 using ADO 2.0 to connect to SQL 6.5 and a Foxpro file linked thru Access. It was working fine until I installed the Desktop version of SQL Server 7.0 and now the same program I get an error message when trying to connect to the Foxpro file linked thru Access "Unable to find installable ISAM". Any ideas of what could cause this?

View Replies !   View Related
Error - Could Not Find Installable ISAM
First, let me state this is no longer an error, rather I wanted to share this experience with you. Primarily due to the fact I could not find any reference to this specific situation via Google, etc.

Scenario
SQL Server 2005
We have a linked server that points to xbase files on a local drive to the SQL database. This linked server is used to pull in data on a daily basis from a legacy XBase application. This setup has been in use for quite some time and once in awhile any query request using the linked server throw this exception:

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "<somelinkedservername>".
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "<somelinkedservername>" returned message "Could not find installable ISAM.".

So I started digging into this and tried a few things. First, I attempted to drop and recreate the linked server. That was wishful thinking at best and, of course, the error still persisted. Then I noticed something very odd on the database. We had 80+ connections open from the Idera diagnositics software. These connections went back to the prior day at approximately 6 AM and every scheduled interval since. A quick DBCC INPUTBUFFER showed me they were making many calls to the WMI services on the machine. I shut down Idera and tried to kill all the connections and they just sat there in a KILLED/ROLLBACK state for over an hour (while I looked into the issue). Finally, I attempted to stop the WMI service and it gets stuck in a 'Stopping' state. Well, this tells me it's truly hung up for some reason. Eventually I used Sysinternals Process Explorer to identify the process and kill it manually. Once I restarted the service the linked server began working w/o an issue.

With this in mind, I assume that the SQL Server utilizes a WMI provider for this type of situation (access to a dbase IV file on the local file system). As far as to why the WMI service became nonresponsive, I don't know why it did this right now. I speculated that perhaps the Idera product was causing it with not releasing all the COM resources (it used sp_OA procedures to call into WMI) but since I don't have the complete source I can not confirm.

View Replies !   View Related
Deleting A Table
i have a table that i think is bad -
how do i delete the table?
also i want to copy this same table from another database -
can i use enterprise manager to copy the same table in place of the deleted table?

View Replies !   View Related
Deleting Row From Table
Hi guys,

I have a table which consist of 6,185 rows and from this table I want to delete 427 rows. I have placed the 427 rows in a separate table. So how do I delete these 427 from the original table(6185 rows).

I should also mention that the table does not have a primary key so I was thinking about something like this but it didn't work


delete o.CardNumber
,o.ref_no
,o.tran_date
,o.tran_val

from test6185 o

where exists (select h.CardNumber
,h.ref_no
,h.tran_date
,h.tran_val
from test427 h
where( h.ref_no=o.ref_no and
h.CardNumber = o.CardNumber and
h.tran_date =o.tran_date and
h.tran_val =o.tran_val
))

order by cardnumber


Thank much for any help

View Replies !   View Related
Deleting Existing Data Before Loading New Data
I have a package which loads data from a flat file (csv) to 4 tables in a database.
Now, the load is incremental.

I want to clear the data of all 4 tables(in the database) before loading the data from flat file everytime.How can i do this?
Iam using 4 Oledb Destinations, 1 multicast, 1 source component to do this.
Also can it happen like a transaction? because if it deletes the existing data and couldnt load new data there will be a problem!.how to avoid this?

View Replies !   View Related
Import From Excel - Could Not Find Installable ISAM
I'm trying to quickly create a way of importing data from an excel sheet on my C drive to a table on a sql 2005 db hosted by a provider.
I set this up according to the following: 
http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx
The article is in C# but I write in VB.  I think I got it except I get this error:
Could not find installable ISAM.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.OleDb.OleDbException: Could not find installable ISAM.Source Error:



Line 23: Dim command As Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand("Select ID,Data FROM [Data$]", connection)
Line 24:
Line 25: connection.Open()
Line 26:
Line 27: ' Create DbDataReader to Data Worksheet
 Microsoft is not much help.  A couple of folks say to contact my host.  Before I do I just want to be sure there code I have is correct.
 Could someone take a quick look at this.
Thanks,
Here is the code behind the button.
 Protected Sub BTNImport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNImport.Click
' Connection String to Excel Workbook
Dim excelConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Book1.xls;ExtendedProperties=""Excel 8.0;HDR=YES;"""
' Connection to Excel WorkbookUsing connection As Data.OleDb.OleDbConnection = New Data.OleDb.OleDbConnection(excelConnectionString)Dim command As Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand("Select ID,Data FROM [Data$]", connection)
connection.Open()
' Create DbDataReader to Data WorksheetUsing dr As Data.Common.DbDataReader = command.ExecuteReader()
' SQL Server Connection StringDim connectionString As String = ConfigurationManager.ConnectionStrings("HbAdminMaintenance").ConnectionString
'Origina from David Hyden's site - Dim sqlConnectionString As String = "Data Source=.;Initial Catalog=Test;Integrated Security=True"
' Bulk Copy to SQL ServerUsing bulkCopy As Data.SqlClient.SqlBulkCopy = New Data.SqlClient.SqlBulkCopy(connectionString)
bulkCopy.DestinationTableName = "ExcelData"
bulkCopy.WriteToServer(dr)
End Using
End Using
End UsingEnd Sub
 
 

View Replies !   View Related
System.Data.SqlClient.SqlException: The Locale Identifier (LCID) 16393 Is Not Supported By SQL Server
I have SQL Server 2005 Developer Edition. And my operating system is Windows Vista.
 
I have written a procedure in C# and deployed it on SQL Server. However when i try to run it i get the following error.
System.Data.SqlClient.SqlException: The locale identifier (LCID) 16393 is not supported by SQL Server
 
Also I tried using same procedure in Windows XP machine and it workd fine. Can anyone help me what could be the problem?

View Replies !   View Related
Deleting From SQL Table Using Two Arguments
I am trying to delete from a SQL table using two arguments, I currently use the following on the aspx page: <ItemTemplate><asp:LinkButton ID="cmdDeleteJob" runat="server"  CommandName="CancelJob" Text="Delete" CssClass="CommandButton" CommandArgument='<%# Bind("Type_of_service") %>'                       OnClientClick="return confirm('Are you sure you want to delete this item?');"></asp:LinkButton></ItemTemplate>  and then I use the following on the aspx.vb page: If e.CommandName = "CancelJob" Then                Dim typeService As Integer = CType(e.CommandArgument, Integer)                Dim typeDesc As String = ""                Dim wsDelete As New page1                wsDelete.deleteAgencySvcs(typeService)                gvTech.DataBind()  I need to be able to pick up two CommandArguments. 

View Replies !   View Related
Deleting Columns From Table
in sql server 2000, I have a table that I have to write a script for to delete several columns in this table.  I am finding that I have to use alter or drop keywords or a combination of the two but not sure because I have not done this before.  I am googling this but finding all kinds of other information that I dont' need to know.
I dont have rights on this table so I cannot do this manually.  I have to create the script and send it on to someone else.
If anyone can provide a good script example that I can use to delete unwanted columns it would be a great thing.  Thanks.

View Replies !   View Related
Trigger For Deleting Row From Same Table.
Hello everybody,
I have problem deleting row from same table using below trigger

CREATE TRIGGER [tDeleteDomain] ON dbo.iMS_Domains
FOR DELETE
AS
IF @@RowCount > 1
BEGIN
ROLLBACK TRAN
RAISERROR ('You can only delete one domain at a time.', 16, 10)
END
DECLARE@DomainID int
SELECT@DomainID = ID
FROMDELETED
DELETE FROMiMS_Domains
WHEREAliasFor = @DomainID

If I am using this trigger I am getting the below error
Server: Msg 217, Level 16, State 1, Procedure tDeleteid, Line 16
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

Can anybody give good suggestiong regarding this.

Thanks,
ravi

View Replies !   View Related
Deleting All Rows In A Table
hello there,
what is the code to Delete all rows in a Table????

thanks in advance

View Replies !   View Related
Need Help Deleting Rows In A Table
I need to delete some specific rows in Table1
 
int1 must have the value 1
int2 must have the value 1
int3 must have the value 0
and now we get to the difficult part - first character in the field [Cost No] have to be different from the letter 'B'. [Cost No] have the datatype varchar(20)
 
I expected the code to look something like this:
DELETE Table1
FROM    Table 1
WHERE  ([Int1] = 1) AND ([Int2] = 1) AND ([Int3] = 0) AND ((LEFT([Cost No]), 1) <> 'B')
 
But I get this error message:
The left function requires 2 arguments
 
What am I doing wrong and what should the right code look like?

View Replies !   View Related
Deleting Data From DB
I have edited the aspnet_Users_CreateUser stored procedure so that the UserId that is created when a new user is created is copied to a UserId field in another table. However, when I use the website administration tool to delete users that have been created, it gives me an error saying the delete statement conflicted with the reference constraint. I then added the following code in the aspnet_Users_DeleteUser procedure....
IF ((@TablesToDeleteFrom & 16) <> 0 AND
(EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_tt') AND (type = 'V'))))
BEGIN
DELETE FROM dbo.userclassset WHERE @UserId = UserId
SELECT @ErrorCode = @@ERROR,
@RowCount = @@ROWCOUNT
IF( @ErrorCode <> 0 )
GOTO Cleanup
IF (@RowCount <> 0)
SELECT @NumTablesDeletedFrom = @NumTablesDeletedFrom + 1    hdhd
END
This code was then added to the function at the end which deletes the data from the aspnet_Users table when everything else has been removed
(@TablesToDeleteFrom & 16) <> 0 AND
Now when I delete a user in the website admin tool, it "deletes" (with no error) the user from the list but doesnt actually physically delete it from the database.
Any ideas?
 

View Replies !   View Related
Deleting All Data
Is there a way to delete all data from a database - all tables and alltables excluding system tables?sqlserver 2000?Thanks,Tmuld

View Replies !   View Related
One Or More Columns Do Not Have Supported Data Types, Or Their Data Types Do Not Match.
 

Hi,
 
I´m exporting an ms-excel file, then I use a lookup transformation to get a field from a SQL Server 2005 table. The Lookup transformation editor, after selecting the table, shows a warning that says:
 
at least one  mapping between a column from available input columns ans a column  from available lookup columns must be defined on the  columns page.
 
So I try to make a relationship in the Lookup transformation editor's column tab where I find the Available input columns and the available lookup columns but I get the following error:
 
The following columns cannot be mapped:
[Department, DEP_CLEGALCODE]
One or more columns do not have supported data types, or their data types do not match.
 
The field in SLQ Server is varchar(10) and the input field is a derived column transformation; I have tried different Data Types but I always have the same error.
 
The DataFlow is: ExcelSource --> Derived Column -->  Lookup --> Flat file destination
 
thanks.
 

View Replies !   View Related
Deleting Records In Associated Foeign Key Table
Hi, i need the suggestion here in very familiar db situation ..i have a main table and a primary key of that table is used in many other table as foreign key.If i am deleting a record in a main table,how do i make sure that all the corresponding record in the associated tables,where that foreign key is used, gets deleted too?What are my options?Thanks

View Replies !   View Related
Deleting Duplicate Rows In SQL Table
I have an SQL tables [Keys] that has various rows such as:
[ID] [Name] [Path] [Customer]
1 Key1 Key1 InHouse
2 Key2 Key2 External
3 Key1 Key1 InHouse
4 Key1 Key1 InHouse
5 Key1 Key1 InHouse

Obviously IDs 1,3,4,5 are all exactly the same and I would like to be left with only:
[ID] [Name] [Path] [Customer]
1 Key1 Key1 InHouse
2 Key2 Key2 External


I cannot create a new table/database or change the unique identifier (which is currently ID) either. I simply need an SQL script I can run to clean out the duplicates (I know how they got there and the issue has been fixed but the Database is still currently invalid due to all these duplicate entires).

Any help would be greatly appreciated.
Thanks,

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved