I am using Visual studio 2010, oracle 10g, Windows server 2008 (64 bit).
I am gettign followign error message when trying to verify datasource of crystal report from visula studio.
Steps. open report -> fields explore -> right click -> Verify datasoucrce -
> select data source, enter userid & password.
showig error message
Logon failed.
Details: ADO Error Code: 0x80004005
Source: Microsoft OLE DB Provider for Oracle
Description: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.
Error: Executed as user: MACSTEELUSA.COMsa. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:17 PM Error: 2010-06-02 20:00:18.56 Code: 0xC0202009 Source: CRM_ORACLE_ARSUMMARY Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.". End Error Error: 2010-06-02 20:00:18.58 Code: 0xC020801C Source: Data Flow Task Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireCon... The package execution fa... The step failed.
Tasks Taken:Went to this folder checked for tnsnames.ora file but it is in good shape.
This bug is very difficult to troubleshoot. I run 4 apps on the same server, all 4 are clones from the first one, just differ on their database connection. 2 run perfectly, but on two of them, when making a postback from a certain page, by clicking a button or by changing a datagrid page, it throws this error:
When I am running the web application in Visual studio 2010, i am getting the following error for the dll, Interop.Encryption.dll. I am not getting any compilation errors. Given reference to the dll Inerop.Encryption.dll in the web project.
System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {DA173F55-2740-4FF5-BC48-4A594AFF3579} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
I've got the problem with a simple e-mail form, it uses the simple.aspx and ASPEMAILLib.dll from the persits aspemail installation.The application is hosted on IIS 7, the application pool is a .NET 1.1. I followed the guide on http://blogs.iis.net/bills/archive/2008/06/02/installing-asp-net-1-1-with-iis7-on-vista-and-windows-2008.aspx
I am not able to understand what is the problem with My sql ..as same query is run sucessfully while i use SQL Server 2005 whit out any Exception or error.........
Select Count( Date ) From Attendancemaster Error in SELECT clause: expression near ')'. Unable to parse query text.
this is very simple query run sucessfully in SQL Server 2005 but not in
MY SQL and giving Error..and the query on which any datetime avar comes in WHERE clause allso generate error always....?
I'm developing and maintaining an ASP.NET web site.
The site is hosted at the 3rd party company running IIS6.
Recently the hosting service provider has setup an additional IIS server and moved part of the applications to this new server. This moment, my application is installed on both old and new servers.
Although the hosting provider claims that IIS configuration on the both servers is absolutely equal, I get the following exception on the new server, while on the old one everything works like a charm.
If I explicitly put an oracle connection in a Using{} block I know that it will call the Dispose() method when it goes out of scope. My question is will the OracleConnection object be disposed in the following code block:
[Code]....
The OracleConnection is implicitly within the Using{} block for the OracleCommand and goes out of scope at the same time.
I have a MySQL data at a web hotel. I can connect to the database from my web application hosted at the hotel . But trying to connect from a client application running on my PC fails using the same ConnetionString. The error is: Unable to connect to any of the specified MySQL hosts
In fact the method below (the method is protected in the web application) fails in my client application but works in my web application.
[code]....
I just tried to download WorkBench 5.2 and HeidiSQL, both connects to the database from my PC when supplying server and password information.
We have a spreadsheet that has a Zip column. These zip has a plus 4 digit in this format 99999-9999. When I looked at the format of this cell, it was a Special format with Zip+4 type. I just need to get the 5 digit zip code but the problem I am running into is the leading 0s. I tried =LEFT(A2, 5) but this trims the leading 0s. I also tried highligiting the column, then DATA -> Text to Columns -> Delimeter with hyphen but that didn't work. Is there any other way to do this or am I missing something on my first two attempts. Please let me know if you need more clarifications.
here's my error... Compiler Error Message: CS1502: The best overloaded method match for '_Default.InsertUpdateData(System.Data.SqlClient.SqlCommand)' has some invalid arguments
I'm using Microsoft Oracle Data Provider(System.Data.OracleClient). As soon as I get the string (SC1101E,B+,) in my input parameter, I get the below error:-
"ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
Strange, as this same query works completely fine with my SQL client/toad.
The database type is varchar2 with 2000 length. A lot of longer strings easily able to be updated. But as soon as above string get in the parameter, the code starts vomitting error.
I am working on an ASP.NET C# web application in Visual Web Developer Express 08', with MySql database.
Everything works just fine, except one problem that drives me crazy for few weeks...
My application randomaly (or not) stop responding, or just freezing for couple of minutes.
I am sure that the problem is connected somehow to my connection with MySql db.
In the debug window in VWD I get over and over the line:
"A first chance exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll"
Note that in each page load I call a function that kills all sleeping MySql connections, so I don't really think that my problem is 'too many connections'.
The error isn't constant, and not occures only in one page, it occures in many pages (that contains mysql access code), randomaly.
I am continuously getting error for following line of code. It work fine in other Database. ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver] Function name is missing. Am I doing any mistake [Code]....
I made a website with mysql back end, it all goes dandy on my dev machineI got all the connectors required, copied the dll files in bin.Now the iis server doesn't recognize drivers and give me this error ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified now the iis server got the drivers connector from mysql website andinstalled even the datamanager from webinstaller
I keep getting this error when inserting a lot of data into a mysql databaseERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.40-community]Got a packet bigger than 'max_allowed_packet' byte
I'm experiencing a really confusing error. Exactly every other time the page returns
ERROR [23000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Integrity constraint violation:uniqueness constraint violation (7518)and else it works nicely.
Here's the SQL:
SELECT SlsOrder.Orderdate, SlsLine.LineNum, CASE WHEN SlsLine.AllDelivered = 1 THEN 'X' ELSE '0' END AS 'AllDelivered', Item.ItemName, Item.TechName, SlsLine.IntDlvDate, SlsLine.OrderNum, SlsLine.ItemCode, SlsLine.Version, CEILING(SlsLine.Qty) AS 'Qty', Item.QtyUnit, ROUND((SlsLine.Price*SlsLine.Qty),2) AS 'rowSum', ROUND(SlsLine.Price,2) AS 'Price', IFNULL(SysText.InfoText, '-') AS 'InfoText' FROM PUB.SlsLine INNER JOIN PUB.SlsOrder ON (SlsLine.OrderNum=SlsOrder.OrderNum) INNER JOIN PUB.Item ON (SlsLine.ItemCode=Item.ItemCode) LEFT OUTER JOIN PUB.SysText ON (SlsLine.SlsLineKey=SysText.SysTextKey) AND SysText.NoteType = 'OrdConfRowE' AND SysText.ConsTxt = '' WHERE (SlsLine.OrderNum = '" & o & "') ORDER BY SlsLine.LineNum
I have a serious problem with "Error on Page". The error message points to line number 939, char 13. In my code behind (C#) in line number 939 is only an obsolete method found which is no longer called. The aspx file has only 339 lines. What the heck is line number 939?The Webapplication allows a special user group to change some group memberships for members of another user group in Active Directory. The App handles 3internal DataViews derived from corresponding DataTables as DataSource for 3 GridViews and some other internal lists with objects (List<obj>).
It uses windows authentication to get current users credentials and his membership in the "Operators" group. This credentials will be passed-through to allow the process managing group memberships in active directory.After starting the App in browser it seems to work fine. But after an indeterminated time it doesn't longer respond. After each click on buttons (or link buttons) you only can see the message "Error on Page" in the browsers status bar below.I played with session timeout, storing the DataTables in session variables, without success.
Last week I found this article here: [URL]" and I addedEnableEventValidation="false" ViewStateEncryptionMode="Never" to Page declaration. However, at some point the the server does not respond. Each time the worker process on webserver recycles it seems the application turn to wrong state. Might be important: All controls including GridViews are embedded in an AJAX UpdatePanel. How to get a better error message? Debugging is enabled and Custom Error handling On, Off or Remote Only brings the same result as described.
i am getting this error while fetching select statement in oracle pl/sql proc... ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SP_CLASS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored My proc is like..PROCEDURE "SP_CLASS" ( iDec IN NUMBER := null, p_ICID in number := null, p_DATA OUT SYS_REFCURSOR) IS BEGIN if(iDec = 1) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS; else if(iDec = 2) then open p_DATA for SELECT ICID AS ID, SNAME AS NAME FROM SETUP_CLASS where ICID = p_ICID ; end if; end if; END;
i have a problem with date after register i need to update im not edit the date value still i found an error Incorrect date value: '2010-02-09 12:00:00 AM'
I have been trying to create a sql statement that uses a subquery to join 2 oracle tables to create a strongly typed table adapter. For example:
Select productName, (select categoryName from categories where categories.category_id = products.category_id) as Category from Products
The ASP .Net tutorial I am working through recommends using subqueries instead of joins for the insert, update and delete commands to be automatically generated by Visual Studio 2010. When I click Finish in the table adapter wizard I get the following error (I am using MySQL version 5.1 and the MySQL Data Connector 6.3.5)
Generated SELECT statement. Error in SELECT clause: expression near 'SELECT'. Error in SELECT clause: expression near 'FROM'. Missing FROM clause. Error in SELECT clause: expression near','. Unable to parse query text.
