Using VB/ASP 2005 With SQL Server 2000 MSDE
Feb 21, 2006
I have just started to create a new web project using the new VS 2005, but just discovered that my ISP has not yet converted to SQL Server 2005 and uses 2000 MSDE.
My first question is, assuming I don't use any new SQL Server 2005 features will there be any problems in using SQL 2000? Can I create/ reports and use the reporting services, or will I have to make 2 versions of my application?
2nd question is: I have to use their database name and userid. To me, this means changing every form that connects to SQL Server from my local information. Is there a way to make this dynamic so that I can change the DB name, userid, pw, etc. without creating 2 or more versions of this Web application?
Thank you for any help.
View 3 Replies
ADVERTISEMENT
Aug 1, 2007
I need to move the SQL Server 2000 Desktop Engine (MSDE) database and all jobs to the SQL Server 2005 Enterprise Edition.
- May I detach and attach the DB in my case?
- Where is the procedure to move the jobs from MSDE to SQL Server
2005?
View 1 Replies
View Related
Jun 14, 2006
Can anybody help?
I have a Windows XP and 2003 server; we have installed SQL 2005 Express on it but have an application that installs MSDE 2000 to connect to an application. After the MSDE 2000 is installed we can no longer see the instance across the network. If we uninstall the SQL 2005 express version we can see the Instance in MSDE 2000.
Is there any compatibility issue with install MSDE 2000 after SQL 2005 has been installed.
Many Thanks in advance
David
View 1 Replies
View Related
Apr 15, 2005
Hello guys! I have to develop a new web based project. It's a web
portal for events. At the moment it's runnung on an Access database.
The new version should be running on a SQL server - the desicion is:
MSDE 2000 or SQL Server 2005 Express (Beta). What do you recommend? The
webpages are developed under .NET 1.1.
View 3 Replies
View Related
Feb 19, 2008
Hi, I'm wondering if I can use SQL 2005 Reporting Services with SQL Server 2000, SQL Express or MSDE, or I need to install SQL Server 2005 in order to use Reporting Services 2005? Thank you in advance.
Regards,
Miguel
View 1 Replies
View Related
Jun 28, 2006
I'm trying to upgrade the Default Instance of MSDE 2000 Release A which is installed with Mixed Mode and strong password to SQL Server 2005 Express in a Windows 2000 Server with SP4. On the Upgrade Logon Information screen, if I select SQL Server Authentication Mode, it will give me this message:
SQL Server Setup Cannot Upgrade the specified instance by using SQL Server Credential. You must use Windows Authentication credential for the upgrade.
Thanks for any help.
View 1 Replies
View Related
Jul 3, 2006
According to this http://msdn2.microsoft.com/en-us/library/ms143393(d=robot).aspx, it seems that it cannot. But is this a complete chart?
Thanks for any help,
Peter
View 5 Replies
View Related
Jun 18, 2007
hi all
What I need to include with my application setup,
My application is working with Sql Server 2005.
I mean what substitute MSDE for sql server 2005
thanks
View 1 Replies
View Related
Nov 6, 2006
HiWe have just migrated to SQL 2005 database.We backup up our SQL database to disk, then backup files to tape usingBckupExec 10.1.The only snag is that BackupExec uses MSDE2000 to manage jobs etc soit will want to install a MSDE2000 on the server that has SQL 2005 onit !!Backupexec Support tell me that it will be fine to have two version ofSQL install on the server, is that the case?Naturally, I am concerned about DLL conflicts and breaking my SQL 2005serverCan any one shed any light on this?ThanksRC
View 1 Replies
View Related
Apr 3, 2007
Hi,
I have 2 MSDE 2000 Instances installed on Windows 2003 Server STd w/ SP1.
The application relating to the default instance is being upgraded and will require SQL 2005 Express.
What is the best approach? So the named instance of MSDE 2000 still functions correctly.
Upgrade default instance of MSDE to SQL 2005, or install SQL 2005 Express to own path and restore the DB accross? Then remove the Default Instance of MSDE 2000.
Both MSDE 2000 Instances are listed in Add/Remove Programs.
Thanks
View 1 Replies
View Related
Apr 10, 2007
Does anyone know of a resource that describes the steps to upgrade an instance of MSDE(2000) to SQL 2005 Standard?
We found something on a MS site that indirectly indicated you could upgrade the MSDE to SQL Express and then upgrade Express to the full version of 2005, but that method created quite a bit of problems(System databases), which we were not able to resolve short of uninstalling MSDE and the apps and installing SQL 2005 and re-installing the apps; but I have to believe there is a better way.
Thanks! Bob McEuen
View 4 Replies
View Related
Jul 26, 2007
Hi I would like to ask If its possible to have installed MSDE 2000 and SQL 2005 Express on the same machine. My computer uses MSDE 2000 for one application and I would like to install SQL 2005 Express for my own application. I would like to ask it will be a problem before I install it.
thanks a lot
Martin Molnar
View 1 Replies
View Related
May 21, 2005
Can you install Sql Server 2000 Developer Edition with MSDE 2000 release A already installed?
View 2 Replies
View Related
Feb 17, 2004
My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.
I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).
When I try to run setup, I get that message that says:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."
Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?
I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!
Ron
View 3 Replies
View Related
Feb 16, 2006
venu writes "Hi,
Am very new to MS SQL adminstration
Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP)
How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other)
How to create/delete tables if so, how can we do it either by GUI or CUI
just i need a clarifications reg same
Thank you,
venu"
View 1 Replies
View Related
May 27, 2008
Parameter
Access 2000/XP
SQL Server 7.0
SQL Server 2000
MSDE 2000
Number of instances per server
n/a
n/a
16
16
Number of databases per instance / server
n/a
32,767
32,767
32,767
Number of objects per database
32,768
2,147,483,647
2,147,483,647
2,147,483,647
Number of users per database
n/a
16,379
16,379
16,379
Number of roles per database
n/a
16,367
16,367
16,367
Overall size of database (excluding logs)
2 GB
1,048,516 TB
1,048,516 TB
2 GB
Number of columns per table
255
1024
1024
1024
Number of rows per table
limited by storage
limited by storage
limited by storage
limited by storage
Number of bytes per row
(Excluding TEXT/MEMO/IMAGE/OLE)
2 KB
8 KB
8 KB
8 KB
Number of columns per query
255
4,096
4,096
4,096
Number of tables per query
32
256
256
256
Size of procedure / query
64 KB
250 MB
250 MB
250 MB
Number of input params per procedure / query
199
1,024
2,100
2,100
Size of SQL statement / batch
64 KB
64 KB
64 KB
64 KB
Depth of subquery nesting
50
32
32
32
Number of indexes per table
32
250 (1 clustered)
250 (1 clustered)
250 (1 clustered)
Number of columns per index
10
16
16
16
Number of characters per object name
64
128
128
128
Number of concurrent user connections
255
32,767
32,767
5
View 1 Replies
View Related
Feb 16, 2007
Hey, This is my first time posting here but here goes nothing...
Ok I upgraded an xp machine running to sql express 2005 by doing the inplace upgrade. The upgrade process went great, after the upgrade I could connect to the databases that had been upgraded using the management studio.
BUT.
When I try to connect to the databases using the third party software which had always worked in the past I get the error when trying to access from both the client and server machines.
[DBNETLIB][Connection open()).]SQL Server does not exist or access denied.
I then tried setting up SQL express 2005 on another xp station just to test how things worked if it wasn't an upgrade. I installed, attached the databases (which I copied to that local machine) and I was able to connect to them through the third party software from the server machine, but not client machines. The client machines gave me the same error as above.
Does anyone have any ideas, I have been talking to the third party support but haven't gotten any where yet... does anyone have any suggestions?
Thanks,
View 4 Replies
View Related
Nov 8, 2007
Hi All,
I was trying to restore MSDE 2000 database to SQL 20005 EE and I got stuck with the following error:
System.Data.SqlClient.SqlError: RESTORE detected an error on page (xxxx:xxxxxx) in database 'testdb' as read from the backup set.
Do you think some pages are corrupt from the db or the backup set?
Has anybody come across this? Any ideas to resolve this error?
Thanks,
Siva.
View 4 Replies
View Related
Dec 2, 2006
Hi,
I got on my developer computer one instance of msde 2000. I want to test sql server express 2005, can I install it without "scrap" my other instance of 2000?
Strange question maybee, but it's what I wanna do!
Thanks all!
View 3 Replies
View Related
Apr 4, 2007
I am having issues trying to do an in place upgrade of msde 2000 to sql express 2005. When I try to upgrade it bombs when it reaches "Running action to shutdown instance(Run As Normal User)" with the following error:
Service 'computername' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386).
I've tried an upgrade on a clean test machine, and it goes through without any problems. I am logged into an account with local admin permissions. If any one has any ideas, they would be appreciated.
View 1 Replies
View Related
Aug 1, 2006
I have clients that have the MSDE version installed and we need to upgrade there program to the MSSQL 2005. Is there an easy way to convert the data? Should or Could I uninstall MSDE and than install MSSQL2005 WorkGrp? Will there data be affected? Any tips would be appreciated.Thanks!
View 1 Replies
View Related
Sep 18, 2007
Apparently you cannot go backwards. Once 2005 Express is installed, even removing it does not allow you to setup MSDE 2000 again. So there is no "trying it out" option.
Unfortunately, our software does not use 2005 Express. I tried it out, and now have a useless testing workstation that can't have MSDE 2000 installed again.
Any ideas on how to break the chain here are welcome.
View 1 Replies
View Related
Dec 29, 2006
Hi,
Recently we have migrated our application from MSDE 2000 to SQL Server Express 2005(SP 1). This has significantly reduced the performance of our Windows.NET application which is developed using C#.
For example : While logging in to the application two databases are being attached.
Time taken in MSDE: 16 secs
Time taken in SQL Server Express 2005 : 58 secs
Also note performance is degraded for normal screens where data is retrived from database using inline queries.
Questions:
1) Is there any special(optimum) configuration(installation parameters) while installing the SQL Server Express 2005 setup?
2) Is there any query optimization to be done w.r.t SQL Server Express 2005 ?
We highly appreciate any help towards resolving the above problem.
Regards,
Sasi
View 8 Replies
View Related
May 20, 2005
Will any application developed against SQL Server 2000 Developer
Edition work on an identical platform with only MSDE 2000 installed? I
understand there's a concurrency limit with MSDE 2000 of around 25 (and there's no GUI) but apart
from that, are there any aspects of SQL Server 2000 functionality (from the .NET applicaiton code's point of view) that
are "disabled" in MSDE 2000?
View 1 Replies
View Related
Jun 27, 2006
i went through the documentation but i was not clear on following, here is the scenario :-
a Central server is having SQL Server 2000
3 Remote Locations :- Each having 4-5 no of computers, connected on a Lan, and on one of the machines MSDE 2000 will be running.
My Questions are :-
1. Can remote locations, update data locally and send changes (say in every one hour) to central server. If yes, then how ??
2. Same way they can receive updates from Central Server on whatever was updated on Centra Server or on the 3 remote locations. If yes, then How ??
any help will be highly appreciable.
View 8 Replies
View Related
Aug 2, 2006
I am creating an install program and I'm wondering if there is a
difference between SQL Server 2000 and MSDE 2000? Do they have
different entries in the Registry?
From the documentation that I've read it seems as if they are one and the same.
However, if someone knows how to differentiate between them in the Registry it would be greatly appreciated.
Thanks
View 2 Replies
View Related
Jan 23, 2007
i am working on upgrading the clients and server computers from 2000 MSDE to 2005 SQL Express Adv. Plan to upgrade using the template.ini.
i can find the version of sql server running on th server by @@version but how do i find the version of client connctivity components the computer has installed in order to ugrade?
1. somehow i need to know whether to upgrade a client computer CONNECTIVITY COMPONENTS from 2000 to 2005?
2. is there a way to enable tcp/ip in installation script of SQL Express?
THANKS
View 9 Replies
View Related
Dec 18, 2003
I am about to setup an application server. This app will generate reports and instead of just having a HTML page up, I am considering running dotnetnuke type portal to offer the userbase a better interface for the reports, info, announcement, etc.
Server isn't too bad (2x1.7Ghz Xeon I think, 2GIG RAM) type of setup (may be little more or less). App doesn't require as much resources, but we are planning for the future )
While I have some resource to play with, I also need to make sure I don't load much that may impact the application performance. In my experience, SQL Server 2000 will take a lot of resources even when not used as much. So I am considering MSDE.
I am curious however, WHAT ARE THE MAIN DIFFERENCES BETWEEN SQL 2000 Server Vs MSDE 2000 ?
Beside no Client tool and mostly command line specific command, what else there to convince that I should go for server vs desktop engine?
Now our company has Enterprise license for SQL, so I am not worried about the cost (well a little maybe), but mostly wondering about performance.
If you think of any reason why I go to SQL Server 2000 over MSDE, please let me. Otherwise, I think MSDE in this case is the appropriate RDBMS to go for.
Regards,
Impu
View 4 Replies
View Related
Jul 23, 2005
Hi all,I just got SQL Server 2000, but I already have MSDE installed. Is there anyreason I would want to keep MSDE around on my computer if I install SQLServer 2000? I use MS Visual Studio 2002 on Windows XP SP2, in case itmakes any difference. I intend to deinstall MSDE before installing SQLServer 2000, but I get the impression from a few posts that some people haveboth installed and I'm not sure why that would be done. What functionalityis in MSDE that is not in SQL Server 2000?Thanks for answering.--Diana
View 1 Replies
View Related
Jun 23, 2004
Hello,
I have a client that is moving their web ap (which has already been developed) from one host to their own servers. The problem is that they don't have MS SQL Server 2000, but they have MSDE. All the code is already writen to work with SQL SERVER 2000.
I have a couple of questions:
1. Can I safely assume that all this code will work with MSDE and all I have to change is the connection string? For example:
SqlConnection myConn = new SqlConnection(connstring);
In other words, can I still use the SqlClient classes to work with MSDE, or will I have to modify the code?
2. Will it be a problem creating the tables and migrating the data from SQL SERVER to MSDE? Can I use Enterprise Manager to do this?
3. I never had to remotely (or even locally) connect to a MSDE database alone, I always develop with a SQL Server db. Can I use a similar connection string for the MSDE database? Do I have to create a data provider on the local machine? Can you give me an example of a MSDE connection string?
View 2 Replies
View Related
Aug 5, 2004
Here is the scoop:
I have MSDE installed on a production machine together with a bunch of ASP.NET applications. I was asked to replace MSDE with SQL Server 2000 and move every application from MSDE to SQL Server 2000 with minimum downtime.
Did any of you go through a similar process?
What is the best way of doing this conversion?
How to move the backups from MSDE to SQL Server?
Is it possible to have MSDE and SQL Server 2000 coexists for a time while moving stuff around and redirecting every connection?
Any hints or suggestions would be greatly appreciated.
Thanks.
View 2 Replies
View Related
Aug 13, 2004
Hi all,
I started learning ASP .Net using the "Teach yourself ASP.Net in 24 hours". In that book, the applications use MSDE as the database tool.
Now i have started developing some big applications and have installled MS SQL Server 2000 on my machine.
I still have databases on the MSDE.
My question is 'How do i move the old databases from MSDE to SQL Server 2000' ?
Can i uninstall MSDE safely since i already installed SQL Server 2000 ?
Please let me know.
Thank You
:-)
View 2 Replies
View Related
Apr 19, 2005
Hi,
I am developing an web-database application using ASP.net,c# and MSDE. and after the completion of the project i want to deploy the database over the server whichs got sql server professional edition.
Are there any changes to be made while deploying it over the server and also will the connection string for MSDE and SQL client the same ?
Please do clear me the confusions i have got ..
thanks inadvance
View 2 Replies
View Related
