The Requested Properties Cannot Be Supported. Error '80040e21'
Jul 12, 2007
Hi,
I get this error "sometimes" on sql server 2000 (
The requested properties cannot be supported. error '80040e21'
when running the code below multiple times.
Any solutions for this ?
thanks in advance
gr.
Peter
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Mode = 3 '1 = adModeReadOnly
Conn.Open ConnectString
SqlSend= "Select top 30 * from tab1 WITH (UPDLOCK,readpast) where x<>'' and RecordNumber > 6200000 and Status= 2 and processed <> 3 ORDER BY RecordNumber"
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Cursortype=0
rs.Cursorlocation =2
rs.LockType= 3
rs.Open SqlSend, Conn < here it gives the error
I have a strange issue on my local test environment (Win XP Pro SP 2 - SQL server 2000 with SP4 and IIS 5.1 ), where I get an error in the Select statement if I do not include the database owner prefix, like "select * from patients where PID< 200".
If I change it to "Select * from hprs.patients where PID<200" it works fine.
However, in more complex SQL, where I have joins, and sub queries, I still get errors on my local test machine, but the live server works fine.
I use the calls in classic ASP pages on a web site and I did not get this before, only after I re-instaled SQL Server 2000 to fix another issue I had on my machine.
On the live server (also SQL Server 2000) I do not get the error.
Is there a setting I can change on my local dvelopment environment so that it is not a requirement to include the DB owner in the SQL?
Any help with this will certainly save me a lot of re writing tons of SQL so I can still test before publishing.
I have a DTS that pulls data in from a table in MysQL and inserts it into a tablle in SQL Server. it's failing when I run the step with the "requestd conversion is not supported" error, but when testing each single column copy in the Data Transformation step, it passes.
I just want an exact copy of the data.
the source MySQL table is....
CREATE TABLE `entry` ( `web_id` int(11) NOT NULL auto_increment, `web_name` varchar(40) NOT NULL default '', `web_email` varchar(60) NOT NULL default '', `web_cli` varchar(50) NOT NULL default '', `web_pu_id` varchar(60) default NULL, `web_answer` varchar(60) NOT NULL default '', `web_ddi` varchar(30) default NULL, `web_time_entered` datetime NOT NULL default '0000-00-00 00:00:00', `web_ip_address` varchar(20) default NULL, `web_entry_status` set('failed','success') NOT NULL default '', `web_polled` enum('true','false') default 'false', PRIMARY KEY (`web_id`) ) ENGINE=MyISAM;
and the SQl Server destination is....
CREATE TABLE [entry] ( [web_id] [int] NOT NULL , [web_name] [varchar] (23) NOT NULL , [web_email] [varchar] (37) NOT NULL , [web_cli] [varchar] (15) NOT NULL , [web_pu_id] [varchar] (15) NULL , [web_answer] [text] NOT NULL , [web_ddi] [varchar] (11) NULL , [web_time_entered] [datetime] NOT NULL , [web_ip_address] [varchar] (15) NULL , [web_entry_status] [varchar] (15) , [web_polled] [varchar] (15) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
ALTER TABLE [temp_webentry] WITH NOCHECK ADD CONSTRAINT [PK_tmpwebentry] PRIMARY KEY CLUSTERED ( [web_id] ) ON [PRIMARY] GO
I am using SQL Server 7 on the database server. And running ASP on the 2 web servers. I am currently getting this error on a couple of my pages. This was not happening on the dev. server, only when testing on the production server.
Here is the full error. <!----- Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. ------>
Set rsProduct = Server.CreateObject("ADODB.Recordset") rsProduct.Open cmdProduct, , adOpenKeyset, adCmdTable
I'm creating a command object with an ActiveConnection, adding a parameter to it, and then creating a recordset with the command.
The last line of code gives me the error, when I open the recordset. When I create this recordset using any of the records under 128, I don't get the error. The stored procedure returns 5 or 6 fields, one of which is the primary key called "ID".
I am starting to see this error appear randomly? This is on an application that uses ASP, but its been working fine for months... I'm using SQLExpress 2005 on Win2003 IIS6Microsoft SQL Native Client error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.I'm trying to figure out why its happening all of a sudden? Any ideas very appreciated...
I am using ATL COM library application. It is using sql data base for fetching the records. Some times, i get the following error. could you please let me know, why this happens? This is not reproduceble every time.
(Error! hr=80040e21, hrDesc=Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work
Here is the code to connect to database which i am using.
I am trying to install a SQL server 2005 database to merge with a sql mobile database on an emulator or pda.
I have installed SQL server 2005 and a copied an existing database and created the publications subscriptions that worked on another machine. As far as I can tell everything is ok with the installation. I can browse the url of the virtual directory ie.sqlcesa30.dll on the database server and from the pda emulator so I'm satisfied that part of the comms is OK.
Using the ?diagnostics feature indicates everything is OK
When I come the actually merge the databases I get error number 80072f76 (23635) with a message that the header is corrupt or missing. The odd thing is that this message refers to sql ce 2000, which is n't installed and that i'm not trying to use.
The application on the PDA that I'm using to carry out the merge worked ok on another system, I've done all the obvious things like check the database server name and ip address, the privaledges for the iusr_ and am now stuck.
Can anyone point me in the right direction or tell me what the 'header' in the error message refers to.
Two of my databases are still listed under the "Database" folder in SQL Express, yet all objects are now gone. Tried detach/attach and says it works OK - yet no tables, etc.
The odd thing is that I CAN access the tables from Visual C++ Express, and all looks well (data, etc).
When I look at Properties for one of the DBs, and then click on "View Connection Properties" under the "Options" section, the error message pops up:
"Cannot show requested dialog.---------------------------- ADDITIONAL INFORMATION:
Could not load file or assembly 'file:///C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlManagerUi.dll' or one of its dependencies. The system cannot find the file specified. (mscorlib) ".
Also still throwing an error upon startup, "Unhandled exception has occurred in a component in your application. If you click continue the application will ignore this error...Cannot create a stable subkey under a volatile parent"
Clues?
Thanks
S
PS It would help to enable right click Copy and Paste in this forum -
hi,i am trying to connect sql server 2005 from my asp.net applicationi have create DSN for this ..then i am getting the following errorKeyword not supported: 'dsn'. in sql serverplease provide me the solution
In SQL 7, when a view parses the below code, it generates a 'CASE is not Supported' error'; however, it will still generate and show the field with the CASE statements correctly; What might cause this error?
(Other useful info: this code is from a converted SQL 6.5 DB and the SQL 7 is running in compatibility mode, i inserted '' to remove concantenation of NULL problems;)
Example of display: 10132 Hampton, VA: A. Deepak Publishing
SELECT PublisherID, Info = CASE WHEN City IS NOT NULL THEN City + CASE WHEN State IS NOT NULL THEN ', ' + State ELSE '' END + ': ' ELSE '' END + Publisher FROM tblLibraryPublishers
When I opened the Microsoft SQL Server Management Studio(Administrator), the message below is shown up.
`C:Program FilesMicrosoft SQL Server1 10 ToolsBinnManagementStudioSQLWorkbenchProjectsSSMSEmptySqlProject.ssmssqlproj` cannot be opened because its project type (.ssmssqlproj) is not supported by this version of the application.
To open it, use a version that supports this type of project.
Below is the error I get when trying to convert a Visual FoxPro memo field to a DT_WSTR (4000 ) in a SQL table. It does not let me convert a DT_TEXT to a DT_WSTR.
The component is not in a valid state. The validation errors are: Error at NMF [Data Conversion [6328]]: Conversion from "DT_TEXT" to "DT_WSTR" is not supported.
Do you want the component to fix these errors automatically?
Using the full SQL Server 2005 patched up to build 9.0.3054.
Creating a simple maintenance plan to backup specific databases.
As soon as i try to save the plan i get the popup error :"no such interface supported". It won't allow me to save any plan at all regardless of what I put in there.
The first part of the install.sql ran ok, but it chokes on the CREATE ENDPOINT line: is this really a limitation on the Express edition or did I miss something on installation or configuration?
Msg 7878, Level 16, State 1, Line 3
This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.
I have tried reinstalling the sqlncl.msi - re-booting etc without success.
I'm on windows vista beta 2 build 5384.
Brand spanking new machine (less that 48 hrs old) and I can't beleive my bad luck with sql express. My xp pro machine works fine.
Hers's the error:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x15
------------------------------ BUTTONS:
&Retry Cancel ------------------------------
Here's the log:
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Professional (Build 5384) Time : Sat Jul 01 08:01:37 2006
Machine : JOHN-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : JOHN-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : JOHN-PC Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : JOHN-PC Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : JOHN-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
SQLSetup0001_JOHN-PC_SQLNCLI_1.log snippet (right at the end) says:
<snipped>
MSI (s) (AC:64) [20:59:38:014]: Product: Microsoft SQL Server Native Client -- Configuration failed.
MSI (s) (AC:64) [20:59:38:014]: Product: Microsoft SQL Server Native Client. Version: 9.00.2047.00. Language: 1033. Configuration change completed with status: 1603.
</snipped>
and at the end of SQLSetup0001_JOHN-PC_Core(Local).log
<snipped>
Running: ReportChainingResults at: 2006/5/30 20:59:42 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1706 Error Code: 0x800706aa (1706) Windows Error Text: The endpoint format is invalid.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Mon Jan 16 02:06:13 2006 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3245
Can anyone advise. I'm willing to take a "you'll have to re-build your machine" response if I have to. But I just need to know if this really is required.
I'm trying to create a few report models in Visual Studio to demonstrate the Report Builder tool and I'm encountering an issue when I try to generate a Report Model.
I get the error message "Specified Method Is Not Supported" when I click Finish on the Report Model wizard. The error detail is:
=================================== Specified method is not supported. (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.ReportingServices.ModelDesigner.Wizards.ChooseSemanticModelName.CreateSqlDsvStatisticsProvider(IDbConnection connection) at Microsoft.ReportingServices.ModelDesigner.Wizards.ChooseSemanticModelName.BuildModel()
Steps to reproduce: 1. Create a new Report Model project in Visual Studio 2005 against SQL Server 2005 2. Create a new data source. The data source was tested and works correctly 3. Create a new data source view. The data source view was also tested (clicked on Explore Data) and I was able to look at the data in the view 4. Right-click on Report Models and select "Add New Report Model" 5. Click next at the welcome screen 6. Select the data source view created in #3 7. Leave the selected options for report model generation rules for creating the data source view (Create Entities for all Tables, Create Count Aggregates, Create Attributes, Create Attributes for auto-increment columns, Create date variations, Create numeric aggregates, Create date aggregates, Create roles were all selected) 8. Click next 9. Select Update Model Statistics Before Generating (default option) 10. Click next 11. Click Run
Once I click run it processes for approx 3 seconds and then returns the error above.
If anyone could help me I'd appreciate it. Microsoft hasn't published any details on the namespace and I'm not sure why I'd be getting the error I am.
I've run into a bit of a database connection problem. I'm trying to connect to a SQL Server database. It compiles okay, but then while IE is loading, I get an exception error pointing out in the code saying 'Keyword not supported: 'provider'.
Hi all,At this moment I'm trying to get database mail working. According tosome people it should be easy. Well...that is not the case for me.I'm having the following error:The mail could not be sent to the recipients because of the mail serverfailure. (Sending Mail using Account 2 (2006-11-24T08:48:15). ExceptionMessage: Cannot send mails to mail server. (Command not implemented.The server response was: Command not Supported).)SQL Server 2005 is installed on a separate server and the SMTP Serveris Lotus Notes. connecting with port 25.Start and stopping the SQL Server and SQL Server agent i tried already.i tried sysmail_stop_sp and sysmail_start_sp.Sometimes when starting or stopping the Mail with the followingcommands :exec sysmail_stop_spGOexec sysmail_start_spGOI will get the following error:Msg 233, Level 20, State 0, Line 0A transport-level error has occurred when sending the request to theserver. (provider: Shared Memory Provider, error: 0 - No process is onthe other end of the pipe.)So any help would be appreciated.Hennie
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?
fix the below SP which is having cursor output with an alternate logic which can make the SP work.(may be using temp table or any other option)
CREATE PROCEDURE Get_IDS /* * SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. */ @p_uid float(53), @return_value_argument varchar(8000) OUTPUT
Cannot open database "QuoteSystem" requested by the login. The login failed.Login failed for user 'NT AUTHORITYNETWORK SERVICE'. Last time I recieved this error I had to add ASPNet, NTAuthority, and myWebSiteUsers USERS under the database properties-->permissions setting for the specific database I am trying to access with the website but this database(QuoteSystem) does not lists any of these objects so I can add them. Does anybody know what I have to do to fix this? I am using SQL Server 2005.
Please, can anyone tell me why I am getting the undermentioned error message when I develop my application as an IIS Site in Visual Web Developer 2005 Express ? I have already developed and successfully tested it as a 'FileSystem Web Site' .I am using SQLSErver Express 2005 edition and have which I have installed along with the Northwind database as per the download instructions. My IIS software is version 5.1 which I have checked and it is configured to allow Integrated Windows Authentication. the relevant code is (1) web.config file connection strings <connectionStrings> <add name="NorthwindConnectionString" connectionString="Data Source=.sqlexpress;Initial Catalog=Northwind;Integrated Security=True" providerName="System.Data.SqlClient"/> </connectionStrings>(2) the grid view control and sqldatasource <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CategoryID" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="CategoryID" HeaderText="CategoryID" InsertVisible="False" ReadOnly="True" SortExpression="CategoryID" /> <asp:BoundField DataField="CategoryName" HeaderText="CategoryName" SortExpression="CategoryName" /> <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" SelectCommand="SELECT [CategoryID], [CategoryName], [Description] FROM [Categories]"> </asp:SqlDataSource>This is the full error message and details: Server Error in '/sqlservertest' Application.
Cannot open database "Northwind" requested by the login. The login failed.Login failed for user 'JERRY-3C9615BAAASPNET'. 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.SqlClient.SqlException: Cannot open database "Northwind" requested by the login. The login failed.Login failed for user 'JERRY-3C9615BAAASPNET'.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
When I select the database and right click. I receive the following error:
Cannot show requested dialog Additional Information:
Cannot show requested dialog (sqlMgmt)
Property Owner is not available for Database '[DB_name]'. This property may not exist for this object, or may not be retrievabledue to insufficient access rights. (Microsoft.SqlServer.Smo)
I have scripts to refresh database as SQL daily jobs. (O.S is Win2K3 and SQL server 2000 and SP4) It was worked and I got the following message this morning from SQL error log.
BackupMedium::ReportIoError: read failure on backup device '\XAPROD12MASTERXAPRODXAPROD_db_200701290000.BAK'. Operating system error 1450(Insufficient system resources exist to complete the requested service.).
