.net msde/sql server

[Piedro]

Hi Group,

I haven written a program on a win 2000 pc and sql server 2000, in the
sql server there're about 40 tables with data and now I'm deploying my
project on a test pc with windows xp professional SP2 and an msde
database but the strange thing is, on my win 2000 sql server 2000 pc
I've got a table which keeps the heighth of something (decimal(8,2)).
An example of a stored value is 4512 and in the msde it's also stored
as 4512 but when I run my program on the win 2000 sql server 2000
machine it displays the value in a textbox as 4512 which is ok, but on
the win xp/msde machine it shows 4512.00 in the textbox and I can't
seem to lose the .00

any help would be much appreciated

PS: the regional settings are the same on both pc's

[Cor Ligthert]

Re: .net msde/sql server

Piedro,

The Net versions as well?

Cor

[Cor Ligthert]

Re: .net msde/sql server

Piedro,

The Net versions as well?

Cor

[CJ Taylor]

Re: .net msde/sql server

Do you enable visual styles? They use different comctl libraries.

maybe this was an enhancement?

I dunno.
"Piedro" <pproost@hotmai l.com> wrote in message
news:b7e3650a.0 409230700.7bd53 1e1@posting.goo gle.com...[color=blue]
> Hi Group,
>
> I haven written a program on a win 2000 pc and sql server 2000, in the
> sql server there're about 40 tables with data and now I'm deploying my
> project on a test pc with windows xp professional SP2 and an msde
> database but the strange thing is, on my win 2000 sql server 2000 pc
> I've got a table which keeps the heighth of something (decimal(8,2)).
> An example of a stored value is 4512 and in the msde it's also stored
> as 4512 but when I run my program on the win 2000 sql server 2000
> machine it displays the value in a textbox as 4512 which is ok, but on
> the win xp/msde machine it shows 4512.00 in the textbox and I can't
> seem to lose the .00
>
> any help would be much appreciated
>
> PS: the regional settings are the same on both pc's[/color]

[CJ Taylor]

Re: .net msde/sql server

Do you enable visual styles? They use different comctl libraries.

maybe this was an enhancement?

I dunno.
"Piedro" <pproost@hotmai l.com> wrote in message
news:b7e3650a.0 409230700.7bd53 1e1@posting.goo gle.com...[color=blue]
> Hi Group,
>
> I haven written a program on a win 2000 pc and sql server 2000, in the
> sql server there're about 40 tables with data and now I'm deploying my
> project on a test pc with windows xp professional SP2 and an msde
> database but the strange thing is, on my win 2000 sql server 2000 pc
> I've got a table which keeps the heighth of something (decimal(8,2)).
> An example of a stored value is 4512 and in the msde it's also stored
> as 4512 but when I run my program on the win 2000 sql server 2000
> machine it displays the value in a textbox as 4512 which is ok, but on
> the win xp/msde machine it shows 4512.00 in the textbox and I can't
> seem to lose the .00
>
> any help would be much appreciated
>
> PS: the regional settings are the same on both pc's[/color]

[Peter]

Re: .net msde/sql server

The dot net version on the win 2000 pc is vs.net 2002, on the xp machine
I've installed the dot net framework redistibutable, I don't know if there's
ne difference between these 2 frameworks. But I do now that on an other test
pc also a win 2000 pc with only the framework and msde installed to it has
the same "problem". I haven't enabled visual styles.

Grtz Peter

"CJ Taylor" <[cege] at [tavayn] dit commmmm> schreef in bericht
news:ON7hUEYoEH A.2864@TK2MSFTN GP12.phx.gbl...[color=blue]
> Do you enable visual styles? They use different comctl libraries.
>
> maybe this was an enhancement?
>
> I dunno.
> "Piedro" <pproost@hotmai l.com> wrote in message
> news:b7e3650a.0 409230700.7bd53 1e1@posting.goo gle.com...[color=green]
> > Hi Group,
> >
> > I haven written a program on a win 2000 pc and sql server 2000, in the
> > sql server there're about 40 tables with data and now I'm deploying my
> > project on a test pc with windows xp professional SP2 and an msde
> > database but the strange thing is, on my win 2000 sql server 2000 pc
> > I've got a table which keeps the heighth of something (decimal(8,2)).
> > An example of a stored value is 4512 and in the msde it's also stored
> > as 4512 but when I run my program on the win 2000 sql server 2000
> > machine it displays the value in a textbox as 4512 which is ok, but on
> > the win xp/msde machine it shows 4512.00 in the textbox and I can't
> > seem to lose the .00
> >
> > any help would be much appreciated
> >
> > PS: the regional settings are the same on both pc's[/color]
>
>[/color]

