DataSource Controls :: Unable To Connect With SQLserver ?
May 14, 2010
i have been trying to connect to SQLserver from ASP.net web developer in an n-tier architecture.But it shows this error in conncetion
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
i am getting this error, trying to connect to sqlserver! senario! im trying to connect 2 tables with corresponding information.
eg: table 1 has (item no., picture and link) table 2 has (all the information pertaining to the item number and picture meaning when you click on the link it has to link you back to the same picture with more information about it! what could possibly be wrong??
I am unable to connect to my local instance of SQL Server 2008 Express using SQL Server Management Studio.I believe the problem is related to a change I made to the connection protocols. Before the error occurred, I had Shared Memory enabled and Named Pipes and TCP/IP disabled. I then enabled both Named Pipes and TCP/IP, and this is when I started experiencing the problem.
I have now set Named Pipes and TCP/IP back to disabled. When I try to connect to the server with SSMS (with either my SQL server sysadmin login or with windows authentication), I get the following error message:
"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)"
My first question here is: why is it returning a Named Pipes error? Why isn't it using Shared Memory? It seems like it is not listening on Shared Memory for some reason?When I set Named Pipes to enabled and try to connect, I get the same error message.My windows account is does not have administrator priviliges on my computer.
I really need to create ID like this. But I don't know how use this Procedure .If you don't mind can you explain to me step by step how to use to procedure for create auto ID in database. (Should I call to this Procedure from somewhere else, like webpage button or something)
I have a problem with saving hebrew into sqlserver.I've done it before in another computer but did not have problem.Now the hebrew is saved as '???'.About the field collation, it is latin1_general_cp1_ci_as in another DB I have in another computeranf also in the current field in the current DB.I guess it not the collation.Ialso tried to change the text field to varchar, but it still saves '???'.
I have a select query where iam fetching the data from minimum of 7 different tables by using innerjoin. I have 3 lakhs of records in that table.BY using cache Iam fetching all 3lakhs of records at a time and put in cache. by using the rowfilter i use the records.firsttime when iam fetching these 3lakhs records it takes 3min. want to improve the performance of time.How to improve the performance of time?
'm using SQLServer Freetext for my search page. My Search page consists of a textbox where the user can enter freetext and next to the textbox I've got a dropdown which enables the user to refine the search (Catagories). My problem with my search is ... if a user type for exam Dog in the search textbox and he doesn't use the dropdown to refine his search ... no data will be displayed although Dog exists in my database. But if the user type Dog in the textbox and this time he select animal (as a catagory) from the dropdown ... then results will be displayed. In a nutshell I would like to have the functionailty that allows a user to search only by keywords typed in the search textbox apart from using the dropdown (catagory) as well.
I have a SQL Server 2000 database. I am trying to ssetup a sqldatasource in Visual Web Developer 2008 Express. I get an error saying "Microsoft.SqlServer.Management.Sdk.Sfc cannot be loaded". Everything I can find says this is related to 2005 or 2008. Any ideas what I can look for?
Currently I am working in Sql server 2005. I do not know the Sql Server 2000 and Sql Server 2008. what is the difference between Sql server 2005 and 2008?
What is the Difference between Sql Server 2000 and Sql Server 2005
I am using asp.net3.5,sqlserver2008. I have retrieving data from Accounts,BUDGETS like this.
select a.AccountLink,a.Master_Sub_Account,b.* from Accounts a inner join BUDGETS b on a.AccountLink=b.GLLink where a.AccountLink=1 output of my query... AccountLink Master_Sub_Account GLLink AccType Budget01 Budget02 Budget03
select r.Name,c.Name,s.Name,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=1)as Male,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=2)as Female from religion r,profiles p,caste c,subcaste s where r.id=p.religion and c.id=p.caste and s.id=p.subcaste group by r.Name,c.Name,s.Name,r.id,c.id,s.id
how to install microsoft sqlserver 2005 or 2008 on window 7 with x64 bit.It works perfectly on vista but on getting a new system which comes with window 7 and x64bit i was unable to load the software onit except my visual studio 2008.
select AutoIdx,TxDate,Id,AccountLink,Description,Debit,Credit,(Debit-Credit) as Actual from PostGL where Id='JL' and AccountLink=2
AutoIdx TxDate Id AccountLink Description Debit Credit Actual 3 2010-01-22 JL 2 bcb 0 35.09 -35.09 5 2010-01-28 JL 2 g 3.51 0 3.51
I am trying in view like this
declare @cnt int declare @i int set @budget=20 set @cnt= (select COUNT(*) from PostGL where AccountLink=2 ) set @i=1 WHILE (@i<=@cnt ) BEGIN set @tdebit=??
END
I am taking count the no of rows having AccountLink=2 I need to read all debit,credit and add all debit into totaldebit,all credit into totalcredit independently from table. then i need to show the totaldiff as Actual. i need ....totaldiff=totaldebit-totalcredit
I have a web applicaton run at godaddy hosting and have a sqlserver 2005 database hosting also by godaddy .From 1 week My web site hacked , by putting a strange script at all my .ASPx and the same strange script at all my database row.after that I remove the permission and make only permission of view filesand after that yesterday my web site hacked again by the strange script??? but my files didn't hacked .I scaned all my web sites files with updated antiviruse and with malware application but they didn't find any thing
i am Using sql server 2005. i want to copy the data of the excel file to the table.
i wrote the query like :
INSERT INTO test(empId,empName,empMailId,empContactNo) SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C: estExcel.xls', 'SELECT * FROM [Sheet1$]')
got the following error :
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.
then did this
sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ad Hoc Distributed Queries', 1; GO RECONFIGURE; GO
again am trying the same above query ,now am getting the following error:
Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
i want to copy the data of the excel sheet to the table.
I am trying to check the connection with one of active IBM MQ's but I am getting this error.. Unable to load DLL 'amqxcs2.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
I am using the following code..
Included amqmdnet.dll and amqmdxcs.dll in bin and gave the same reference to the project.
I need to display a single field from an sqlserver table, do I need to use sqlDataSource ect. or is there a simpler way (like msaccess's LookUp) for single values.
