From Server7/nt4 To New Server2000/windows2000

Hello,
Can anyone please tell me the best way to upgrade server1 with SERVER7 and OS of NT to a new server2 with SERVER2000 AND WINDOWS 2000 ?
The data in the old server is very important.
ThanksGenerate a script of the SQL 7 database, and recreate the database on the SQL 2000 server and use DTS to transfer the data.|||That's one way of getting stuck with reconstructing the prod environment for a couple of days, if not weeks.

Another would be to start here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

French character problems

I am having a problem where if I connect with our application to the sql
server from a windows2000 terminal server I see the French character properly
but if I connect to the same database from windows2003 i only see wird
character insted of é or è.
it's hard to explane but dose anyone know what this could be the 2003 server
is all up to date and patched
What are your regional settings on win2k and win2003?
See if its different, change it and try.
"Mart" wrote:

> I am having a problem where if I connect with our application to the sql
> server from a windows2000 terminal server I see the French character properly
> but if I connect to the same database from windows2003 i only see wird
> character insted of é or è.
> it's hard to explane but dose anyone know what this could be the 2003 server
> is all up to date and patched
|||I had tryed that but now I found that the Mdac's were the problem
thanks
"Me" wrote:
[vbcol=seagreen]
> What are your regional settings on win2k and win2003?
> See if its different, change it and try.
>
> "Mart" wrote:

French character problems

I am having a problem where if I connect with our application to the sql
server from a windows2000 terminal server I see the French character properl
y
but if I connect to the same database from windows2003 i only see wird
character insted of é or è.
it's hard to explane but dose anyone know what this could be the 2003 server
is all up to date and patchedWhat are your regional settings on win2k and win2003?
See if its different, change it and try.
"Mart" wrote:

> I am having a problem where if I connect with our application to the sql
> server from a windows2000 terminal server I see the French character prope
rly
> but if I connect to the same database from windows2003 i only see wird
> character insted of é or è.
> it's hard to explane but dose anyone know what this could be the 2003 serv
er
> is all up to date and patched|||I had tryed that but now I found that the Mdac's were the problem
thanks
"Me" wrote:
[vbcol=seagreen]
> What are your regional settings on win2k and win2003?
> See if its different, change it and try.
>
> "Mart" wrote:
>

French character problems

I am having a problem where if I connect with our application to the sql
server from a windows2000 terminal server I see the French character properly
but if I connect to the same database from windows2003 i only see wird
character insted of é or è.
it's hard to explane but dose anyone know what this could be the 2003 server
is all up to date and patchedWhat are your regional settings on win2k and win2003?
See if its different, change it and try.
"Mart" wrote:
> I am having a problem where if I connect with our application to the sql
> server from a windows2000 terminal server I see the French character properly
> but if I connect to the same database from windows2003 i only see wird
> character insted of é or è.
> it's hard to explane but dose anyone know what this could be the 2003 server
> is all up to date and patched|||I had tryed that but now I found that the Mdac's were the problem
thanks
"Me" wrote:
> What are your regional settings on win2k and win2003?
> See if its different, change it and try.
>
> "Mart" wrote:
> > I am having a problem where if I connect with our application to the sql
> > server from a windows2000 terminal server I see the French character properly
> > but if I connect to the same database from windows2003 i only see wird
> > character insted of é or è.
> >
> > it's hard to explane but dose anyone know what this could be the 2003 server
> > is all up to date and patched