IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...

http://www.testyourabilities.com/it/
IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
Nice Link.................

IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...

http://www.testyourabilities.com/it/
IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...I started the SQL test. My question #9 had department mispelled several
times. I quit. If you know the authors, please let them know.

<marboti@.gmail.com> wrote in message
news:1140112993.857039.254320@.g47g2000cwa.googlegr oups.com...
> http://www.testyourabilities.com/it/
> IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...|||I think it's a horrible test:
questions from very different flavors of SQL were mixed
#11 - serial datatype is not mainstream, is it?
#12 - apparently ambiguos, 2 correct answers
#14 - on which platform will INSERT ... SET work?
#15, #19 - apparently all possible answers are wrong

IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...

http://www.testyourabilities.com/it/
IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...Nice Link.................

IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...

http://www.testyourabilities.com/it/
IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...Nice Link.................

Issues getting ASP.NET and SQL to talk

Hi! This is my first time messing with SQL and ASP.NET. I'm having issues getting the SQL to work with ASP.NET. I am using win XP Pro running IIS. I have all patches and upgrades installed on the computer. All files are served off localhost.
When I try to visit the ASP.NET page I get the following error message.

Server Error in '/PortalVBSDK' Application.

SQL Server does not exist or access denied.

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: SQL Server does not exist or access denied.
Source Error:

Line 28: Dim links As New ASPNET.StarterKit.Portal.LinkDB()Line 29:Line 30: myDataList.DataSource = links.GetLinks(ModuleId)Line 31: myDataList.DataBind()Line 32:

Source File:C:\Program Files\ASP.NET Starter Kits\ASP.NET Portal (VBSDK)\PortalVBSDK\DesktopModules\QuickLinks.ascx Line:30
with the stack trace of

[SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 ASPNET.StarterKit.Portal.LinkDB.GetLinks(Int32 moduleId) ASP.QuickLinks_ascx.Page_Load(Object sender, EventArgs e) in C:\Program Files\ASP.NET Starter Kits\ASP.NET Portal (VBSDK)\PortalVBSDK\DesktopModules\QuickLinks.ascx:30 System.EventHandler.Invoke(Object sender, EventArgs e) +0 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Control.LoadRecursive() +98 System.Web.UI.Page.ProcessRequestMain() +750

---

Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Any help would be greatly appriciated!
Joshua
seems like your connectionstring is not correct|||Are you sure you have the right connection string in web.config?

issue with RS 2000, WSS and asp.net 2.0

I am having trouble upgrading a machine. It has Reporting Services(RS) 2000 SP2 and Windows Sharepoint Services (WSS) SP2 running side by side. They are working just fine and have been for quite some time. The problem is I would like to have .net 2.0 installed as well. When I installed it, some things broke.

Specifically, now when I go to http://machinename/reports or http://machinename/reportserver, I get an error page that says "Server Error in '/Reports' Application" and points to the web.config file. The Parser Error Message says "Unrecognized attribute 'processRequestInApplicationTrust' ".

Does anyone know how to get all three running on the same machine? Is this even allowed?

Any help that you can provide would be appreciated. I am stuck.

Dennis

The problem is that Web.Config files are inherited. So your "/reports" which is .net 1.1 is inheriting a .net 2.0 web.config and it doesn't recognize some tags. Only solution I know of is to rearrange the folder hierarchy to not have 1.1 apps under 2.0 apps. I would love a 2.0 version of Report Server... Anyone know if it exists?

-Jesse

Issue with 2003 virtual server and ASP.NET 2.0 Application

I'm using Sql server 2005 Express.

my connection string is as fallows:

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ccinfo.mdf;Integrated Security=True;User Instance=True

When testing this website on my local computer everything works fine. But then I uploaded it to my server... dun dun dun....

Its a godaddy virtual server running windows server 2003.

When I try to connect to the database stored in my app_data folder I get this error message:

'Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. '

What does this mean?

There was a similar discussion on a different forum (SQL Server Database Engine) that hopefully contains enough information to help you on this particular scenario. You can find it at: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=125227&SiteID=1.

Please, take a look to this link, and if the information posted there doesn’t help you, please let us know.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server engine

|||

I figured it out.

the problem was I needed to detach my mdf file from my local sql server before I uploaded the database to the host server. thanks anyway

|||

I was wondering if you could provide any more information about what was causing the problem, and how detaching the mdf files fixed it?

I'm having the exact same problem on the exact same server setup described in the original post. I have already read the other threads mentioned above and tried detaching the mdf files, but nothing seems to work.

I was able to find a work around that gets past the error, but that introduces its own strange issues. Basically, if I go into IIS Manager and set the website to impersonate a user with sufficient access rights, it works -- BUT, only if I first login to the server as that user (via remote desktop, since it's a remote virtual dedicated server). I have to do this every few hours (login as the impersonated user, that is) or the app goes back to giving the same error:

"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."

I can't figure out what logging in accomplishes -- unless somehow that lets ASP .NET or SQL Express retrieve the user's local app path? I don't need to start or run the app from the user's account -- just login to it.

The other thing I don't understand is if user instances in SQL Server Express Edition cause the system DBs to be copied into the user's local application path (which seems to be related to this problem), where do the default NETWORK SERVICE or ASPNET accounts have the files copied? I know that ASP .NET uses the Default User when no local app path exists, but I can't confirm what SQL Server Express does. I just know that giving "Everyone" write access to the SQL Express directory under Default User does not help.

If anyone can shed any light onto this situation, I'd really appreciate it. I've spent the last few days reading through everything I can find related to this issue, but can't find an explanation. I realize that not using user instances would eliminate the problem, but this should work, and I'd really like to figure out what's going on here.

|||

User instances (RANU) is a feature that was originally designed for interactive users and it requires a local profile. Typically the profile is created when a user interactively logs in a machine.

The error message suggests that the user you are impersonating in your web application has not login to this server; and from your description (things work after you login in the machine), I think this is the case indeed.

I assume you are trying to use the attach database feature in RANU, but probably a different approach may work for your scenario. For example, create the user instance with attach database using a fixed (low privileged) Windows user for your application, and allow other users to connect directly via the instance named pipe (you can find the pipe name in the management view sys.dm_os_child_instances).

The main idea behind RANU is to allow any usre in the machine to run their own (isolated) copy of SQL Server as an application running under their own context. A copy of all default databases (including master) is copied to the application path. These files are not copied from the parent instance, instead, they are copied from the SQL Express “Template Data” folder. The only exception to this rule is resource database, a read-only system database that is shared across all instances.

I hope this information helped to answer your questions, and please, let us know if you have other questions.

-Raul Garcia

SDE/T

SQL Server Engine