[CJ Taylor]

Re: .net msde/sql server

Well, VS.NET 2002 is only compatible with version 1.0 of the framework. It
depends what version of the framework redist you've installed. is it 1.0?
1.1? or 2.0b1?

-CJ

"Peter" <pproost@nospam .hotmail.com> wrote in message
news:uPkundaoEH A.3460@tk2msftn gp13.phx.gbl...[color=blue]
> The dot net version on the win 2000 pc is vs.net 2002, on the xp machine
> I've installed the dot net framework redistibutable, I don't know if[/color]
there's[color=blue]
> ne difference between these 2 frameworks. But I do now that on an other[/color]
test[color=blue]
> pc also a win 2000 pc with only the framework and msde installed to it has
> the same "problem". I haven't enabled visual styles.
>
> Grtz Peter
>
> "CJ Taylor" <[cege] at [tavayn] dit commmmm> schreef in bericht
> news:ON7hUEYoEH A.2864@TK2MSFTN GP12.phx.gbl...[color=green]
> > Do you enable visual styles? They use different comctl libraries.
> >
> > maybe this was an enhancement?
> >
> > I dunno.
> > "Piedro" <pproost@hotmai l.com> wrote in message
> > news:b7e3650a.0 409230700.7bd53 1e1@posting.goo gle.com...[color=darkred]
> > > Hi Group,
> > >
> > > I haven written a program on a win 2000 pc and sql server 2000, in the
> > > sql server there're about 40 tables with data and now I'm deploying my
> > > project on a test pc with windows xp professional SP2 and an msde
> > > database but the strange thing is, on my win 2000 sql server 2000 pc
> > > I've got a table which keeps the heighth of something (decimal(8,2)).
> > > An example of a stored value is 4512 and in the msde it's also stored
> > > as 4512 but when I run my program on the win 2000 sql server 2000
> > > machine it displays the value in a textbox as 4512 which is ok, but on
> > > the win xp/msde machine it shows 4512.00 in the textbox and I can't
> > > seem to lose the .00
> > >
> > > any help would be much appreciated
> > >
> > > PS: the regional settings are the same on both pc's[/color]
> >
> >[/color]
>
>[/color]

[Peter]

Re: .net msde/sql server

The program works just fine so I'm pretty sure I have got the 1.0 framework
installed on the xp test machine, but I'll have to check that at work
tomorrow. I'm going to sleep now because in Belgium it's already late at
night.

Thnx for you time I'll post what framework I've installed tomorrow

