Wednesday, 22 August 2012

how to solve Error :Unable to connect: incorrect log on parameters

how to solve Error :Unable to connect: incorrect log on parameters
in asp.net when we  run program for crystal report then this problem might come so i m wondering how  to sole this kind of error..if any one got please reply
Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object. Error in File C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\temp_ad5664c4-2542-42ab-939f-4357a392e7ec {E29B2F59-0CC5-4B8B-BCBE-4B3361349354}.rpt: Unable to connect: incorrect log on parameters

'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.

'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.
How to solve this error .
Whenever we create procedure like..
Use [Db_Name]
ALTER procedure [schema].[Procedure_name]
(
@field1 varchar(16)=null
)
Since there is nothing between use[ db name ]and
[ create/alter proc name]  hence  this error come.
just write like this .

Use [Db_Name]
GO
ALTER procedure [schema].[Procedure_name]
(
@field1 varchar(16)=null
)

If you don't want to use go then r

SqlException was unhandled by user code | How to solve

SqlException was unhandled by user code | How to solve
SqlException was unhandled by user code

This Error is showing that  the  sql server you looking for is not present or not exist .

  1. Just Open Sql Server
  2. File
  3. Connect Object Explorer
  4. In Front Of Server Name select option Browse For More.
  5. Network Servers.
  6. Explore DataBase Engine.
  7. Just check that which server you looking for that is present  or not.
  8. If Not then Check LAN setting and if present then There might be different way to solve this problem.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

How to solve DataTable must be set prior to using DataView. Error

How to solve DataTable must be set prior to using DataView. Error
How can we  solve Error when comes like this
  DataTable must be set prior to using DataView.
.
This problem comes Normally when we use   DataView.
so to taking   DataView in table or with dataset we must know
basic idea about DataView.

If your concept is clear then problem is not with Dataview but ..
SqlException
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. 

Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) | How to solve

Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) | How to solve
"How to solve" this kind of crystal Report Error at runtime.
This error comes because of binding of report formula and front end data.
   ReportObject.DataDefinition.FormulaFields["@crystalReportFormulaParamater"].Text = frontEndvalue.
whenever we pass formula fields from crystal report to get the data from client ..
without using any procedure or query then this kind of problem comes .
Hence just concentrate on above mentioned "red undelined code" and try with that one.
in most of cases the error comes by mentioned red undelined code  .
But not all times .