Last post Jul 10, 2009 11:41 AM by Cisjokey
Mar 02, 2007 06:02 AM|hivani|LINK
Line 40: // SqlDataAdapter da=new SqlDataAdapter("select * from sms",con);Line 41: DataSet ds=new DataSet();Line 42: da.Fill(ds,"tab");Line 43: DataGrid1.DataSource=ds.Tables.DefaultView;Line 44: DataGrid1.DataBind();
[OleDbException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.] System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) System.Data.OleDb.OleDbConnection.InitializeProvider() System.Data.OleDb.OleDbConnection.Open() System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) datagrd.WebForm1.Page_Load(Object sender, EventArgs e) in e:\shiva\datagrd\webform1.aspx.cs:42 System.Web.UI.Control.OnLoad(EventArgs e) System.Web.UI.Control.LoadRecursive() System.Web.UI.Page.ProcessRequestMain()
please provide the solution.
Mar 05, 2007 06:47 PM|Javier Luna|LINK
What is your sql connection string in your web application?
Mar 06, 2007 03:43 AM|hivani|LINK
string strCon="Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=Anjali;Data Source=MIPL0121;Persist Security Info=False"; //my connection string
and it is existing i am able to see the data through microsoft sql server --> enterprise manager
and i am able to get the data for my windows applications but not for web application why?
Mar 06, 2007 04:11 AM|Javier Luna|LINK
You would have to use:
String strCon = "Server=MIPL0121;Database=Anjali;User ID=myuser;password=mypassword;"
Mar 06, 2007 04:28 AM|hivani|LINK
still problem is like that only
i think problem with some other one not with connection string
my problem is exact as this
Mar 07, 2007 08:03 AM|Kevin Yu - MSFT|LINK
This is definately a security issue. In you connection string, you're using the Windows integrated authentication to connection to the server.
You can do this in the VS.NET because it is using your windows identity(Running under your account). However, the ASP.NET app is running under the ASPNET account, which doesn't have that previlege.
To resolve this, you can either give the ASPNET account proper permission to access the database, or use other accounts for accessing the database.
Mar 08, 2007 04:26 AM|hivani|LINK
Mar 08, 2007 04:47 AM|hivani|LINK
Mar 08, 2007 04:48 AM|hivani|LINK
Mar 09, 2007 05:00 AM|Kevin Yu - MSFT|LINK
I'd like to know if you're connecting from VS.NET IDE using this connection string. Or you're using this connection string in your ASP.NET application.
Because in different scenarios, it holds different user credentials. Also, please check if you have used the correct OleDb driver to do the connection to SQL Server.
Mar 09, 2007 05:17 AM|hivani|LINK
ya i am using this connection string in asp.net application
but i tryied by using vs.net IDE(using Wizards) also its givng the same error when i am connecting throw wizards it is connecting and showing the database contents(mean if a select a tabe it
showing the discription of that table ) but when i am running the application it giving the above error
Mar 02, 2009 07:12 AM|shailesh14322|LINK
Hi all, i am also facing same problem.
but i am not using anything u have mentioned here.
I am just trying to connect to the BD server from VMware workstation 6.5 machine and i am getting this error,
[DBNETLIB][ConnectionOpen(connect()).]SQL server does not exist or access denied
Help me in solving this error yaar PLZ ASAP
Jul 10, 2009 11:41 AM|Cisjokey|LINK
Your connection string does not look like an oracle connection string? This is a Microsoft SQL Server connection string.
If you have a MSSQL-Server have a look at this, this issue is well known;