"CJ Taylor" <[cege] at [tavayn] dit commmmm> schreef in bericht
news:ORFvEhaoEH A.3464@TK2MSFTN GP14.phx.gbl...[color=blue]
> Well, VS.NET 2002 is only compatible with version 1.0 of the framework.[/color]
It[color=blue]
> depends what version of the framework redist you've installed. is it 1.0?
> 1.1? or 2.0b1?
>
> -CJ
>
> "Peter" <pproost@nospam .hotmail.com> wrote in message
> news:uPkundaoEH A.3460@tk2msftn gp13.phx.gbl...[color=green]
> > The dot net version on the win 2000 pc is vs.net 2002, on the xp machine
> > I've installed the dot net framework redistibutable, I don't know if[/color]
> there's[color=green]
> > ne difference between these 2 frameworks. But I do now that on an other[/color]
> test[color=green]
> > pc also a win 2000 pc with only the framework and msde installed to it[/color][/color]
has[color=blue][color=green]
> > the same "problem". I haven't enabled visual styles.
> >
> > Grtz Peter
> >
> > "CJ Taylor" <[cege] at [tavayn] dit commmmm> schreef in bericht
> > news:ON7hUEYoEH A.2864@TK2MSFTN GP12.phx.gbl...[color=darkred]
> > > Do you enable visual styles? They use different comctl libraries.
> > >
> > > maybe this was an enhancement?
> > >
> > > I dunno.
> > > "Piedro" <pproost@hotmai l.com> wrote in message
> > > news:b7e3650a.0 409230700.7bd53 1e1@posting.goo gle.com...
> > > > Hi Group,
> > > >
> > > > I haven written a program on a win 2000 pc and sql server 2000, in[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > > sql server there're about 40 tables with data and now I'm deploying[/color][/color][/color]
my[color=blue][color=green][color=darkred]
> > > > project on a test pc with windows xp professional SP2 and an msde
> > > > database but the strange thing is, on my win 2000 sql server 2000 pc
> > > > I've got a table which keeps the heighth of something[/color][/color][/color]
(decimal(8,2)).[color=blue][color=green][color=darkred]
> > > > An example of a stored value is 4512 and in the msde it's also[/color][/color][/color]
stored[color=blue][color=green][color=darkred]
> > > > as 4512 but when I run my program on the win 2000 sql server 2000
> > > > machine it displays the value in a textbox as 4512 which is ok, but[/color][/color][/color]
on[color=blue][color=green][color=darkred]
> > > > the win xp/msde machine it shows 4512.00 in the textbox and I can't
> > > > seem to lose the .00
> > > >
> > > > any help would be much appreciated
> > > >
> > > > PS: the regional settings are the same on both pc's
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[CJ Taylor]

Re: .net msde/sql server

Sounds good.

"Peter" <pproost@nospam .hotmail.com> wrote in message
news:%23%235Tdu aoEHA.2912@TK2M SFTNGP10.phx.gb l...[color=blue]
> The program works just fine so I'm pretty sure I have got the 1.0[/color]
framework[color=blue]
> installed on the xp test machine, but I'll have to check that at work
> tomorrow. I'm going to sleep now because in Belgium it's already late at
> night.
>
> Thnx for you time I'll post what framework I've installed tomorrow
>
> "CJ Taylor" <[cege] at [tavayn] dit commmmm> schreef in bericht
> news:ORFvEhaoEH A.3464@TK2MSFTN GP14.phx.gbl...[color=green]
> > Well, VS.NET 2002 is only compatible with version 1.0 of the framework.[/color]
> It[color=green]
> > depends what version of the framework redist you've installed. is it[/color][/color]
1.0?[color=blue][color=green]
> > 1.1? or 2.0b1?
> >
> > -CJ
> >
> > "Peter" <pproost@nospam .hotmail.com> wrote in message
> > news:uPkundaoEH A.3460@tk2msftn gp13.phx.gbl...[color=darkred]
> > > The dot net version on the win 2000 pc is vs.net 2002, on the xp[/color][/color][/color]
machine[color=blue][color=green][color=darkred]
> > > I've installed the dot net framework redistibutable, I don't know if[/color]
> > there's[color=darkred]
> > > ne difference between these 2 frameworks. But I do now that on an[/color][/color][/color]
other[color=blue][color=green]
> > test[color=darkred]
> > > pc also a win 2000 pc with only the framework and msde installed to it[/color][/color]
> has[color=green][color=darkred]
> > > the same "problem". I haven't enabled visual styles.
> > >
> > > Grtz Peter
> > >
> > > "CJ Taylor" <[cege] at [tavayn] dit commmmm> schreef in bericht
> > > news:ON7hUEYoEH A.2864@TK2MSFTN GP12.phx.gbl...
> > > > Do you enable visual styles? They use different comctl libraries.
> > > >
> > > > maybe this was an enhancement?
> > > >
> > > > I dunno.
> > > > "Piedro" <pproost@hotmai l.com> wrote in message
> > > > news:b7e3650a.0 409230700.7bd53 1e1@posting.goo gle.com...
> > > > > Hi Group,
> > > > >
> > > > > I haven written a program on a win 2000 pc and sql server 2000, in[/color][/color]
> the[color=green][color=darkred]
> > > > > sql server there're about 40 tables with data and now I'm[/color][/color][/color]
deploying[color=blue]
> my[color=green][color=darkred]
> > > > > project on a test pc with windows xp professional SP2 and an msde
> > > > > database but the strange thing is, on my win 2000 sql server 2000[/color][/color][/color]
pc[color=blue][color=green][color=darkred]
> > > > > I've got a table which keeps the heighth of something[/color][/color]
> (decimal(8,2)).[color=green][color=darkred]
> > > > > An example of a stored value is 4512 and in the msde it's also[/color][/color]
> stored[color=green][color=darkred]
> > > > > as 4512 but when I run my program on the win 2000 sql server 2000
> > > > > machine it displays the value in a textbox as 4512 which is ok,[/color][/color][/color]
but[color=blue]
> on[color=green][color=darkred]
> > > > > the win xp/msde machine it shows 4512.00 in the textbox and I[/color][/color][/color]
can't[color=blue][color=green][color=darkred]
> > > > > seem to lose the .00
> > > > >
> > > > > any help would be much appreciated
> > > > >
> > > > > PS: the regional settings are the same on both pc's
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Peter Proost]

