Connecting Asp.net Page To Sql Database
Apr 22, 2005
i am trying to connect to a sql database called abc but am not sure what goes in the connection string below in red.
please help
SqlCommand myCommand = null;
SqlDataReader myReader = null;
SqlConnection mycon = null;
mycon = new SqlConnection(what should go here)
mycon.Open();
myCommand = new SqlCommand("select count(*) from tbl_chkAdmin",mycon);
int count=(int)myCommand.ExecuteScalar();
//SQLDataReader myread=mycomand.ExecuteReader();
if(count>0)
{
View 3 Replies
ADVERTISEMENT
Jun 30, 2005
I am working through the book ASP.Net Unleashed Second Addition. I am trying to open a simple database connection. (using the sample "pubs" db from SQL Server)I have copied the author's code exactly, but it just won't work. I keep getting this error:What am I doing wrong?????Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30182: Type expected.Source Error:
Line 5:
Line 6: Sub Page_Load
Line 7: Dim conPubs As SqlConnection
Line 8: conPubs = New SqlConnection( "server=localhost;uid=webuser;pwd=secret;database=pubs" )
Line 9: conPubs.Open()
View 5 Replies
View Related
Nov 20, 2003
Ok, I'm an experienced asp developer switching to asp.net.
I've used the "Quickstart Tutorials" (http://www.asp.net/Tools/redir.aspx?path=quickstart) and have gotten started that way and built a few things based on that, but they only show XML connection info. Now I need to switch to SQL so I can connect to MS SQL Server for some stored procedures.
Anyone have suggestions?
(I've dug through some articles on msdn, etc, but I've only found so far theory and not code. And let me tell 'ya, I'm big on learning about code from code.)
If this helps, the specific tasks I'm trying to do are:
Have user select a static value from a drop down list, enter a word in a text box, and submit the form (so far so good), which connects to the db and returns the datagrid filled with results (the part I don't have). I already have my sp, just can't connect to it and get results back into the page.
View 5 Replies
View Related
Dec 18, 2006
Hello, I'm using Visual Studio 2003 and I need to be able to connect to an SQL Server 2005 Express database on the same machine using ASP.NET pages, but I'm having difficulty getting the pages to make a connection. I'm new to ASP.NET and I'm probably making some totally elemental mistake. I'd appreciate any assistance anyone can offer. I have pasted in part of the codebehind file for a web form (asterisking out the database name) and the error report that appears in the browser when I call the page.using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;namespace WebApplication2{ /// <summary> /// Summary description for WebForm1. /// </summary> public class WebForm1 : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here string strConnection="Integrated Security=SSPI;Persist Security Info=False;"; strConnection +="initial catalog = ******;server=WILL-000993DB49\SQLEXPRESS;"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); objConnection.Close(); } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } #endregion }} Server Error in '/WebApplication2' Application.
Cannot open database "******" requested by the login. The login failed.Login failed for user 'WILL-000993DB49ASPNET'.
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: Cannot open database "******" requested by the login. The login failed.Login failed for user 'WILL-000993DB49ASPNET'.
Source Error:
Line 24: strConnection +="initial catalog = ******;server=WILL-000993DB49\SQLEXPRESS;";Line 25: SqlConnection objConnection = new SqlConnection(strConnection);Line 26: objConnection.Open();Line 27: objConnection.Close();Line 28:
Source File: c:inetpubwwwrootwebapplication2webform1.aspx.cs Line: 26
Stack Trace:
[SqlException (0x80131904): Cannot open database "******" requested by the login. The login failed.Login failed for user 'WILL-000993DB49ASPNET'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734963 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 WebApplication2.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootwebapplication2webform1.aspx.cs:26 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
View 3 Replies
View Related
May 1, 2008
I'm using the IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider to connect to an AS/400 db2 database
I'm trying to do a simple pull through of table data.
My connection string is :
Code Snippet
Provider=IBMDA400.DataSource.1;Data Source=WAS400;Persist Security Info=True;Password=**********;User ID=svcorbit;Initial Catalog=S652F01E;Force Translate=0;Catalog Library List=OSLD1F3, PAOS21, OSLPLF3
I'm getting a code page conflict when I try to import the data into SQL Server. This happens when I edit the OLE DB Source component:
Code Snippet
The component reported the following warnings:
Warning at {47FF55CB-AA24-45A4-B0DC-2807EC6D3EC1} [OLE DB Source [3570]]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
and at package validation level when trying to run:
Code SnippetError at Data Flow Task [OLE DB Destination [970]]: Column "ACRC10" cannot convert between unicode and non-unicode string data types.
I've tried using the default code page on the component, that doesn't work. I've tried changing the code page to 285 (which is what it is on the AS/400), that doesn't work.
I'm running out of ideas... help!
View 4 Replies
View Related
Mar 4, 2008
Hello,
i am using sql server 2005 and installed in mixed mode withe user name sa and password #sa
and from Sql Server Surface Area Configuration i select the Using both TCP/IP and named pipes for remote settings under Database Engine
version is [@@version]
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
My os is Xp with service pack2
I am using asp.net 2.0 and using connection string in web.config
<configuration>
<appSettings>
<add key="brian" value="server=SOURAV;uid=sa;pwd=#sa;database=test"/>
</appSettings>
SOURAV is my local Database Server name.
I can connect server with the user name password from the SQL Server Management Studio,
But the problem arise when i hit con.open() from asp.net page
error message show login failed for user 'sa'
Please help how to solve,
Thanks in advance
Sourav
View 1 Replies
View Related
Nov 11, 2015
I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.
View 3 Replies
View Related
Feb 14, 2008
Hi all,
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?
Please help and advise.
Thanks,
Scott Chang
View 6 Replies
View Related
Apr 23, 2008
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
View 2 Replies
View Related
Sep 24, 2007
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?
View 10 Replies
View Related
Sep 26, 2007
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
View 5 Replies
View Related
Nov 21, 2007
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();
}
View 8 Replies
View Related
Mar 9, 2008
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
''' <summary>
''' Upload handler for uploading files.
''' </summary>
'''
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
uploadFile.SaveAs(String.Format("{0}{1}{2}", tempFile, "Uploads", uploadFile.FileName))
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.
View 2 Replies
View Related
Jun 19, 2008
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-
View 2 Replies
View Related
Nov 19, 2005
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
View 1 Replies
View Related
Nov 29, 2005
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?
View 4 Replies
View Related
Apr 25, 2006
Hi all,
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?
<add key="forumDSN" value="Provider=SQLOLEDB; Server=.SQLExpress;AttachDbFilename=|DataDirectory|dotForum2004.mdf;Trusted_Connection=Yes;" />
Thanks in advance,
Lex
View 5 Replies
View Related
May 2, 2007
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.
View 3 Replies
View Related
May 2, 2004
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.
View 6 Replies
View Related
Jun 2, 2008
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.
Any help provided would be greatly appreciated.
Thanks.
View 2 Replies
View Related
Sep 17, 2007
hi,
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....
View 5 Replies
View Related
Feb 20, 2008
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.
-Dan
View 3 Replies
View Related
Nov 28, 2006
Hello I have a project that uses a large number of MS Data access pages created in Access 2003 and runs on MS SQL2005.
When I am on lets say my client, (first page in a series) data access page and I have completed the fields in the (DAP), I am directing my users to the next step of the registration process by means of a hyperlink to another Data access page in the same web but in a linked or sometimes different table.
I need to pass data entered /created on the first page to the next page and populate the next page with some data from the first page / table. (like staying on the client name and ID when i go to the next page)
I also need the first data access page to open and display a blank or new record. Not an existing record. I will also be looking to creata a drop down box as a record selector.
Any pointers in the right direction would be appreciated.
I am some what new to data access pages so a walk through would be nice but anything you got is welcome. Thanks Peter€¦
View 2 Replies
View Related
Jun 30, 2006
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.
View 3 Replies
View Related
Aug 19, 2006
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?
View 2 Replies
View Related
Feb 3, 2007
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
View 9 Replies
View Related
Feb 13, 2007
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.
View 4 Replies
View Related
Mar 10, 2007
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.
View 2 Replies
View Related
Aug 18, 2007
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
View 1 Replies
View Related
Sep 7, 2007
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
Please, advise me to solve these problems
View 3 Replies
View Related
Oct 11, 2007
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
View 2 Replies
View Related
Nov 20, 2007
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;
}
View 6 Replies
View Related
Nov 21, 2007
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?
View 2 Replies
View Related
