install of sql 2005 RS on SQL 2000 machine

Hi,
This should be a quick for you. I am wanting to install SQL 2005 on the same
W2003 Server as SQL 2000. Your newsgroups to date show that this is possible
and that SQL 2005 should be set up as a Named Instance.
My quesion relates to the install of RS2005. When SQL 2005 is setup and I
now want to install RS2005 does it install as an Upgrade option for RS2000? I
do not wish to keep RS2000 so an upgrade is preferable. Or is RS2000 left
alone and must be unistalled separately.
Any experiences would be appreciated.
Thanks.
--
Regards,
AlanHi Alan,
Thank you for your posting!
According to the SQL Books online, if you still want to use your SQL 2000
and run it as the default instance, you need to migrate Reporting Services
2000 to Reporting Services 2005. You could not upgrade Reporting Services
2000 directly because this will upgrade the Reporting Services Database and
will force you to upgrade your SQL 2000 instance to SQL 2005.
Here is an article for your reference:
Migrating Reporting Services
http://msdn2.microsoft.com/en-us/library/ms143724(d=ide).aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Perfect... as usual.
The web link you provided was exactly the info I was chasing.
Thanks.
--
Regards,
Alan
"Wei Lu" wrote:
> Hi Alan,
> Thank you for your posting!
> According to the SQL Books online, if you still want to use your SQL 2000
> and run it as the default instance, you need to migrate Reporting Services
> 2000 to Reporting Services 2005. You could not upgrade Reporting Services
> 2000 directly because this will upgrade the Reporting Services Database and
> will force you to upgrade your SQL 2000 instance to SQL 2005.
> Here is an article for your reference:
> Migrating Reporting Services
> http://msdn2.microsoft.com/en-us/library/ms143724(d=ide).aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Alan,
Thank you for the reply and glad to know that the information is helpful!
If you have any further assistance, please feel free to let me know!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Installation Date/Version Numbers

Hi
I am very new to SQL Server and am trying to gain some general information
about it. What I am interetsed in is gaining either an installation date from
the software and/or a current version that is running? Is it possible to get
this information?
Many thanks,
David Saunders
Hi David
I don't know if there is an installation date held in the registry, but for
SQL 2005 the installation log directory (...\90\Setup Bootstrap\LOG) may be
an indication. For the current product verion use SELECT @.@.VERSION or use
SERVERPROPERTY as described in
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
If you are running multiple instances on one machine you will need to check
each instance.
John
"David Saunders" wrote:

> Hi
> I am very new to SQL Server and am trying to gain some general information
> about it. What I am interetsed in is gaining either an installation date from
> the software and/or a current version that is running? Is it possible to get
> this information?
> Many thanks,
> David Saunders
|||John
Many thanks for your reply - this is excatly what I was looking for.
David Saunders
"John Bell" wrote:
[vbcol=seagreen]
> Hi David
> I don't know if there is an installation date held in the registry, but for
> SQL 2005 the installation log directory (...\90\Setup Bootstrap\LOG) may be
> an indication. For the current product verion use SELECT @.@.VERSION or use
> SERVERPROPERTY as described in
> http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
> If you are running multiple instances on one machine you will need to check
> each instance.
> John
>
> "David Saunders" wrote:

Installation Date/Version Numbers

Hi
I am very new to SQL Server and am trying to gain some general information
about it. What I am interetsed in is gaining either an installation date from
the software and/or a current version that is running? Is it possible to get
this information?
Many thanks,
David SaundersHi David
I don't know if there is an installation date held in the registry, but for
SQL 2005 the installation log directory (...\90\Setup Bootstrap\LOG) may be
an indication. For the current product verion use SELECT @.@.VERSION or use
SERVERPROPERTY as described in
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
If you are running multiple instances on one machine you will need to check
each instance.
John
"David Saunders" wrote:
> Hi
> I am very new to SQL Server and am trying to gain some general information
> about it. What I am interetsed in is gaining either an installation date from
> the software and/or a current version that is running? Is it possible to get
> this information?
> Many thanks,
> David Saunders|||John
Many thanks for your reply - this is excatly what I was looking for.
David Saunders
"John Bell" wrote:
> Hi David
> I don't know if there is an installation date held in the registry, but for
> SQL 2005 the installation log directory (...\90\Setup Bootstrap\LOG) may be
> an indication. For the current product verion use SELECT @.@.VERSION or use
> SERVERPROPERTY as described in
> http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html
> If you are running multiple instances on one machine you will need to check
> each instance.
> John
>
> "David Saunders" wrote:
> > Hi
> >
> > I am very new to SQL Server and am trying to gain some general information
> > about it. What I am interetsed in is gaining either an installation date from
> > the software and/or a current version that is running? Is it possible to get
> > this information?
> >
> > Many thanks,
> >
> > David Saunders

