Is there any way to link two server other than using OPENQUERY.

I could connect the database to different server thro' network, but last few days it fails to connect. It populates the Error message Failed to retrieve data for this request (Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorCore) To my suprises I could connect the SQL Profiler. If there is network problem it wouldn't connect profiler. I think there is no problem in Network. Could anyone help me out.

Regards, John.L.Ponratnam

I have a login form which will connect the Active Directory to check the user; but the output that i get is alway not couldn't connect. When the it debugs in the Searcher.FindOne(); I get this error. Boolean Success = false; DirectoryEntry Entry = new DirectoryEntry("LDAP://" + Domain, UserName, Password); DirectorySearcher Searcher = new DirectorySearcher(Entry); Searcher.SearchRoot = Entry; Searcher.Filter = "(&(objectClass=user)(sAMAccountName=" + UserName + "))"; Searcher.PropertiesToLoad.Add("cn"); Searcher.SearchScope = SearchScope.Subtree; try { SearchResult Results = Searcher.FindOne(); Success = (Results != null); } Help me to solve this issue.

Regards, John.L.Ponratnam

I have a login form which will connect the Active Directory to check the user; but the output that i get is alway not couldn't connect. Boolean Success = false; DirectoryEntry Entry = new DirectoryEntry("LDAP://" + Domain, UserName, Password); DirectorySearcher Searcher = new DirectorySearcher(Entry); Searcher.SearchRoot = Entry; Searcher.Filter = "(&(objectClass=user)(sAMAccountName=" + UserName + "))"; Searcher.PropertiesToLoad.Add("cn"); Searcher.SearchScope = SearchScope.Subtree; try { //Test = UserExists(Domain, UserName, Password); SearchResult Results = Searcher.FindOne(); Success = (Results != null); } please help me to find the solution.

Regards, John.L.Ponratnam

Hi, I use this code for generating the data from Grid to Excel Dim fs As New FileStream("D:\Library.xls", FileMode.Create) Dim reportDataAdapter As IReportDataAdapter = New DataGridViewReportDataAdapter(datagrid) Dim winFormsReportExporter As IReportExporter = New WinFormsReportExporter(reportDataAdapter) Dim xlsFiledata As MemoryStream = winFormsReportExporter.ExportToXls xlsFiledata.WriteTo(fs) fs.Close() xlsFiledata.Close() But I get error message "An error occured during local report processing" near the line 4. Can any one help in solving the problem. Regards, John

Regards, John.L.Ponratnam

modified on Monday, February 22, 2010 2:07 AM

Can we use Ajile scripts while designing the aspx page

Regards, John.L.Ponratnam

Please help me out, what are the types of deadlocks in SQL Server; and how are the ways to solve it?

Regards, John.L.Ponratnam

In one of the project they used System.Data.OleDb for connecting the SQL Server 2000 database. How does it differ from using System.Data.SqlClient.

Regards, John.L.Ponratnam

Can you tell me how you can export?

Regards, John.L.Ponratnam

When I run the windows application, sometimes I get such error message "The CLR has been unable to transition from COM context 0x1a6fd8 to COM context 0x1a6e68 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations." Can I know why such error message we get?

Regards, John.L.Ponratnam

I have generated more than 65000 rows in gird. I need to extract it into excel. But if i extract the datas, excel file doesn't open. Since excel doesn't supports more than 65000 rows. Is there any option?

Regards, John.L.Ponratnam

I have seen all LINQ coding are in C sharp. Do u havw such codings in VB.Net. If so give me some examples.

Regards, John.L.Ponratnam

I have connected to the SQL Server 2000 using SQL Server Authentication. But i want to know; How to connect to the SQL Server 2000 in Windows Authentication to the .Net Application

Regards, LEE

I m beginner to VB.Net. Can some one help me in the syntax for Ternary Operator in VB.Net.

Regards, LEE

I need to know what is Hashtables? and how it is used. Plz give me some examples

Regards, LEE

How do we connect to a database from .aspx page?

Regards, LEE

I am not using the web.config file in the same root. First web.config will be accessessed by the login and the second web.cofig in a specified folder where the connection is for that specified folder.

Regards, LEE

We can have two Web.config in a project. In the first Web.config; in appSetting u have one connection and in the second Web.config u have different connection. Which connection does the project work.

Regards, LEE

How to wrap the words in a GridView

Regards, LEE

If we delete or update a row in a table; the no of changed row shows as n rows affect. Here is the example. Ex: update TableName set Column1='N' where Column2=2 Output: 4 rows affected In this i need to get the value 4. How to fetch that value. Can anyone help me out :doh:

Regards, LEE