I have a classic ASP application which is using SQL Server 2000. I am trying to add a .NET web page into the ASP application. In the .NET Page(using C#), I am trying to use webparts.I would like to know, if the ASPNETDB can be created in SQL server 2000 to store the personalizations, and is there any other changes to be made to use web parts in an ASP application?
View 2 RepliesI have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesI want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 RepliesHow can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 RepliesDoes anyone know, what is difference between SQL Server 2000, 2005 and 2008?
View 3 RepliesCould anyone tell me the features comparision between sql server 2000, 2005 and 2008 in the table format like below. sql server 2000 features | Extra features added/supported in 2005 | Extra features supported in 2008
View 2 Replieshow to read the data's in the text file using sql server 2000 and 2008. i have a text file in a server and it contains one column name with the multiple column values i need to read that informations and i need to update in a table in the database.
View 2 Replieswt is the difference b/w sql server 2000 sql server 2005
View 4 RepliesIam using web developer express 2010. I was wondering if the web developer 2010 express supports SQL Server 2000. I know i could connectSQL server 2005 and up but is it possible i could connect sql server 2000 to web developer 2010 express?
View 4 RepliesMy application is in .NEt Framework 2. 0 and which i have deployed in window server 2000 . when i run this application it gives me error like . server application unavailable .
View 5 RepliesI'm currently developing a web application using SQL Server 2005, ASP.Net MVC, ASP.Net SQL Membership Provider (for authentication and authorisation), and Linq to SQL. Everything works great and is running as planned in the development environment.However, the production environment has a SQL Server 2000 installation, and we are unable to obtain a copy of SQL Server 2000 to use in development.Upon deploying the web application to the the production environment, what options do I have for migrating the database (schema + data) from 2005 to 2000?
View 2 Repliessome good links / tutorials for migrating data from sql server 2000 to 2008 using SSIS
View 3 RepliesI am using ASP.NET 2.0 and SQL Server 2005. I am new in web parts.I used simple calender control in web part zone it is showing an error.web part manager is also in web page.
I did not use any database connection .
Server Error in '/Webparts' Application.
--------------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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.
SQLExpress database file auto-creation error:
The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.
the difference between SQL Server 2000 and SQL Server 2005 features.
View 3 RepliesI am trying to connect my sql server 2000 using the sql server utility. It is perfecly working fine on my system but when try it on some other system i am getting an error message as "Could not find the server".
Is there any other configuration change that i need to make? I am connecting using TCP/IP
I am using SQL Server 2000 and ASP.NET 3.5.
I want to implement WebParts in my site. But while running my code it shows me an error :
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Can I do this using SqlClient or do I have to use the ODBC route > ? I get error's in VS but from reading through the other post it appears to be an IDE specific problem.
View 3 RepliesI have a table in SQL Server 2000 with a text field containing XML that I need to display on a C# ASP.NET 2.0 page. I need to retrieve the XML and then filter out a list of about 80 possible elements (or white list 20 possible elements to keep might be better). I can pull the xml out of the DB and display it on my .aspx page, but I am not sure how to filter out any elements first.
Example XML
<Message>
<MessageNumber>
1234
</MessageNumber>
<MessageType>
Auto Notice
</MessageType>
<UPMessageNumber>
5501
</UPMessageNumber>
<MessageID>
121223
</MessageID>
<ResponseTo>
654321
</ResponseTo>
<DateTime>
2010-11-10 09:35:00
</DateTime>
</Message>
In this case I will need to filter out the UPMessageNumber and MessageID before displaying it on the page.
I've been working on a web app using sql server 2008 on a development machine.... I was previously told the production system was sql server 2005, but now I'm told it is actually sql server 2000... does linq to sql support sql server 2000? I'm using linqdatasource controls to bind to gridviews utilizing it's builtin paging and sorting features..
View 2 RepliesWhen i click this button connection should establish ...
my coding is protected void Button1_Click(object sender, EventArgs e)
{
[code]...
I am running into a problem trying to open a SQL Server 2000 DTS package I imported into SQL Server 2008. I set up a new server and installed a fresh install of SQL Server 2008. The database I need to run is a SQL Server 2000 database. I moved the database over with no problem but there are a few DTS packages that need to run in legacy on SQL Server 2008. I exported the DTS packages I need out of SQL2000 and imported them successfully into SQL Server 2008. My SQL Server 2008 is x64.
I can see the DTS packages under Data Transformation Service in Legacy but when I try to open the package I get this message. "SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special web download, "SQL Server 2000 DTS Designer components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)"
I downloaded the components and installed them and still get this error. I researched and found an article about this not working on x64 so I have an x86 machine that I installed the SQL Server 2008 tools and tried to open the package from there and got the same error.
Windows server 2000 does not support .NEt 3.5, so its not supporting WCF? We, lazy, did not consider this before creating WCF application (Server, client, listener etc). My Client Console application is compiled in 3.5 just to consume WCF. I can recompile Client app to framework 2.0. to able to run it on Windows Server 2000. But how i am gonna consume WCF? Any word around? Or do i really have to go back to Web services (by dropping WCF app)?
View 3 RepliesI have a customized data import executable in .NET 3.5 which the SqlBulkCopy to basically do faster inserts on large amounts of data. The app basically takes an input file, massages the data and bulk uploads it into a SQL Server 2000. It was written by a consultant who was building it with a SQL 2008 database environment. Would that env difference be causing this? SQL 2000 does have the bcp utility which is what BulkCopy is based on. So, When we ran this, it triggered a Deadlock error.
Error details: Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I've tried numerous ways to try to resolve it. like temporarily setting the connection string variable MultipleActiveResultSets=true, which wasn't ideal, but it still gives a Deadlock error. I also made sure it wasn't a connection time out problem. here's the function.
/// <summary>
/// Bulks the insert.
/// </summary>[code].....
i want develop some web in asp.net + crystal report but i failed when deploy and make me dizzy. so i want to change to reporting service. bu i don't know how to start. I am using sql server 2000 ,can some one give me clue how to install sql server 2000 reporting service?
View 7 Replies