I migrated my webapplication from VS 2003 to VS 2005. and i am running on win xp Professional sp2. After migrating. i am getting the following error ."The type initializer for 'System.Web.Compilation.CompilationLock' threw an exception." the error is shown in the following line
"<%
@ Page Language="C#" AutoEventWireup="true" CodeFile="Test.aspx.cs"
Inherits="Test"
%>"
i looked into the net but couldnt fix this.
Thinking of using MS SQL 2005.
There are only two problems: My wallet(lol), and what licence I need.
There's so many different kinds of SQL 2005!
Can I make it with the standard edition? How many clients do I need? How
does the client-thing work on the internet?
Can an existing Website built using Classic ASP be maintained with VS.NET 2005? My employer has MS Visual Studios Interdev but I have never used that. I've been using VS.NET 2005 and would prefer to use that if I can.
View Replies View RelatedI have just created a very simple web page/site in VS 2005. I have saved it,
built it but when I try to display in a browser it takes about 20 seconds and
then comes up with "the page cannot be displayed" error. Being new to C# and
the .Net environment I"m not sure what to go look for. I was using VS 2003
without any issues.
My asp.net app uses some pure asp pages as part of the asp.net app. During debugging of pure asp I have set breakpoints in pure asp code but the problem is no breakpoint occurs on these points during execution. How can I successfully use breakpoints for pure asp in vs 2005?
View Replies View RelatedI need experts suggestion please help me out , am new in ASP and Sql Server 2005.
As I mentioned am using SQL server 2005 with ASP and now I don’t know how to create database in Sql server and after creating how to connect it.
Anyone who can send me a sample code of how to upload a file into SQL 2005
server using .asp running on IIS 6? I have a code that has been working when uploading into SQL 2000 but when I do the migration to SQL 2005, it doesn't work anymore.
My hosting service just updated their SQL Server from 2000 to 2005. I have been trying to update my code and keep getting this error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: "//"]'
Can someone please have a look at my connecting code and see what needs to be updated for the 2005 version. I would appreciate it as I have not been able to figure this out. Here is my ASP: Code:
Is it possible to change the web.config or machine.config file to allow access to an .asp page? I'm new to .Net 2.0.
View Replies View RelatedI am trying to set up a classic ASP project in Visual Studio 2005, and
I am unsire of how to debug the global.asa file (I can debug a classic
ASP file, though.):
1) Set a breakpoint on any ASP code line and run the debugger
2) In Visual Studio 2005, Select Debug --> Attach to process...
3) Click the Select.. button in the Attach To section
4) Highlight the inetinfo.exe process from the list and click Attach
I can stop on a breakpoint in an asp file, but how can on stop on a
breakpoint in global.asa? If you have to start the application first
and then attach to the process, aren't I already past global.asa?
I have an ASP web app with an SQL back end. It's currently connecting to an
SQL Server 2000 database using an ODBC DSN. I am currently migrating to a new Windows 2003 Server machine and SQL Server 2005 Express.
As usual, the app doesn't connect right away, but I've gone through all the new Windows 2003 Server security issues and I'm able to get a normal ASP page to display.
I can also connect to the SQLEXPRESS when I use visual studio or MS Access on a remote machine, even using the same ODBC DSN, but for some reason, I get an error when trying to access it though ASP. Code:
I am using the following to try to connect to the database, but it does not seem to be working.
Dim sConnString
sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MediaDB;Data Source=MEDIAMACHINESQLEXPRESS"
Connection.Open sConnString
Dim Recordset
Set Recordset=Server.CreateObject("ADODB.Recordset")
Can someone tell me the correct syntax? The original syntax (which worked) for an Access DB was as follows:
sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" &
Server.MapPath("/Music/DB/MediaDB.mdb")
I have a problem with uploading file into SQL 2005 DB using IIS 6.0
webserver, this code was working in SQL 2000 Db and IIS 5.0. Can you please
help me to see what the problem is. Error msg :
Microsoft OLE DB Provider for ODBC Drivers error '80040e23'
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not include
the table being modified or the table is not updatable through the cursor.
/uploadnewrequest.asp, line 158
Code:
I am about to migrate my asp web pages from a previous well functioning connection with Access 2003 to SQL Server 2005 Express Edition instead.
I have created a database in SQL Server called "test_db". As far as I know I have not set any particular user id or password for the database.
In this microscopic database I have onnly a single table called "name" and in this table I have two columns called "fname" and "lname". I have two records stored in the name table. What I want to achieve is simply to display these two records in my asp-page.
How can I achieve this and what am I missing here?
How to get date time to display like 01/01/2005 16:14:10?
Here's something that I found works against an Oracle database.
However, I'm not getting the same results against a SQL 2000 database.
Can anyone point out the correction needed? With the following, the
time displays correctly, but no date at all.
<%d=formatdatetime(rs2("Begin_Time"), 2)
if mid(d,2,1)="/" then d="0" & d
if mid(d,5,1)="/" then d=left(d,3) & "0" & mid(d,4)
Response.Write (d) & " "
Response.Write formatdatetime(rs2("Begin_Time"), 4)
if second(rs2("Begin_Time")) < 10 then
Response.Write ":0" & second(rs2("Begin_Time"))
else
Response.Write ":" & second(rs2("Begin_Time"))
end if%>
I have had a web server up an running for a while based on Access 2003 and asp code. Now I have decided to upgrade the database to SQL Server 2005 (not the express edition). The problem is that I just can't get it to work properly.
During the installation I was prompted for an instance name (I chose the default radio button). I am using windows authentication on a Windows 2003 Server OS.
I have created a database called "testDB". This database has only 1 table called "testtable" and this table consists of a single column called "name" with just 4 records. I want to display these records in my webpage.
The code below works fine with Access 2003 but how should it be changed to work with SQL 2005 too? Code:
I'm seeing a VERY odd issue after moving my data from a SQL2000 DB to
a SQL2005 DB. About half the time, when I request a value (using
ors.fields("pagedata") for instance), I get nothing returned. I know
there's data in the field, and I'm on the correct RS object.
Sometimes, when I move the call to another portion of the page, I get
the data (while on the same RS object). I need to move to a new server
running 2005, and folks are starting to chomp at me.
We have classic ASP running (so I'm told) on IIS 6, and I found a vbc executable on the system that says visual basic 7 when I run vbc - help . If I have them install Visual Studio 2005, I am hoping it is backward compatible with our current ASP codebase ?
View Replies View Relatedcan anyone provide a page that can do simple sql by using sql server 2005? I need it.
View Replies View RelatedI have recently had the pleasure of installing Norton Internet Security 2005
and finding that I can no longer create or open a web-based application in
Visual Studio .Net. The IDE just freezes. I tried fiddling with the
configuration settings of the Norton Firewall but was not successful. I
tried launching IIS from the Control Panel and it would not launch.
I saw one article in Groups.Google from a previous post that the individual
was eventually able to unravel the mystery but they did not list the
specifics of what they did.
How may I make Visual Web Developer 2005 Express as editor/debugger in place
of Visual InterDEV for ASP and HTML pages?
My Active Server Pages Application is unable to connect to MS SQL Server 2005 Database while the existing application works fine connecting to SQL Server 2000.
View Replies View RelatedI'm working on XP IIS5.1 in classic ASP 3.0. After the installation of the 2005 Express Suite and the beta .net2 framework that ships with it(http://lab.msdn.microsoft.com/express/vwd/) the debugging with classic ASP has an odd behaviour.
I use option explicit on all pages. When the parser finds an undeclared var or function or there is some error in a stored procedure (not in the ASP page but in the SP itself)
I receive no error reporting. The page simply renders till that point and stops.
All the other errors are reported as usual.
I currently have my website on a NT4 box, all pages work fine.
I am working on moving it over to a win200k web edition server.
I have my connection to my SQL working, copied all the pages to the new
machine without making ANY changes to the pages.
Now when my .asp page queries the database, it takes forever for it to
return any data, and not only does it display incorrectly, it does it
without putting anything in any of the tables that the data is suppose to be
in.
I have the data displayed in a table so it's all nice and neat, but the
table is not being written. When I view the source code after the data is
returned, it only has the data from the database, no mention of any tables,
or the pictures or anything else.
Is there something that has to get done so 2003 will write the tables
properly??
I have installed the new server 2003 and instaled a com dll. i had instaled on my win 2000 server. My problem is that i am getting a permission error
View Replies View RelatedI have 2000 Advanced Server with IIS 5.0 ..Net 2003 IDE and I want to create a ASP .Net Webservice Project. When I try to do that I get the message that the webserver is not running ASP.Net 1.1 . and I can't proceed. Is there a way to use ASP.Net 1.0 with IIS 5.0 in .Net 2003? I wont be upgrading to 2003 any time soon.
View Replies View RelatedOur 2003 server recently updated itself with SP2, All our asp applications which use a variety of custom activex dlls stopped working with the classic "Method '~' of '~' failed" error. Changing permissions had no effect and only uninstalling SP2 fixed it.
View Replies View RelatedI am writing a small CRM at the moment and would like one of the features to be that the first page picks up mail from a 'info@' mailbox on a locally hosted exchange 2003 server.
I am finding it a nightmare to track-down either how to do this or find the right info, I think partly because the methods may have changed with server upgrades.
Is there a definative method I should be using and any pointers to documentation etc.
I have made simpale web site inside that i am generating email page which
send form as email.
i have setup small business server with Exchange server 2003 and i have
hosted my website with this server.
i can not generate email using following code while same code working with
my developement XP machine installed SMTP service. Code:
So I only get the date, and not the time. What confuses me is the possibility that the string length can vary from date to date, else I'd use a trim, right?
View Replies View RelatedHas anyone had any success in editing/debuggin classic ASP in Visual Studio 2003?
We have recently received a new project from an outside contractor done in .Net 1.1 and now have VS 2003 installed. We have tried to use it to work with our legacy ASP applications but we are stumped on how to get the debugger to work. It keeps trying to "build" and errors out because it cannot find a sub main().
If you have had any luck with this please either point to a resource that will get us started or share the steps to get this going.
My window server is going to be upgraded from Win NT 4.0 Server to Win 2003 Server. I don't know if I can put an ASP web application on this new server without any problem. I guess ASP.NET would be better but right now I just have a classic ASP. Can you help me about this? Or any article about this issue would be greatly appreciated.
View Replies View RelatedMy code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.