Re: .net msde/sql server

Hi I've found the problem and indeed has to do with framework version you
guys mentioned , the redistibutable package of the framework they gave me at
work is the 1.1 framework redistibutable and not the 1.0 I thought it was,
after I've uninstalled the 1.1 framework and installed the 1.0 framework
it's ok. So now I know what's causing the "problem"

thnx for your time and help


"CJ Taylor" <[cege] at [tavayn] dit commmmm> a écrit dans le message de
news: u7fYkxaoEHA.384 0@TK2MSFTNGP09. phx.gbl...[color=blue]
> Sounds good.
>
> "Peter" <pproost@nospam .hotmail.com> wrote in message
> news:%23%235Tdu aoEHA.2912@TK2M SFTNGP10.phx.gb l...[color=green]
>> The program works just fine so I'm pretty sure I have got the 1.0[/color]
> framework[color=green]
>> installed on the xp test machine, but I'll have to check that at work
>> tomorrow. I'm going to sleep now because in Belgium it's already late at
>> night.
>>
>> Thnx for you time I'll post what framework I've installed tomorrow
>>
>> "CJ Taylor" <[cege] at [tavayn] dit commmmm> schreef in bericht
>> news:ORFvEhaoEH A.3464@TK2MSFTN GP14.phx.gbl...[color=darkred]
>> > Well, VS.NET 2002 is only compatible with version 1.0 of the framework.[/color]
>> It[color=darkred]
>> > depends what version of the framework redist you've installed. is it[/color][/color]
> 1.0?[color=green][color=darkred]
>> > 1.1? or 2.0b1?
>> >
>> > -CJ
>> >
>> > "Peter" <pproost@nospam .hotmail.com> wrote in message
>> > news:uPkundaoEH A.3460@tk2msftn gp13.phx.gbl...
>> > > The dot net version on the win 2000 pc is vs.net 2002, on the xp[/color][/color]
> machine[color=green][color=darkred]
>> > > I've installed the dot net framework redistibutable, I don't know if
>> > there's
>> > > ne difference between these 2 frameworks. But I do now that on an[/color][/color]
> other[color=green][color=darkred]
>> > test
>> > > pc also a win 2000 pc with only the framework and msde installed to
>> > > it[/color]
>> has[color=darkred]
>> > > the same "problem". I haven't enabled visual styles.
>> > >
>> > > Grtz Peter
>> > >
>> > > "CJ Taylor" <[cege] at [tavayn] dit commmmm> schreef in bericht
>> > > news:ON7hUEYoEH A.2864@TK2MSFTN GP12.phx.gbl...
>> > > > Do you enable visual styles? They use different comctl libraries.
>> > > >
>> > > > maybe this was an enhancement?
>> > > >
>> > > > I dunno.
>> > > > "Piedro" <pproost@hotmai l.com> wrote in message
>> > > > news:b7e3650a.0 409230700.7bd53 1e1@posting.goo gle.com...
>> > > > > Hi Group,
>> > > > >
>> > > > > I haven written a program on a win 2000 pc and sql server 2000,
>> > > > > in[/color]
>> the[color=darkred]
>> > > > > sql server there're about 40 tables with data and now I'm[/color][/color]
> deploying[color=green]
>> my[color=darkred]
>> > > > > project on a test pc with windows xp professional SP2 and an msde
>> > > > > database but the strange thing is, on my win 2000 sql server 2000[/color][/color]
> pc[color=green][color=darkred]
>> > > > > I've got a table which keeps the heighth of something[/color]
>> (decimal(8,2)).[color=darkred]
>> > > > > An example of a stored value is 4512 and in the msde it's also[/color]
>> stored[color=darkred]
>> > > > > as 4512 but when I run my program on the win 2000 sql server 2000
>> > > > > machine it displays the value in a textbox as 4512 which is ok,[/color][/color]
> but[color=green]
>> on[color=darkred]
>> > > > > the win xp/msde machine it shows 4512.00 in the textbox and I[/color][/color]
> can't[color=green][color=darkred]
>> > > > > seem to lose the .00
>> > > > >
>> > > > > any help would be much appreciated
>> > > > >
>> > > > > PS: the regional settings are the same on both pc's
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >[/color]
>>
>>[/color]
>
>[/color]