Iam a new developer to asp.net, I have been trying to connect a database to a asp.net page but many times i failed. actually i dont want to connect just directly by dragging and dropping controls rather i wanted to bind controls like textboxes and comboboxes but at first i think i have to make querystrings to and sqlconnection to connect to the database. I mean i have to manually code all these items to get my pages connected. but most of the time i face the bug which is:
Server Error in '/WebSite2' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
is that because of the fact that i dont sql server management studio installed actually i tried the same process with some other pcs that does not have sql server insatlled but it was working pretty well, but now i dont have a sql server installed and the problem still insists.
hope i have clarified my problem, sorry if it is a bit lenghty
I need to connect to a database from my asp.net page through internet. I encrypt sensitive data before sending them on the net. but I think about a more basic problem: what happens to login data when transfered on the net? I mean, if user name and password are captured by hackers, they can make more serious problems than they find some sensitive data. what shall we do? is there any way for securing sql server login itself? Regards
in microsoft doc there is written on the topic of BP Extensions with SSD's in SQL Server 2014: only clean pages are written to disk... does this mean data pages that have not been modified yet? or also those data pages that have already been modified, and where log has finished writing and the transaction has been marked as commited??
why are there clean data pages being written to L2 cache to make space for other not modified pages? I mean, shoudnt they be modified first, before letting other unmodified data pages into the Cache? I mean they have still to be modified..that makes no sense to me to page them out and page them in again just for other data pages...
I have two identical databases DB1 and DB2. And each have 4 tables
In DB1 i will insert the data in the following order For Every set of 4 records Insert into Table1 Values .. Insert into Table2 Values .. Insert into Table3 Values .. Insert into Table4 Values ..
In DB2, i will insert the data as
Insert into Db2..table1 select * from db1..table1 Insert into Db2..table2 select * from db1..table2 Insert into Db2..table3 select * from db1..table3 Insert into Db2..table4 select * from db1..table4
i.e. a bulk copy.
What is hapening is if i run DBCC SHOWCONTIG on both the database tables, it shows avg Space used for DB2 tables as more than 90% but for DB1 it is 4 - 5 %.
And if we check the device stace used by db1, it will be 10 times more by the DB2 for the same set of data. Both databases have different devices to store the log.
1. Can we have any command/procedure to reasllocate all the data so that minimum pages are used to store the data.
2. One more thing, is there any diff in SQL server 6.5 installed on Dell6100 ( Pentium Microprocessor ) and winNT 4.0 ? Because what is hapening is, if the log space is full, and if we Stop and start the SQL server on Dell system, it is not at all clearing the log space occupied. But in NT it is clearing the LOG.
3. Does any SQL server service Packs affect this..? If any let me know
4. If we create saperate LOG devices, what othere information is stored in the Data devices othere that data. Because in my case, DB1 is occupying more space than the actual data inserted.
I am new to internet development and would like some advice on the technology used to access a SQL database that sits on a network behind a firewall.
** ASP .NET Page ** -> ** Web Server ** -> ** FIREWALL ** -> ** SQL **
So to give an example; from an ASP .NET page on the internet, I would like to populate a DataGrid with the contents of a single table from a SQL database. The SQL database is sitting on our company network behind a firewall.
Could someone please explain / point me in the right direction in how the ASP .NET page / Web Server can securely access the SQL database.
In the VB 2005 Express, I can get the SqlConnection and ConnectionString of a Database "shcDB" in the Object Explorer of SQL Server Management Studio Express (SSMSE) by the following set of code: ///--CallshcSpAdoNetVB2005.vb--////
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Public Class Form1
Public Sub InsertNewFriend()
Dim connectionString As String = "Data Source=.SQLEXPRESS;Initial Catalog=shcDB;Integrated Security=SSPI;"
Dim connection As SqlConnection = New SqlConnection(connectionString)
Try
connection.Open()
Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)
command.CommandType = CommandType.StoredProcedure ....................................... etc. /////////////////////////////////////////////////////// If the Database "shcDB" and the Stored Procedure "sp_inertNewRecord" are in the Database Explorer of VB 2005 Express, I plan to use "Data Source=local" in the following code statements to get the SqlConnection and ConnectionString: ......................... ........................
Dim connectionString As String = "Data Source=local;Initial Catalog=shcDB;Integrated Security=SSPI;"
Dim connection As SqlConnection = New SqlConnection(connectionString)
Try
connection.Open()
Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)
command.CommandType = CommandType.StoredProcedure ........................ etc.
Is the "Data Source=local" statement right for this case? If not, what is the right code statement for my case?
Pages on a full recovery model database corrupted, need to ensure data loss is minimal for restore operation am thinking about restoring the latest full backup.
Hi all,I come up with a problem aleady discussed in some posts especially in the post http://forums.asp.net/t/1235761.aspx. but I got in not finally solved.The main problem is connecting to a database twice which causes errors. So I think this might be the right place to ask my questions. Here ist the problem in short:I'm using VWD on XP-Professional with SQL-Server Express and Reporting Services Express. All with Windwos Integrated Security and User Instance (SQLExpress). In my web-application I had for all Datasources the connect string:Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|mydatabase.mdf;Integrated Security=True;User Instance=True This works fine so far. I also have Reports designed with the Report designer using the same connection string. I can preview the reports and I deployd thre reports successfully. I want to call these report using a report viewer web control.Now the problem:when I call the remote remote report from my web-application, the database cannot be opened because an other process is using the database (see post mentioned above). It seems that this is a problem with attaching the database twice: from the sql-server and from the report-server.So I used now a new connection string without "attaching" the database (in vwd and in report designer):Data Source=.SQLExpress;Initial Catalog=C:inetpubwwwrootmyappAPP_DATAmydatabase;Integrated Security=True Now everything works...but ... only on my machine. On the production machine this does not work. I wonder anyway, why its working on my machine, because I never "attach" the database (there is no connection string with AttachDbFilename and I have not opend the developer and have not opened the sql management studio).On the production machine the concurrent (SQL-Server and Report-Server) connection to database does not work with either connection strings, no matter if i attach the database with sql server manager or not).This all drives me crazy for days now. All I want is to use SQL-server and Reporting- Services with its nice features and not repairing my tools. I thought I have a standard Installation, nothing special, but the standard obviously makes problems.Here finally my question:Does this environment ( web-application with remote reports) with Express edition cause normally no problems?Can I "attach" a database only once? How should I connect with my web application that uses the sql-server connections and also the report-server-connections (attaching twice does not work).What connection strings to use and when (AttachDbFilename or Initial Catalog).Are these problems specific to the Express Editions? I thank you in advance for any help Dieter
I am very new to web development using Microsoft Visual Studio. (my primary expertise is Framemaker 2003). I am currently going through your ASP.NET 2.0 videos and reproducing the lesson content on my development system. I have Microsoft Visual Studio 2005 Professional Edition. I also have Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft .NET Framework SDK v1.1 and Microsoft .NET Framework SDK v2.0. I seem to be having difficulties with the SQL interface because when I try to use the Property object from Lesson04, I get System.Web.HttpExceptioon {"Unable to connect to SQL Server database."}. When I subsequently tried to Add New Item - SQL Database from Lesson08, I get a Microsoft Visual Studio error box "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251" Any ideas? I know the videos are based on use of the Microsoft Visual Studio Express -- are there significant configuration differences between it and Microsoft Visual Studio Professional that would make these lessons incompatible?
Using web dev and sql 2005 express I have published web app and database to my server but can,t get connection string to connect with the database. --------------------------------------------------------------------- Login failed for user ''. The user is not associated with a trusted SQL Server connection. 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: Login failed for user ''. The user is not associated with a trusted SQL Server connection. --------------------------------------------------------------------- I have created a user in the logins in the sql server security node and give him every permission going. I have also created a login in the security node for the database..... and given him all permissions But I still can,t get the connection string from the web app to connect to the database? Where am I going wrong
Hi all, I am new to this field. I am trying to Connect to the database using the following code. The code does not give an error but gives an empty grid view. Can somebody figure out the mistake?protected void Page_Load(object sender, EventArgs e) {if (!IsPostBack) BindGridView(); }void BindGridView() { System.Data.SqlClient.SqlConnection sqlconnect = new System.Data.SqlClient.SqlConnection("");//added connection string here String command = "SELECT * from table";System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand(); sqlcommand.CommandText = command; sqlcommand.Connection = sqlconnect;System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(); da.SelectCommand = sqlcommand;DataSet ds = new DataSet(); sqlconnect.Open(); sqlcommand.ExecuteNonQuery(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); sqlconnect.Close(); }
I have a file called upload.vb and I am having a lot of trouble figuring out how to connect to a database that I have created in my App_Data folder called myDatabase.mdf. Here is the code on for upload.vb Imports System Imports System.Data Imports System.Configuration Imports System.Web Imports System.Web.Security Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.WebParts Imports System.Web.UI.HtmlControls Imports System.IO Imports System.Data.SqlClient
Public Class Upload Implements IHttpHandler, IReadOnlySessionState
Public Sub New() End Sub
#Region "IHttpHandler Members"
Public ReadOnly Property IsReusable() As Boolean Implements System.Web.IHttpHandler.IsReusable Get Return True End Get End Property
Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest
If context.Request.Files.Count > 0 Then ' get the applications path Dim tempFile As String = context.Request.PhysicalApplicationPath ' loop through all the uploaded files Dim j As Integer = 0 While j < context.Request.Files.Count ' get the current file Dim uploadFile As HttpPostedFile = context.Request.Files(j) ' if there was a file uploded If uploadFile.ContentLength > 0 Then
End If System.Math.Max(System.Threading.Interlocked.Increment(j), j - 1) End While End If ' Used as a fix for a bug in mac flash player that makes the ' onComplete event not fire HttpContext.Current.Response.Write(" ") End Sub
#End Region
End Class Everytime I attempt to create a database connection I get all kinds Compiler errors. If anybody can help me understand how to connect to my database from this page I would greatly appreciate it. Thanks.
I am new to the visual web development program; however, I have created many applications using Visual Studio Express in Visual Basic. I am trying to figure out how to:1. Define a connection string in VB2. Open a current Connection3. Define a SqlStatement4. Retrieve the information5. Display results in textboxI am basically trying to get a login system set up so that a user can type in his name and password and is then directed to a secure page.When I create a new application and want to do this I would use the following code: Dim cnUsers As New SqlClient.SqlconnectionDim cnUsersString As String = "CONNECTION STRING"Dim UserCommand As NEw SqlClient.SqlCommand = "Select chrUsers, chrPassword FROM tblUsers WHERE chrUsers = '" & txtUserName.Text & "' AND chrPassword = '" & txtPassword.Text & "'" cnUsers.ConnectionString = cbUsersStringcnUsers.Open()UserCommand.Connection = cnUserstxtResults.Text = cnUsers.ExecuteNonQuery()cnUsers.Close() That is a very rough draft of what I would code it as. If you have any suggestions please let me know! - NUStudent-
I have an SQL database setup but i don't know how to connect to it to set up a table. I have a vague idea about connectionstrings and such. I have a server name, a database name, a user id and a password. I would like to set it up so i can just enter the SQL commands and create a table and enter data. But first I need to connect to the database. I
I am moving my site from a shared environment to a dedicated server and SQL is on the same box. How do I connect to my database if it's on the same box?
Please help me with the following problem because I am running around in circles.
I have this problem getting a forum online. Since it is a database related problem which I have been trying to solve at the ClubSite forum I am taking the liberty to come to this forum with this problem.
This is the story: I have this separate SQL database dotForum2004.mdf in App_data. After trial and error got it working locally.
But when I put it online at my webserver (On a Stand-alone PC at my jobsite) I get an application error.(From the Club Site application)
This is the connection key which works fine locally. Is there something obvious you can point me at?
For an assignment at school, I need to build an ASPX web page that looks up books in a database. This entails the use of a SQL database, and I am having issues trying to connect to the database.
here is a pic of the error I am getting:
I am using Visual WebDeveloper 2005 Express to do this in, and I can't find any options that pertain to the error above. I looked in the SQL configuration tools that I have installed, and I can't seem to find the correct options that I need.
Does anyone know how to resolve this? If you can provide direction on this, that would be great.
Hi. I'm totally new here, and I'm not an expert when it comes to SQL, so bear with me. This is my dilemma:
I use Access 2000 to connect to my Microsoft SQL Server 2000 database. Recently, our provider switched us from a shared server to a dedicated server. The site is up and running perfectly, but I can't connect to my database via Access anymore. Once I received the new location of the database, I ran odbcad32.exe and configured the database's DSN info where appropriate. I run the "Test Data Source..." function and the tests are seemingly successful. When I open my database using Access, I'm able to log in successfully, but when I click on any one of my linked tables, I get the following error:
Could not execute query; could not find linked table.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'NAMEOFDATABASE.NAMEOFTABLE'. (#208)
The support team at my provider are not exactly geniuses, so who knows if and when they'll be getting back to me. In the meantime, does anyone have a clue what might be causing this? Since the site is working perfectly, I assume the connection strings are okay and the database is perfectly intact (I even checked to see that the most recent entries were live), so what gives? If there's any more info I can provide, let me know. Thanks in advance.
Hi, I will post this on a c# forum as well but maybe someone has an answer here.
I want to connect to my database in a program i am coding with C#. I have 3 databases in my SQL server (DB1, DB2, DB3)(perhaps schemas is the word to use) all under a connection called TEST (as opposed to SQLEXPRESS.
My connection string in my code is as follows: string ConnectionString = "Data Source=.\TEST;Integrated Security=True;Connect Timeout=30;User Instance=True;";
My app reports a valid connection is made. WooHoo. But, When i try to do a select statement eg: Select * from DB1.Customers I get the following error. System.Data.SqlClient.SqlException: Invalid object name 'DB1.Customers'
I have tried removing the DB1. part from the select statement and specifying Database = DB1 in my connection string but that doesnt work either.
i have to give connection string in .cs file as SQLConnection cn=new SQLConnection("")
i have to connect to local computer..please anyone provide me solution. datbase is northwind...and i m connected it with windows authentication.. please any one provide me answer....
I'm completely new to this, so as much detail as you can provide is appreciated.
I have a SQL database called "WebDesk.mdf" and I have a ASP.Net web application. I can't figure out the connection string I need to connect to this database. It doesn't matter if I connect to it as a file, or otherwise.
Please tell me all the steps I need to get the connection string.
I am new to .net and I am using Visual Web Developer 2005 Express with SQL Server 2005 Express. What I would like to do is connect to my SQL database (which resides in the app_data folder) and open a table and pull out a field and place it in either a textbox or label on the page. No editing or deleting. Just simple one field binding. By the way, I can do this with all the cool built-in tools of VWD, but I want to know how to do it all by hand. I would really appreciate it if someone could help me out.
Hi I am new at this. I have a little program written in C# in asp.net. The program basically accesses a database and stores new records. The database is supposedly already attached to MSDE so I am able to see the tables of the database inside asp.net. I can click on the individual slots of the table and modify the datas manually. However, I want to connect to the database from my C# program and be able to input data into the database via the website that the C# program produces. After I type in the data into the website and click the submit button on the website, I get an error page that says this: Login failed for user 'sa' the line of code thats causing this error is: con = new SqlConnection("data source=(local)\NetSdk; initial catalog=Friends; user id=sa"); Why is it not able to connect to the database?
I am using SQL Server 2000 database in my VB.Net project. My VB.net application is installed one two machines in different cities i.e. there are two separate databases. First machine's IP address is say 202.33.44.55 and other machine IP address is say 203.33.55.66. Now I want to use each others databases i.e. I want to set their database group. So that in my VB.Net's application which is installed on 202.33.44.55 I could see data of the 203.33.55.66 by just changing the connection string
I am doing one of the Microsoft virtual labs "Creating ASP.NET Web Applications with C# - Part 2" using Visual Web Developer Express. I am trying to fill a gridview with database information, but it gives me the error "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)".This is on the local machine that I am executing the code. public void BindGrid(string sortfield) { //Create DataAdapter to fetch data from Prodcuts table SqlDataAdapter myCommand = new SqlDataAdapter("select * from Products", myConnection); //Create dataset and fill it with Product data DataSet ds = new DataSet(); myCommand.Fill(ds, "Products"); //Bind Product data to Datagrid DataView Source = ds.Tables["Products"].DefaultView; Source.Sort = sortfield; dgProducts.DataSource = Source; dgProducts.DataBind(); } It stops on the line "myCommand.Fill(ds, "Products"); and points out the error mentioned earlier. I am not sure what to do...any help would be greatly appreciated, thanks in advance, and I apologize as well if I have not pointed out enough information.
Hi guys, I created a database using SQL Server EXpress edition but now i need to use SQL Server Development edition. I cant connect to the database now? Anyone tell me what the problem is.
hiI usually did my database in SQL Server Management Studio Express then when I was in Visual Studios I would connect to it in the server explorer tab but I wanted to try to do it through Visual studios so I took my database files then went to my app_data folder and added them as existing items. I then went back to the server explorer tab and set it up.Everything thing seemed to set up but when I run it I get an error. I get this error when it does conn.Open(); Error: 1 System.Data.SqlClient.SqlException was unhandled by user code 2 Message="Cannot open database "Japanese" requested by the login. The login failed. Login failed for user 'HOWSER\chobo'." 3 Source=".Net SqlClient Data Provider" 4 ErrorCode=-2146232060 5 Class=11 6 LineNumber=65536 7 Number=4060 8 Procedure="" 9 Server="localhost\SqlExpress" 10 State=1 11 StackTrace: 12 at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 13 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 14 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 15 at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) 16 at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) 17 at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) 18 at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) 19 at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) 20 at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) 21 at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) 22 at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) 23 at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) 24 at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) 25 at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) 26 at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 27 at System.Data.SqlClient.SqlConnection.Open() 28 at Practice.Page_Load(Object sender, EventArgs e) in h:WebsiteJapanesePractice.aspx.cs:line 28 29 at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) 30 at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) 31 at System.Web.UI.Control.OnLoad(EventArgs e) 32 at System.Web.UI.Control.LoadRecursive() 33 at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 34 This is what I have as my connection stuffwebconfig 1 <connectionStrings> 2 <add name="Japanese" connectionString="Server=localhostSqlExpress; 3 Database=Japanese; Integrated Security=True" 4 providerName ="System.Data.SqlClient"/> 5 </connectionStrings> 6 7 In my file 1 SqlConnection conn; 2 SqlCommand comm; 3 SqlDataReader reader; 4 5 string connectionString = ConfigurationManager.ConnectionStrings["Japanese"].ConnectionString; 6 conn = new SqlConnection(connectionString); 7 8 comm = new SqlCommand("SELECT HiraganaCharacter,HiraganaImage FROM Hiragana", conn); 9 conn.Open(); 10 reader = comm.ExecuteReader(); Thanks
Hi, I uploaded my website to a server and I face some problem to connect with the data base In the website I have one databse that combaine the asp.net membership and roles tabels when I try to login the website I got this error An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I use the login control +++ another error I get it when I request data from tables other than the member ship and roles tables, the error is A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate's CN name does not match the passed value.)
maybe the second error related to the first becouse in the second stuation I also request the userName wich comes from the membership's table
When i am trying to connect to SQL Server(Express edition) on production server i am getting the following error. "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)" My SQL connection string is like this which i wrote in web.config. <add key="conn1" value="Data Source=xxx.xxx.x.xxxyz,1433;Initial Catalog=abcdef_xyz;persist Security Info=true;User ID=xx;Password=xxxxxx"/> string constr = ConfigurationManager.AppSettings["conn1"]; SqlConnection con = new SqlConnection(constr); con.Open(); When i searched microsoft help to resolve this error, it suggested me to enable TCP/IP protocol for SQL server, i did that, but even after doing that i am still not able to connect to the database. Could any one please tell me what else i need to configure in order to connect to the database. Thanks
Hi i have written a function which will inset data into my database, when the function is called from a page, my only problem now is how to connect it to the database, in other words how the function will communicate with the database, this is the code i have written below including a connection code however it doesnt seem to work, can someone help me on my way, thank you //Build SQL Query static public string buildQuery(string strAction, string strTableName, string[,] strData, string[,] strWhere, string strWhereOverride, string strLimit, string strOffset, string strOrderBy) {SqlConnection SqlConn = null; SqlCommand SqlCmd = null;String strConnection = null; String strSQL = null;strConnection = ConfigurationManager.AppSettings["strConnectionString"]; SqlConn = new SqlConnection(strConnection); SqlConn.Open(); //Ucase strAction = (strAction); //Dimension //string strSQL;long lngIter; long lngCount;string strPart1 = ""; string strPart2 = ""; //Build first part strSQL = strAction + " "; //Build Insert Query if (strAction == "INSERT") { //Next part of query strSQL = strSQL + "INTO " + strTableName + " "; //Build data part of query lngCount = Convert.ToInt32(strData.GetUpperBound(1));for (lngIter = 0; lngIter < lngCount; ++lngIter) {if (strWhere[lngIter, 0] != "") { //Build Column Name Part strPart1 = strPart1 + "`" + strData[lngIter, 0] + "`,"; //Build Column Data Part strPart2 = strPart2 + (char)34 + strData[lngIter, 1] + (char)34 + ","; } } //Concatenate strSQL = strSQL + "(" + strPart1.Substring(1, Strings.Len((strPart1)) - 1) + ") values (" + strPart2.Substring(1, Strings.Len((strPart2)) - 1) + ")"; } //Build where part strPart1 = ""; //Iterate if (strWhereOverride == "") {lngCount = Convert.ToInt32(strWhere.GetUpperBound(0));for (lngIter = 0; lngIter < lngCount; ++lngIter) { //Ensure is not empty if (strWhere[lngIter, 0] != "") { //Use default compare of equal but allow override string strCompare = "="; ; //If override is present then use if (strWhere[lngIter, 2] != "") { strCompare = strWhere[lngIter, 2]; } //Build where strPart1 = strPart1 + strWhere[lngIter, 0] + strCompare + strWhere[lngIter, 1] + " and "; } } //Concatenate strSQL = strSQL + " WHERE " + strSQL.Trim(strPart1.Substring(1, Strings.Len(strPart1) - 5).ToCharArray()); } else { //Concatenate strSQL = strSQL + " WHERE " + strWhereOverride; } //if Orderby if (strOrderBy.Length > 2) {strSQL = strSQL + " ORDER BY " + strOrderBy; } return strSQL; }
I get the following error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) How do I correct it?
