|
|
Rank: Newbie
Groups: Member
Joined: 11/25/2008
Posts: 2
Points: 6
Location: here
|
Hello *,
afte Installation I get an error sounds:
Error Accessing Database.
Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp liegt der datetime-Wert außerhalb des gültigen Bereichs. Die Anweisung wurde beendet.
.Net SqlClient Data Provider
I try to translate in english:
During converting a char-datatype in a datetime-datatype, the datetime-value is outside a vaild value. The Statement was stopped.
Well I tried the KB-Articles with granting rights an ediiting both web.configs, but error still occur.
OS: SBS2003 PremiumEd (incl. SQL2005)
Best regards
Marc
|
|
Rank: Administration
Groups: Administration
, Member
Joined: 5/5/2008
Posts: 5
Points: 15
Location: Adelaide, Australia
|
Hi Marc Our application uses universal date/time format to query the database. Your SQL Server do not like this format. Please confirm the following SQL query can be execute in SQL2005. Select * FROM tbl_Calls WHERE DateEntered BETWEEN '2007-10-24 00:00:00' AND '2007-10-26 23:59:59' and Update tbl_Users SET LastLogon = '2008-11-26 14:56:59' If you cannot execute the aboves queries, try changing the SQL server default language to English and see if makes any difference. Cheers Chean
Chean Phu
Senior Software Architect
VersaDev Group
www.versadev.com
134 Gilbert Street
Adelaide, South Australia, 5000
Tel: +61 8 8463 1914
Fax: +61 8 8212 8447
Sales: sales@versadev.com
Support: support@versadev.com
Australia : Singapore : India :
United Kingdom : Belgium :
United States : Venezuela
|
|
Rank: Newbie
Groups: Member
Joined: 11/25/2008
Posts: 2
Points: 6
Location: here
|
Hi Chean,
both commands I executed, but the error is still the same. After that I changed the def.language in the properties of the users "sa" and "versasrs" from german to english, but the error still occur. I can´t reinstall the sql2005 with english-language beacuse this is the sql-server from the sbs2003 with the delivered german language
After that I tried to install versasrs on my vista-notebook with SQL2008Express. After Installation the installer said, that the db was created successfully. But in SQL2008Expr there is no new db.
Cheers
Marc
|
|
Rank: Member
Groups: Member
Joined: 5/8/2008
Posts: 13
Points: 45
Location: Adelaide - Australia
|
Hello Marc, In regards to install on SQL2008Express, please note that the following Databases are supported for versaSRS HelpDesk; Microsoft SQL Server 2005, 2000, or 2005 Express Edition. Refer here for System Requirements; http://www.versadev.com/versasrsrequirements.aspxCheers, David
|
|
Rank: Newbie
Groups: Member
Joined: 5/21/2009
Posts: 2
Points: 6
Location: MX
|
Hi, I have the same problem with the data type conversion.
I already tried the first query previously mentioned in this thread, fails
I have installed a SQL Express 2005, spanish version, modern spanish collation
I already change the language to English (in the sql server properties) but with no success.
I can't also change the collate version of the database, for example latin 1 general, because the server says it cant block exclusively the database versasrs to make the change.
I'm almost there, i think, but what other suggestions do you have?
Is there another way of unblock the DB and tried the latin 1 collation?
or
Should I reinstall and try to change the collation of versasrs (I tried creating a default new database and then change the collation, it worked)
or
Do I have to change the sql xpress to an english version? this I won't like since there are other databases already running under this express server.
Thank you for any help
Ernesto
|
|
Rank: Advanced Member
Groups: Member
Joined: 11/20/2008
Posts: 43
Points: 32
Location: Australia
|
Hi,
I am not having much luck reproducing the issue with my version. I would suggest that there is no need to change SQLExpress to english and my recommendation would be to do as you suggested and try a reinstall, as you stated that it worked when you created a new default database.
Cheers,
Philip
|
|
Rank: Newbie
Groups: Member
Joined: 5/21/2009
Posts: 2
Points: 6
Location: MX
|
Thank your for your quick response Philip
I've reinstalled the database and changed to latin1-general, even the versasrs user was created for English language (just in case), but the same error continues.
I been reading and I think that you can rebuild the databases to change the main database collation but I think it is not available on the express edition.
Is there another option you can think of?
thanks again
Ernesto
|
|
Rank: Advanced Member
Groups: Member
Joined: 11/20/2008
Posts: 43
Points: 32
Location: Australia
|
Hi,
Apologies for the delay.
Could I get you to run the first Query in the above post from Chean and post the output. You will need to make sure that you run the query on the server where SQL is installed.
The first query will let us know the date/time format of the server and will help with the trouble shooting.
Cheers,
Philip
|
|
Rank: Newbie
Groups: Member
Joined: 6/17/2010
Posts: 1
Points: 3
Location: Austria
|
Hey there!
I've installed versaSRS on the following system and got the same error:
Windows 2008 SmallBusiness Server German
SQL 2005 Express Edition German (mixed Mode install)
Microsoft SQL Management Studio Express German
With help from the posts here i was able to solve the problem!
1. open Microsoft SQL Management Studio Express German
2. log on as 'sa' or Administrator
3. right kick the first Topic in the Process Explorer called 'SBS (SQL Server 9.0.4053 -sa' on my server
4. klick properties
5. klick erweitert (i guess it is called 'advanced' in the english version
6. set the default language to english
7. klick ok
8. open secuity and logon in the object explorer
9. right klick on your versaSRS user (sa in my case)
10. klick properties
11. set the default language to english
12. klick ok
13. colse all open sql-server windows
14. restart sql-instnce service
15. done =)
I hope this will help.
Greetings from Austria!
KingOfWin.com
|
|
|
Guest |
