|
You can get the release candidate of SQL Server 2008 from Microsoft Download or through your MSDN subscription.
To download, see SQL Server 2008 RC0 Download[^]. You can also download it through your MSDN subscription[^]. You can also find SQL Server 2008 RC 0 at TechNet Plus[^].
The released version is scheduled for third calendar quarter this year.
This release includes support for upgrading failover clusters from previous versions of SQL Server, as well as several bug fixes and minor improvements that we have made in response to the extensive customer feedback we’ve received from previous CTPs.
More than 250,000 customers and partners have downloaded the previous community technology preview (CTP) releases.
To learn more about SQL Server 2008, see SQL Server 2008, What's New[^]. To get started using the features in SQL Server 2008, see SQL Server 2008 Jump Start[^].
SQL Server 2008 delivers on the data platform vision in four areas: Mission Critical Platform, Dynamic Development, Beyond Relational, and Pervasive Insight.
|
|
|
|
|
Hello.
I have some problems with an application developed in C# and Oracle connection, The Application is a Windows Services that process some actions in an Oracle database in real time.
The problem is that I'm using C# 2003 and Framework 1.1 SP1, and I don´t know why the service lost the connection with the database and the object Oracleconnection.State is "Open".
I think that this is my problem:
http://support.microsoft.com/default.aspx?scid=kb;en-us;830173[^]
But I can´t close and open the connection all the time, I´m only need to reopen the connection when and Exception Happended (But my connection class it´s in other .net solution).
I thought that if I put a thread listening a variable that is changed any time I do an action, if this variable doesn´t change I reopend the connection, but my client doesn´t like this solution.
Anyone can help me ?, if you think on any solution please let me know.
Thank's a lot.
Regards, Jose A. Morey.
|
|
|
|
|
Retain the connection credentials in the web service
retain the sql command object for resubmission
submit command
trap the error when the SQL connection fails
interrogate the error to make sure it is the connection fail error
reestablish the connection
resubmit the SQL action (this being the nasty bit)
Just some ideas!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
I have a typical scenario. I want to get
My query is
SELECT StarRate, date FROM BasicSearch WHERE date BETWEEN '2008-06-03' AND '2008-06-05';
My Result is as follows
StarRate date
-------- -----
1 2008-06-03 00:00:00.000
1 2008-06-04 00:00:00.000
1 2008-06-05 00:00:00.000
5 2008-06-04 00:00:00.000
5 2008-06-05 00:00:00.000
But I require the result as below
StarRate date
-------- -----
1 2008-06-03 00:00:00.000
1 2008-06-04 00:00:00.000
1 2008-06-05 00:00:00.000
Because StarRate 1 has all 3 dates
Thanks in advance
|
|
|
|
|
SELECT DISTINCT StarRate, date FROM BasicSearch WHERE date BETWEEN '2008-06-03' AND '2008-06-05';
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi
Do you want the output to be only the StarRate witch has all the dates in the date interval?
Try
SELECT StarRate, date FROM BasicSearch WHERE date BETWEEN '2008-06-03' AND '2008-06-05'
AND StarRate in (
SELECT StarRate FROM BasicSearch WHERE date BETWEEN '2008-06-03' AND '2008-06-05'
GROUP BY StarRate
HAVING Count(*) = DATEDIFF("D", '2008-06-03', '2008-06-05') + 1)
This should work if it's uniqueness on StarRate and date
Kjetil
|
|
|
|
|
Nice one. I think I misread the original post, didn't notive it was just the starrate 1's required.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi...
SELECT StarRate, date FROM BasicSearch WHERE date BETWEEN '2008-06-03' AND '2008-06-05'
Order By Date
By..
Tc
|
|
|
|
|
I'm reading an Excel file in VB.NET. The columns in the sheets don't have a datatype specified. One of the columns has phone numbers. Some users have entered the numbers with dashes (-), and others without dashes or spaces. When a column has all of the phone numbers with dashes, it shows all the values. The same happens when all the numbers are without dashes. The problem is when some have and some haven't: it reads only the ones that have a dash.
How can I read all of the cells? Defining the type on the Excel isn't an option, there are hundreds of files with several sheets each.
I'm sorry if this is the wrong forum for this question.
Thank you for your help!
modified on Tuesday, June 10, 2008 9:35 AM
|
|
|
|
|
I finally found the solution. The problem was the way Excel was designed. Let me explain:
When no data type is specified, Excel reads the first 8 rows of that column to try to find out. My file had several lines of heading, leaving just the first row of data to do this. The first value was text, so it assumed the whole column was text, ignoring the numbers. My solution was to tell the user (luckily just one understanding person) to run the program twice, once with a dash and once without. Not the best solution, but it's the best I can do. I hope I can help somebody with this.
|
|
|
|
|
hi every body
Is there any one know that how can i registering a designed ".mdf" file in desktop engine with out using enterprise manager tool?
I mean that i only instaal desktop engine and no thing more, or in other word I wanna use my project with an install shield file to intall it with out any special action from user.
|
|
|
|
|
i have stored procedure with two parameters as follows:
create procedure checkCompatability
(
@compatility varchar output,
@award_num int
)
AS
SET NOCOUNT OFF;
IF EXISTS (SELECT Award_num from table1 where award_num=@award_num)
begin
set @compatability='Y'
print @compatability
end
else
set @compatability='N'
print @compatability
GO
in C# parameters:
SqlCommand checkDone = new SqlCommand();
checkDone.Connection = con1;
checkDone.Connection.Open();
checkDone.CommandType = CommandType.StoredProcedure;
checkDone.CommandText = "checkCompatability";
SqlParameter comp = new SqlParameter("@compatability", SqlDbType.VarChar);
string S = comp.Value.ToString();\\null reference exception occours here
lblresult.Text = S.ToString();
comp.Direction = ParameterDirection.Output;
SqlParameter complete = new SqlParameter("@award_num", SqlDbType.Int);
complete.Direction = ParameterDirection.Input;
int awN = int.Parse(comboAwardNum.Text);
complete.Value =(int) awN;
lblresult.Text = comp.Value.ToString();
checkDone.Parameters.Add(comp);
checkDone.Parameters.Add(complete);
checkDone.ExecuteNonQuery();
checkDone.Connection.Close();
what is the problem with that code?
|
|
|
|
|
You cannot retrieve the value of output parameters until after you have executed the stored procedure and retrieved all the results (if any). (The latter is a SQL Server limitation: when in 'firehose' mode it doesn't return the output parameter values until after the entire result data stream has been sent.)
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
do you mean that i should execute the command before initailize the parameters?
|
|
|
|
|
No, set the parameters, execute the proc and THEN get the output value.
Also, stop double posting - this was in the C# forum as well.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi,
I have just completely installed SQL Server 2005 Developer Edition with all features but there is no icon of "SQL Server Management Studios" in program files. I tried to find in the following directory:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"
but there is no "SqlWb.exe" present there. What should I do.
Thanx
Regards Syed Kamran ul Haq
ALLAH HAFIZ
|
|
|
|
|
Try running SqlRun_Tools.msi file which is in your SQL Server 2005 media in the
Tools\Setup folder.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi all,
Not sure if this is the right board for this question - sorry if not !!!
I have installed Reporting Services and have created a nmuber of reports via the business intelegence IDE. However a customer has asked for something a little different than the usual table format.
They want a report that has a number of text boxes arranged on the page that contain data grabbed from the db. I have managed to get this working but they also want this same format on a new page of the report for each row returned by the SQL statement.
Not sure i have explained this very well but any info you could give would be fantastic as i am really stuck !!!
Thanks,
John
|
|
|
|
|
I think what you want is a header. Go to report on the menu and page header. Put your text boxes in there?
|
|
|
|
|
Hi,
Thanks for the reply! but i am still having problems.
The textboxes are populated from fields in the dataset. when i tried to put them in the header i was told that fields cant be put in the header.
All i need is the same report page replicated for each row in the dataset. but its seeming impossible
Please help !!!!
Thanks
John
|
|
|
|
|
Hello,
I have found the solution
I simply needed to put the text boxes inside a list then set the list to have a page break after it !!!
Just thought i would let you know, thanks
John
|
|
|
|
|
I have a SQL query that outputs well formed XML
SELECT Title,Description FROM dbo.Books FOR XML PATH('item'), ROOT('channel')
The output look like the following
"channel"
"item"
"title"Study Guide For College Physics II"/title"
"description"This course is divided into four..."/description"
"/item"
"item"
"title"God bless America"/title"
"description"Americans went off to war in World War.."/description"
"/item"
"/channel"
What I need is the xml version, namespace so I can automate this process.
Like so
Had to strip out tags as they are filtered
"xml version="1.0""
"rss version="2.0"
"xmlns:live="http://live.com/schema/media/"
"channel"
"item"
"title"Study Guide For College Physics II"/title"
"description"This course is divided into four..."/description"
"/item"
"item"
"title"God bless America"/title"
"description"Americans went off to war in World War.."/description"
"/item"
"/channel"
|
|
|
|
|
Hello.
Why when I use this query (select top(10) * from test.dbf order by testcol) for a *.dbf free table with Visual Foxpro ODBC driver I get 94 rows in the result set instead of 10 rows? Do you know why?
modified on Monday, June 9, 2008 12:16 PM
|
|
|
|
|
I have implemented form authentication on SSRS and am trying to use it in my web application using SOAP APIs.
I am able to call the logonuser method with the reportserver proxy class with cookie management on loggin in my web application using the SOAP APIs.
But after authentication when I move to next page and try to access the
listchildrens method of reporting service I get the "Object moved to " error.
I want to know how to pass credentials to reporting service so that it allows
me to access the same accross my application.
Dim rsobj As New RS.ReportingService
rsobj.Url = "http://localhost/reportserver/ReportService.asmx"
' Return a list of catalog items in the report server database
Dim items As RS.CatalogItem() = rsobj.ListChildren("/", True)
|
|
|
|
|
hi
i am new in vb.net and now i am learning sql and i have create one small application with sql and in table there are two columns one is imageID and second one is Image
i can save and delete image with sql database but problme is when i add or delete image is dosent shows changes i mean if i add second image in to database but it still shows there is one image in database but if i close application and re run it then it shows there is two images in database so i am not sure but it looks like i need to refresh some thing but i dont know what
is it possible to help me with this issue ?
this is my code
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Public Class Form1
Private mImageFile As Image
Private mImageFilePath As String
Dim CurrentImage As Integer
Dim SelectedImage As String
Dim Img As String
Private Function GetDBConnection()
' Compose the database file name.
' Modify this if the database is somewhere else.
Dim DBname As String = Application.StartupPath()
DBname = DBname.Substring(0, DBname.LastIndexOf("\bin"))
DBname = DBname & "\Images.mdf"
' Compose the connect string.
Dim connect_string As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=" & _
DBname & ";Integrated Security=True;User Instance=True"
' Open a database connection.
Dim SqlConn As New Data.SqlClient.SqlConnection(connect_string)
SqlConn.Open()
' Return the connection.
Return SqlConn
End Function
Private Sub LoadImages()
dsImage.Clear()
Try
conImage = GetDBConnection()
daImage.Fill(dsImage, "Images")
Catch ex As Exception
MsgBox(ex.Message)
End Try
conImage.Close()
conImage.Dispose()
Call PoChng()
End Sub
Private Sub PoChng()
If Me.ImagesBindingSource.Count = 0 Then
Label1.Text = "Empty Database"
Else
Label1.Text = (Me.ImagesBindingSource.Position + 1).ToString & " Of " & _
(Me.ImagesBindingSource.Count).ToString
End If
End Sub
Private Sub MoNext()
Me.BindingContext(dsImage, "Images").Position = Me.BindingContext(dsImage, "Images").Position + 1
Me.ImagesBindingSource.Position = Me.ImagesBindingSource.Position + 1
Call PoChng()
End Sub
Private Sub MoPre()
Me.BindingContext(dsImage, "Images").Position = Me.BindingContext(dsImage, "Images").Position + 1
Me.ImagesBindingSource.Position = Me.ImagesBindingSource.Position - 1
Call PoChng()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
picImage.Image = Nothing
txtImageFile.Text = ""
txtTitle.Text = ""
OpenFileDialog1.ShowDialog()
Dim sFilePath As String
sFilePath = OpenFileDialog1.FileName
If sFilePath = "" Then Exit Sub
If System.IO.File.Exists(sFilePath) = False Then
Exit Sub
Else
txtImageFile.Text = sFilePath
mImageFilePath = sFilePath
End If
End Sub
Private Sub GetImage()
Dim fs As FileStream = New FileStream(mImageFilePath.ToString(), FileMode.Open)
Dim img As Byte() = New Byte(fs.Length) {}
fs.Read(img, 0, fs.Length)
fs.Close()
mImageFile = Image.FromFile(mImageFilePath.ToString())
Dim imgHeight As Integer = picImage.Height 'mImageFile.Height
Dim imgWidth As Integer = picImage.Width 'mImageFile.Width
Dim imgLength As Integer = mImageFile.PropertyItems.Length
Dim imgType As String = Path.GetExtension(mImageFilePath)
mImageFile = Nothing
' image content
Dim pic As SqlParameter = New SqlParameter("@pic", SqlDbType.Image)
pic.Value = img
commImage.Parameters.Add(pic)
End Sub
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
'get sql connection
Try
conImage = GetDBConnection()
Dim sSQL As String = "INSERT INTO Images (Pic) VALUES(@pic)"
commImage = New Data.SqlClient.SqlCommand(sSQL, conImage)
Call GetImage()
commImage.ExecuteNonQuery()
'Me.ImagesTableAdapter.Update(Me.dsImage.Images)
MessageBox.Show("Image successfuly saved in database", "Image Load")
Catch ex As Exception
MsgBox(ex.Message)
End Try
commImage.Dispose()
' commImage = Nothing
conImage.Close()
conImage.Dispose()
Call LoadImages()
End Sub
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
SelectedImage = ("DELETE FROM Images WHERE ImageID = " & txtImageFile.Text)
conImage = GetDBConnection()
Try
commImage = New Data.SqlClient.SqlCommand(SelectedImage, conImage)
commImage.ExecuteNonQuery()
' Me.ImagesTableAdapter.Update(Me.dsImage.Images)
MsgBox("Image successfuly deleted from database", MsgBoxStyle.Information)
Catch ex As Exception
MsgBox(ex.Message)
End Try
commImage.Dispose()
commImage = Nothing
conImage.Close()
conImage.Dispose()
Call LoadImages()
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Call LoadImages()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Call MoPre()
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Call MoNext()
End Sub
i have drag and drop these
sql adapetr
sql connection
sql command
i have no problem with save and delete and i dont know which part of code do i need to post so i am posting all code here
waiting for your kind rep.
have a nice day
thank you
|
|
|
|