Upgrading Sql 2000 to 2005
-
jueves, 01 de marzo de 2012 11:42What are the things that need serious consideration while upgrading sql 2000 to 2005 and what are the common problems that might occur. I am trying to upgrade my sql server 2000 standard to 2005. What are the prerequisite.
bis
Todas las respuestas
-
jueves, 01 de marzo de 2012 11:57
Hi,
The first thing you need to decide is: in-place or side-by-side upgrade you wish to do. I did both of them dozens of times and I can tell you that both have pros and cons. Next step is to use the upgrade advisor and check if there is any work before you go with the upgrade.
I'd recommend to read the BOL related sections about the upgrade as well as tehse urls:
- http://technet.microsoft.com/en-us/library/cc966519.aspx
- http://msdn.microsoft.com/en-us/library/ms144245(SQL.90).aspx
I hope it helps.
Janos
There are 10 type of people. Those who understand binary and those who do not.
My Blog
- Editado Janos Berke jueves, 01 de marzo de 2012 11:57
- Marcado como respuesta bsunuwar jueves, 01 de marzo de 2012 20:01
- Desmarcado como respuesta bsunuwar jueves, 08 de marzo de 2012 1:01
- Propuesto como respuesta Janos Berke jueves, 08 de marzo de 2012 8:11
- Marcado como respuesta Stephanie LvModerator jueves, 15 de marzo de 2012 8:38
-
jueves, 08 de marzo de 2012 1:01Recent upgrade of my sql 2000 server to 2005 brought serious problem whilst my access linked table database consist of several forms and sub forms which has completely gone mad now. When i try to connect to sql database using my ODBC connection it gives out error "ODBC connection error" when i check connecting and test using DSN connection it connects successfully I also tried to connect using "sql server native connection" for sql 2005 server and its same my form brings out mad results. I am totally confused what to do next???? Do i need to do fresh sql server 2000 and restore my database to get result as before or is there any way I can connect to sql server 2005 using ODBC connection??? or can i use any other connection other than ODBC
bis
bis
-
jueves, 08 de marzo de 2012 6:38
Bis,
This is a new problem you are experiencing, it's not related to the upgrade (which has been already answered anyway!)
When you use ODBC connection, try to use the SQL Server OleDB driver or SQL Native Client. Also make sure that remote connection is enabled. According to your MS Access application, it is worth to post your question to the MS Access forum, you may likely get much better answer at there as it is a SQL Server forum.
Thanks,
Janos
There are 10 type of people. Those who understand binary and those who do not.
My Blog
