Connection String Problems

QAmonet · Apr 28, 2012

I've been trying for two days to get some test .ASPX scripts to run using ADO.NET objects. I've tried several different methods (found in several different tutorials) but nothing seems to work. For example, here is some code that, according to most of the information I've found, should work just fine: <%@ Page Language="vb" Debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.ADO" %> <script language="vb" runat="server"> sub Page_Load(Src as Object, E as EventArgs) dim oDS as DataSet dim oConn as ADOConnection dim oCmd as ADODataSetCommand dim sConn as string dim sQuery as string sConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDatabase;Data Source=MyServer" sQuery = "select top 10 * from Parcel" oConn = new ADOConnection(sConn) oCmd = new ADODataSetCommand(sQuery, oConn) oDS = new DataSet() oCmd.FillDataSet(oDS, "Parcel") dgGrid.DataSource = oDS.Tables("Parcel IDs").DefaultView dgGrid.DataBind end sub </script> <html> <head> <title>DataGrid Test</title> </head> <body> <table border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td> <asp:datagrid id="dgGrid" runat="server" width="100%" backcolor="#ffffff" bordercolor="#000000" showfooter="false" cellpadding="3" cellspacing="0" font-name="verdana" font-size="8pt" headerstyle-backcolor="lightblue" headerstyle-font-size="10pt" headerstyle-font-style="bold" maintainstate="false" /> </td> </tr> </table> </body> </html> (NOTE: I have changed the connection string here so as not to send you the real DB and Server names.) Now, the connection string I use here is the same one I use in other classic .ASP scripts that work just fine. However, when attempting this in an .ASPX script, errors are thrown telling me: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. This doesn't happen to me when using classic .ASP scripts. I've tinkered around in IIS to try to solve the problem and tried different connection string configurations and tried using SQLConnection objects rather that ADOConnection objects - but all to no avail. Is there something wrong in the Beta1 release? Or am I doing something wrong? Is there a setting somewhere that needs to be modified? Please help me........ ~~ TonyIn your Connection String add: "...; User ID=ValidUserName; Password=ValidPasswordForUser" Does that do the trick?Unfortunately, when using ADO.NET, that does not do the trick. It works fine when I'm using good old classic ADO though. Thanks, ~~ TonyOn an aside, have you considered using the SQLConnection object? It provides faster access when working with SQL Server. For the SQLConnection, you can use a connection string like so: Dim myConnection as SQLConnection = new SQLConnection("server=localhost;uid=sa;pwd=;database=pubs")Yes, I've tried the SQLConnection object as well with the same results. I can't help thinking that something is wrong with my IIS (or virtual directory) settings - something to do with permissions. Although, I'm only having this problem using .NET. I'm baffled.Here's the situation: I still can't get the dang thing to work! (refer to original entry) I'm using "Basic Authentication" in IIS so I shouldn't have to include any kind of username or password in the connection string (again - this same connection string works fine for me in ASP, VB6, etc., just not in ASP.NET/ADO.NET). In addition, I'm not trying to access a SQL Server on my local box - it's a remote server, an NT box (which doesn't have the .NET Framework installed on it, by the way). Does anyone have any suggestions as to why this isn't working? Should I be using a different kind of authentication? Does .NET talk differently to SQL Server than classic ASP? Did I screw something up during the install of the Beta 1 .NET Framework? Does the box on which the SQL Server need to be a Windows2000 box or have the .NET Framework installed? I just don't know why the same connection string works from ASP and not from ASP.NET. Any help would be greatly appreciated. I'm starting to lose hair and sleep over this now - and what hairs aren't being lost are quickly turning gray.Scott, Do you have any more suggestions? Or at least know where I can go to find out how to solve this problem? Thank you, ~~ TonyThere is a highly focused listserv at: http://www.asplists.com/asplists/aspngdata.asp This list looks at data-related issues with ASP.NET. Chances are someone there will be able to help.Thank you - I really appreciate your time and help. I'll give that site a try. Thanks again, ~~ TonyIf anyone has read this and has been interested in the solution to this particular conundrum, I have found it. A kind and helpful (not to mention very knowledgeable) gentleman from another forum informed me that all I needed to do was add the following code to my config.web file: **************************************** <security> <authentication mode="none" /> <identity> <impersonation enable="true"/> </identity> <authorization /> </security> **************************************** I just needed to set "impersonation" to "true". I hope this is some help to anyone who might face a similar problem. ~~ TonyI thought the problem was solved and out of the way - and it is, if I only want to access my database from an ASPX page. I'm finding now that when I try to access the db from a webservice, I get some of the same "Anonymous Access" errors. I also tried putting the connection string in my config.web file under "appsettings" and then access it at runtime using a HashTable object. This works beautifully from my ASPX page, but not from my webservice. In attempting this from the webservice, I get the following error message: **************************** System.InvalidCastException: The data value could not be converted for reasons other than sign mismatch or data overflow. For example, the data was corrupted in the data store but the row was still retrievable. at System.Data.ADO.DBBindings.get_ValueString() at System.Data.ADO.ADODataReader.GetString(Int32 ordinal) at DataAccess.GetXMLResultSet(String sConnStr, String sQueryStr) in C:TonyTestsdotNETwsDataAccessTest.asmx:line 88 at DataAccess.ShowData(String ConnectionString, String SQLQuery) in C:TonyTestsdotNETwsDataAccessTest.asmx:line 51 **************************** If I understand that message correctly, I'm getting logged in just fine, but something is wrong with the data in my resultset. Maybe I'm misinterpreting that though. Either way, it is yet another snag. If anyone has any suggestions, I would love to hear them. Thank you, ~~ TonyScratch what I just submitted! I apologize - it turns out that I was doing something wrong with my DataReader object - the connection is working fine though. I'm sorry for any inconvenience my previous entry may have caused anyone. ~~ Tony

Connection String Problems

QAmonet

New Member