Installation Date/Version Numbers

Hi
I am very new to SQL Server and am trying to gain some general information
about it. What I am interetsed in is gaining either an installation date fro
m
the software and/or a current version that is running? Is it possible to get
this information?
Many thanks,
David SaundersHi David
I don't know if there is an installation date held in the registry, but for
SQL 2005 the installation log directory (...\90\Setup Bootstrap\LOG) may be
an indication. For the current product verion use SELECT @.@.VERSION or use
SERVERPROPERTY as described in
http://sqlserver2000.databases.aspf...-m-running.html
If you are running multiple instances on one machine you will need to check
each instance.
John
"David Saunders" wrote:

> Hi
> I am very new to SQL Server and am trying to gain some general information
> about it. What I am interetsed in is gaining either an installation date f
rom
> the software and/or a current version that is running? Is it possible to
get
> this information?
> Many thanks,
> David Saunders|||John
Many thanks for your reply - this is excatly what I was looking for.
David Saunders
"John Bell" wrote:
[vbcol=seagreen]
> Hi David
> I don't know if there is an installation date held in the registry, but fo
r
> SQL 2005 the installation log directory (...\90\Setup Bootstrap\LOG) may b
e
> an indication. For the current product verion use SELECT @.@.VERSION or use
> SERVERPROPERTY as described in
> http://sqlserver2000.databases.aspf...-m-running.html
> If you are running multiple instances on one machine you will need to chec
k
> each instance.
> John
>
> "David Saunders" wrote:
>sql

inserting the date into SQL Server problem

Im having problems inserting the current date into SQL server from my ASP.net application.

The error that asp.net throws is:

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated. "

In my page, im setting the date as follows:

Dim strDate as Date

strDate = now()

Then in my page I call a function called "do_store"

This works fin putting my variables into my database until I tried adding the date to the statement. Here is my function. Can anyone see my problem?

Public Function do_store(ByVal strTestID As String, ByVal strUserName As String, ByVal strUserID As String, ByVal strWrong As String, ByVal strRight As String, ByVal strAnswers As String, ByVal strDate As Date)
Dim strSQL As String
Dim sConn As String
Dim oConn As SqlConnection
'do the insert into the database
strSQL = "insert into test_results (test_plan_id, user_name, user_id, questions_wrong, questions_right, questions_answered, date_time) values (" & strTestID & ", '" & strUserName & "', " & strUserID & ", " & strWrong & ", " & strRight & ", " & strAnswers & ", '" & strDate & "')"
sConn = ConfigurationSettings.AppSettings("ConnectionString")
oConn = New SqlConnection(sConn)
Dim myCommand As SqlCommand

myCommand = New SqlCommand(strSQL, oConn)
myCommand.Connection.Open()
myCommand.ExecuteNonQuery()
End Function::Im having problems inserting the current date into SQL server from my ASP.net
::application.
::
::The error that asp.net throws is:
::
::"The conversion of a char data type to a datetime data type resulted in an out-of-range
::datetime value. The statement has been terminated. "

* Your datetime formates between the server and your process dont match.

Means: your server expects (for example) YMD, and you deliver YDM. Result: the date gets interpreted as month, and this can result in you "entering" month values from 13-31, which ARE out of range.

You need to make sure that the string you create actually is what the SQL Server expects.

BTW - if this is for a website, your code is insecure and very sucesseptable to a SQL INJECTION ATTACK.

