Date error

Dan Kimhi · Joined: 04 Oct 2007 Posts: 2

I deploy an application with Date Picker on a French version of Windows XP.
It works ok, but when I run it from a different user (than the one that was
used during deployment) I get the following error:

Execution error '-2147217913(80040e07)'

The conversion of char data type to smalldatetime data type in an
out-of-range smalldatetime value.

Please help

Dan Kimhi

Archived from group: microsoft>public>vb>deployment

MikeD · Joined: 04 Oct 2007 Posts: 3348

"Dan Kimhi" wrote in message @TK2MSFTNGP04.phx.gbl...
>I deploy an application with Date Picker on a French version of Windows XP.
>It works ok, but when I run it from a different user (than the one that was
>used during deployment) I get the following error:
>
> Execution error '-2147217913(80040e07)'
>
> The conversion of char data type to smalldatetime data type in an
> out-of-range smalldatetime value.

You need to provide more information if at all possible. For one, this
sounds more like a SQL Server error/issue (given the data types you
mentioned). Second, what version of VB are you using? For whatever reason,
I'm thinking you're using a .NET version (I dunno why, I guess because I've
never heard of an "Execution error" in VB6 or under). This newsgroup is for
VB6 and under. For anything .NET-related, you want a newsgroup with 'dotnet'
or 'vsnet' in the name. I also don't know what you mean by "different user
(than the one that was used during deployment)". Are you saying your app is
being run on the same PC, but under a different user than the one used to
install the app? If that's the case, was the app installed by an Admin user
(or at least a user in the Administrators group)? Also, was the app
installed for "all users"?

Again, you need to provide more information, because what you've provided so
far just isn't much to go on (not that somebody won't know or be able to
help more).

--
Mike
Microsoft MVP Visual Basic

Dan Kimhi · Joined: 04 Oct 2007 Posts: 2

Thanks.

It is in French. "Erreur exécution"
I have found the solution by using "yyyymmdd" date format for the sql
queries in the application

"MikeD" a écrit dans le message de news:
OyHgXbgrHHA.884@TK2MSFTNGP02.phx.gbl...
>
> "Dan Kimhi" wrote in message
> @TK2MSFTNGP04.phx.gbl...
>>I deploy an application with Date Picker on a French version of Windows
>>XP. It works ok, but when I run it from a different user (than the one
>>that was used during deployment) I get the following error:
>>
>> Execution error '-2147217913(80040e07)'
>>
>> The conversion of char data type to smalldatetime data type in an
>> out-of-range smalldatetime value.
>
> You need to provide more information if at all possible. For one, this
> sounds more like a SQL Server error/issue (given the data types you
> mentioned). Second, what version of VB are you using? For whatever
> reason, I'm thinking you're using a .NET version (I dunno why, I guess
> because I've never heard of an "Execution error" in VB6 or under). This
> newsgroup is for VB6 and under. For anything .NET-related, you want a
> newsgroup with 'dotnet' or 'vsnet' in the name. I also don't know what you
> mean by "different user (than the one that was used during deployment)".
> Are you saying your app is being run on the same PC, but under a different
> user than the one used to install the app? If that's the case, was the app
> installed by an Admin user (or at least a user in the Administrators
> group)? Also, was the app installed for "all users"?
>
> Again, you need to provide more information, because what you've provided
> so far just isn't much to go on (not that somebody won't know or be able
> to help more).
>
> --
> Mike
> Microsoft MVP Visual Basic
>
>
>
>
>