Connectivity Problem of Sql Server2000 and ASP/ASP.NET
-
Dear Friends, I am confronting some problems with connectivity of Sql Server2000 and ASP/ASP.NET. I am Using IIS5.0 and MIcrosoft IE5.0/5.5.Following are error messages: Regarding Sql server2000 and asp3.0: ----------------------------------------------------------------------------- Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'AMIT-5\IUSR_AMIT-OO51N46337'. /tt.asp, line 6 ------------------------------------------------------------------------- Regarding Sql server2000 and asp.net: --------------------------------------------------------------------------- Unknown connection option in connection string: provider. 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.ArgumentException: Unknown connection option in connection string: provider. Source Error: Line 4: Line 5: sub Page_load(obj as object, e as eventargs) Line 6: dim Sqlconnection1 as new SqlConnection("Provider=SQL server;Integrated Security=SSPIersist Security Info=False;Initial Catalog=Scineceoflife;Data Source=amit-5;Use Procedure for Prepare=1;Auto Translate=Trueacket Size=4096;Workstation ID=AMIT-5;Use Encryption for Data=False;Tag with column collation when possible=False") Line 7: Line 8: dim objcmd as new SqlDataAdapter("select * from Ethnicity", Sqlconnection1) Source File: d:\inetpub\wwwroot\scienceoflife\Webform6.aspx Line: 6 ---------------------------------------------------------------------------- :mad:Please help me . With regards </x-turndown>
-
Dear Friends, I am confronting some problems with connectivity of Sql Server2000 and ASP/ASP.NET. I am Using IIS5.0 and MIcrosoft IE5.0/5.5.Following are error messages: Regarding Sql server2000 and asp3.0: ----------------------------------------------------------------------------- Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'AMIT-5\IUSR_AMIT-OO51N46337'. /tt.asp, line 6 ------------------------------------------------------------------------- Regarding Sql server2000 and asp.net: --------------------------------------------------------------------------- Unknown connection option in connection string: provider. 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.ArgumentException: Unknown connection option in connection string: provider. Source Error: Line 4: Line 5: sub Page_load(obj as object, e as eventargs) Line 6: dim Sqlconnection1 as new SqlConnection("Provider=SQL server;Integrated Security=SSPIersist Security Info=False;Initial Catalog=Scineceoflife;Data Source=amit-5;Use Procedure for Prepare=1;Auto Translate=Trueacket Size=4096;Workstation ID=AMIT-5;Use Encryption for Data=False;Tag with column collation when possible=False") Line 7: Line 8: dim objcmd as new SqlDataAdapter("select * from Ethnicity", Sqlconnection1) Source File: d:\inetpub\wwwroot\scienceoflife\Webform6.aspx Line: 6 ---------------------------------------------------------------------------- :mad:Please help me . With regards </x-turndown>
Remove "Provider=SQL server" from your connection string. //Start of joke Never comment ur code. If it was hard to write, it should be hard to understand !!! //End of joke
-
Remove "Provider=SQL server" from your connection string. //Start of joke Never comment ur code. If it was hard to write, it should be hard to understand !!! //End of joke
-
Dear Friends, I am confronting some problems with connectivity of Sql Server2000 and ASP/ASP.NET. I am Using IIS5.0 and MIcrosoft IE5.0/5.5.Following are error messages: Regarding Sql server2000 and asp3.0: ----------------------------------------------------------------------------- Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'AMIT-5\IUSR_AMIT-OO51N46337'. /tt.asp, line 6 ------------------------------------------------------------------------- Regarding Sql server2000 and asp.net: --------------------------------------------------------------------------- Unknown connection option in connection string: provider. 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.ArgumentException: Unknown connection option in connection string: provider. Source Error: Line 4: Line 5: sub Page_load(obj as object, e as eventargs) Line 6: dim Sqlconnection1 as new SqlConnection("Provider=SQL server;Integrated Security=SSPIersist Security Info=False;Initial Catalog=Scineceoflife;Data Source=amit-5;Use Procedure for Prepare=1;Auto Translate=Trueacket Size=4096;Workstation ID=AMIT-5;Use Encryption for Data=False;Tag with column collation when possible=False") Line 7: Line 8: dim objcmd as new SqlDataAdapter("select * from Ethnicity", Sqlconnection1) Source File: d:\inetpub\wwwroot\scienceoflife\Webform6.aspx Line: 6 ---------------------------------------------------------------------------- :mad:Please help me . With regards </x-turndown>
rihdus wrote: Integrated Security=SSPIersist Security Info=False Isn't the connection string wrong in this part. //Start of joke Never comment ur code. If it was hard to write, it should be hard to understand !!! //End of joke
-
rihdus wrote: Integrated Security=SSPIersist Security Info=False Isn't the connection string wrong in this part. //Start of joke Never comment ur code. If it was hard to write, it should be hard to understand !!! //End of joke
Dear Friend, sorry there is no such error . Igive u revised state. ================================================================== Unknown connection option in connection string: provider. 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.ArgumentException: Unknown connection option in connection string: provider. Source Error: Line 4: Line 5: sub Page_load(obj as object, e as eventargs) Line 6: dim Sqlconnection1 as new SqlConnection<i><b>("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Scineceoflife;Data Source=amit-5;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=AMIT-5;Use Encryption for Data=False;Tag with column collation when possible=False") </b></i> Line 7: Line 8: dim objcmd as new SqlDataAdapter("select * from Ethnicity", Sqlconnection1) Source File: d:\inetpub\wwwroot\scienceoflife\WebForm6.aspx Line: 6 ========================================================================== :confused:with regards ----sudhir </x-turndown>
-
Dear Friend, sorry there is no such error . Igive u revised state. ================================================================== Unknown connection option in connection string: provider. 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.ArgumentException: Unknown connection option in connection string: provider. Source Error: Line 4: Line 5: sub Page_load(obj as object, e as eventargs) Line 6: dim Sqlconnection1 as new SqlConnection<i><b>("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Scineceoflife;Data Source=amit-5;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=AMIT-5;Use Encryption for Data=False;Tag with column collation when possible=False") </b></i> Line 7: Line 8: dim objcmd as new SqlDataAdapter("select * from Ethnicity", Sqlconnection1) Source File: d:\inetpub\wwwroot\scienceoflife\WebForm6.aspx Line: 6 ========================================================================== :confused:with regards ----sudhir </x-turndown>
If you are using OLEDB, shouldn't you be using OleDbConnection instead of the SQL? Rocky <>< www.HintsAndTips.com www.GotTheAnswerToSpam.com
-
Dear Friends, I am confronting some problems with connectivity of Sql Server2000 and ASP/ASP.NET. I am Using IIS5.0 and MIcrosoft IE5.0/5.5.Following are error messages: Regarding Sql server2000 and asp3.0: ----------------------------------------------------------------------------- Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'AMIT-5\IUSR_AMIT-OO51N46337'. /tt.asp, line 6 ------------------------------------------------------------------------- Regarding Sql server2000 and asp.net: --------------------------------------------------------------------------- Unknown connection option in connection string: provider. 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.ArgumentException: Unknown connection option in connection string: provider. Source Error: Line 4: Line 5: sub Page_load(obj as object, e as eventargs) Line 6: dim Sqlconnection1 as new SqlConnection("Provider=SQL server;Integrated Security=SSPIersist Security Info=False;Initial Catalog=Scineceoflife;Data Source=amit-5;Use Procedure for Prepare=1;Auto Translate=Trueacket Size=4096;Workstation ID=AMIT-5;Use Encryption for Data=False;Tag with column collation when possible=False") Line 7: Line 8: dim objcmd as new SqlDataAdapter("select * from Ethnicity", Sqlconnection1) Source File: d:\inetpub\wwwroot\scienceoflife\Webform6.aspx Line: 6 ---------------------------------------------------------------------------- :mad:Please help me . With regards </x-turndown>
As for login, you need to make sure that ASP.NET access to the table. Does that specific user above IUSR_AMIT-OO51N46337 have login rights? You should give ASP.NET access to the tables. Or you can use user name/password authentication. Rocky <>< www.HintsAndTips.com www.GotTheAnswerToSpam.com
-
If you are using OLEDB, shouldn't you be using OleDbConnection instead of the SQL? Rocky <>< www.HintsAndTips.com www.GotTheAnswerToSpam.com
Dear Frnd , thanks for RE! But nothing changed after using SQLConnection , i have imported namespaces well . I login win2k server with username administrator,passwd is blank, my computer name is amit-5. please consider my both problems (with ASP And ASP.NET) ---with regards
-
If you are using OLEDB, shouldn't you be using OleDbConnection instead of the SQL? Rocky <>< www.HintsAndTips.com www.GotTheAnswerToSpam.com
Dear Friend, please go through this after changing, Sql To Oledb Login failed for user 'AMIT-5\ASPNET'. 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.OleDb.OleDbException: Login failed for user 'AMIT-5\ASPNET'. Source Error: Line 9: Line 10: dim ds as DataSet=new DataSet() Line 11: objcmd.Fill(ds, "ethnicity") Line 12: dim dt as datatable=ds.Tables("ethnicity") Line 13: Dim CurrRows() as DataRow=dt.select(Nothing,nothing, DataViewRowState.CurrentRows) Source File: d:\inetpub\wwwroot\scienceoflife\WebForm6.aspx Line: 11 :~ with regards
-
Dear Friend, please go through this after changing, Sql To Oledb Login failed for user 'AMIT-5\ASPNET'. 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.OleDb.OleDbException: Login failed for user 'AMIT-5\ASPNET'. Source Error: Line 9: Line 10: dim ds as DataSet=new DataSet() Line 11: objcmd.Fill(ds, "ethnicity") Line 12: dim dt as datatable=ds.Tables("ethnicity") Line 13: Dim CurrRows() as DataRow=dt.select(Nothing,nothing, DataViewRowState.CurrentRows) Source File: d:\inetpub\wwwroot\scienceoflife\WebForm6.aspx Line: 11 :~ with regards
Create new login for AMIT-5\ASPNET in SQL server //Start of joke Never comment ur code. If it was hard to write, it should be hard to understand !!! //End of joke
-
Create new login for AMIT-5\ASPNET in SQL server //Start of joke Never comment ur code. If it was hard to write, it should be hard to understand !!! //End of joke
-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_3ppv.asp[^] //Start of joke Never comment ur code. If it was hard to write, it should be hard to understand !!! //End of joke
-
As for login, you need to make sure that ASP.NET access to the table. Does that specific user above IUSR_AMIT-OO51N46337 have login rights? You should give ASP.NET access to the tables. Or you can use user name/password authentication. Rocky <>< www.HintsAndTips.com www.GotTheAnswerToSpam.com
Firstly i make clear that this problem is pertaining to ASP, not to asp.net as there is separate error for asp.net. ------------------------------------------------------------------------- ISUER_AMIT-OO51.... IS NOT ANY USER,HOW ITS CREATED..I KNOW LITTLE BIT AS IT'S CREATED BY THE SYSTEM. YOU KNOW, I HAVE ALWAYS SUCH ERRORS. Again remind you,that 1.My computer name is amit-5. 2.login(win2k server):Administrator. password:(blank) 3.sql server2000: SQL Server Group:local(Windows NT) AMIT-5\VSDOTNET 4.DATABASE NAME :scienceoflife 5.Table:ethnicity(2 columns) ----------------------------------------------------------------------------- Now what else you need to retreive records using 1.asp 2.asp.net.cosidering my problems stated above messages. with regards
-
Dear Friends, I am confronting some problems with connectivity of Sql Server2000 and ASP/ASP.NET. I am Using IIS5.0 and MIcrosoft IE5.0/5.5.Following are error messages: Regarding Sql server2000 and asp3.0: ----------------------------------------------------------------------------- Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'AMIT-5\IUSR_AMIT-OO51N46337'. /tt.asp, line 6 ------------------------------------------------------------------------- Regarding Sql server2000 and asp.net: --------------------------------------------------------------------------- Unknown connection option in connection string: provider. 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.ArgumentException: Unknown connection option in connection string: provider. Source Error: Line 4: Line 5: sub Page_load(obj as object, e as eventargs) Line 6: dim Sqlconnection1 as new SqlConnection("Provider=SQL server;Integrated Security=SSPIersist Security Info=False;Initial Catalog=Scineceoflife;Data Source=amit-5;Use Procedure for Prepare=1;Auto Translate=Trueacket Size=4096;Workstation ID=AMIT-5;Use Encryption for Data=False;Tag with column collation when possible=False") Line 7: Line 8: dim objcmd as new SqlDataAdapter("select * from Ethnicity", Sqlconnection1) Source File: d:\inetpub\wwwroot\scienceoflife\Webform6.aspx Line: 6 ---------------------------------------------------------------------------- :mad:Please help me . With regards </x-turndown>