Please read up the fundamental basics of SQL security - do it now.|||How do I check what format SQL Server wants?
how can I format the date so it fits into SQL server?
I got it all running locally (SQL Server and VS.NET) so Presumed their locale setting would be the same.
Im only building this as an intranet so its not open to the big bad world.|||This is explained in the SQL Server oducmentaiton. Actually you should not care - you should ALAWYS insert datetimes as ISO form, country independant. The correct way to insert this is:

return String.Format ("'{0:yyyy-MM-dd HH:mm:ss}'", Value);

At least this is what our EntityBroker O/R mapping framework uses, and it works so far.

The documentation of SQL Server has more information on this.

Inserting the date as defaultvalue in a sqldatasource Parameter

Hi Guys.

I am trying to insert the date as the default value into the DatePosted parameter in the sqldatasource object. I have put have the following below but it doesn't work. I have also tried <asp:Parameter Name="DatePosted" Type="DateTime" DefaultValue="<%= Date.Now %>" />

<asp:Parameter Name="DatePosted" Type="DateTime" DefaultValue="<%= now() %>" />

I know the solution is probably simple and I look like an idiot, but excuse me because I am very knew and fragile at this lol...

any help would be great :).

Mike.

Change your code to this,and it is OK.

<asp:Parameter Name="DatePosted" Type="DateTime" DefaultValue='<%# DateTime.Now %>' />

|||

Hi Jason,This does not work either. It says you can't use databind in a parameter I tried it with <%= %> as well but still nothing?

Any other ideas?

|||

If you can't override the parameter, it would be easiest to change the sql statement to reference getdate or getutcdate instead like:

INSERT INTO MyTable(col1,DatePosted) VALUES (@.col1,getutcdate())

If you have to allow for the parameter to be overridden, try putting this code into page_init:

SqlDatasource1.InsertParameters("DatePosted").DefaultValue=now

|||just do it at the database level via enterprise manager by modifying the table in question and set the default for the column by specifying the getdate() function so when a recorded is inserted via code with dateposted not supplied the sql server will insert that column with the current date.|||I have the same problem and this solution doesnt work. The column in the table has a default of getdate(), but I still get an error that NULL cannot be insert into the column. The problem is there is no way to tell it to not supply a value--if a value is not set it will supply NULL. Is there another way to default a DateTime parameter to DateTime.Now or getdate()? TIA|||

The solution I posted should work. The solution posted after mine should also work.

Please post your code.

|||

Doing it at the database level only works if you can remove it as a parameter entirely. In my case I needed to allow the user to enter datetime and only default it to getdate()/DateTime.Now when they choose not to enter specific date.

I knew of the page init method you suggested, but I was trying to avoid this as I was experimenting with how much you can do with only declarative code--I guess I just hit one of the limits of declarative coding.

(For the record, I much prefer DDD with NHibernate, NUnit, etc., but in some cases, especially for small/trivial/non-critical projects, being able to do things quickly outweighs other concerns.)

inserting the current date and time into SQL Server database

I need an SQL string that inserts the current date into a database.

So far I have tried:

SQL = "INSERT INTO X (START_DATE) VALUES('" & Date.Now &"')"

mycomm =

New SqlCommand(sql, myconn)

mycomm.ExecuteNonQuery()

However, there is a problem with the SQL command. The problem is related to the date. Is there a way of programatically inserting the current date/time into the SQL database? Language used is VB.

GetDate() is a function in SQL Server that returns the current timestamp. So you can directly use that.

SQL = "INSERT INTO X (START_DATE) VALUES( GetDate())"

Inserting NULL values on Date Fields trhough DAL

I am using a DAL and i want to insert a new row where one of the columns is DATE and itcanbe 'NULL'.

I am assigning SqlTypes.SqlDateTime.Null.

But when the date is saved in the database, i get the minvalue (1/01/1900) . Is there a way to put the NULL value in the database using DAL??

how can i put an empty date in the database?

THANK YOU!!!

check ifthishelps.|||

That does not work. Besides, in your example you are NOT using DAL. You are inserting directly to the DB, through a SQL statement.

Thannks,

JeffKish

|||

The code in the link below uses ADO.NET parameters. Hope this helps.

http://www.c-sharpcorner.com/Code/2003/Sept/EnterNullValuesForDateTime.asp