Sql server 2000 reporting service cannot install - Database Discussion Boards

Adding or Substracting time spans from a DateTime SQL value

Den2Fly2-Nov-04 23:32

2-Nov-04 23:32

Hello every buddy,
How can I add for example some minutes to a datetime type value and get result again as a datetime?

Thank you so much,
- Den

---
"Art happens when you least expect it."

Re: Adding or Substracting time spans from a DateTime SQL value

Colin Angus Mackay3-Nov-04 0:09

Colin Angus Mackay

3-Nov-04 0:09

This example takes the current time and adds 5 minutes to it:

DATEADD(minute, 5, getdate())

The first arg is the date part (minute, hour, year, month, etc.)
The second arg is the amount you want to add (or for negative values, subtract)
The third argument is the source datetime.

Do you want to know more?

Re: Adding or Substracting time spans from a DateTime SQL value

Den2Fly3-Nov-04 12:15

Den2Fly

3-Nov-04 12:15

All I can do to appreciate now is to say thanks Smile | :)

---
"Art happens when you least expect it."

RecordSet vs DataSet

Salil Khedkar2-Nov-04 22:13

Salil Khedkar

2-Nov-04 22:13

An interview question again: Please tell me what is the difference between a ADO recordset and an ADO.NET dataset? Confused | :confused:

Salil Khedkar [^]

Trigger insert row

rudemusik2-Nov-04 19:21

rudemusik

2-Nov-04 19:21

Hello all!
I have created a trigger insert in a table. But I need to insert a row at a time. So every time the trigger fires, it only affects the next row, 1, 2, 3, ect. I know i can specify a a row, with a key id. But I need to make it so it goes to the next row automaticly. Any suggestions would be great!

Thanks
Rudy

Re: Trigger insert row

Alex Korchemniy3-Nov-04 13:54

Alex Korchemniy

3-Nov-04 13:54

Please clarify.

Are you saying that you need to support multirow inserts?? If so you can use @@rowcount to determine the number of rows being inserted and then use a cursor to process each row individualy.

This posting is provided "AS IS" with no warranties, and confers no rights.

Alex Korchemniy

hosted Access database & VS.net

hasanali002-Nov-04 1:24

hasanali00

2-Nov-04 1:24

Almost every example I have seen describe how to access Access database located on the local machine (C:/...)

But how do I work with Access database located on a hosted server. I would be grateful, if some can show how to connect to hosted Access databases using VS.net 2003.

Also, The follwoing command works fine with sqlCommand, but VS.net complaints when I try to use it with oleDbCommand. Any idea why?? CanI use stored procedures with Access?

INSERT INTO QR_Suppliers (SupplierName, QuestionID, Response, Comments) VALUES (@name, @question, @response, @comments)

regards

Sql server 2000 reporting service cannot install

Mekong River1-Nov-04 4:22

Mekong River

1-Nov-04 4:22

Hi, I download SQL server 2000 reporting service from http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en[^] then run the installation, but the message told me that its require SQL 2000 service pack 3a. Then I move to http://www.microsoft.com/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en[^] to donwload Ms sql 2000 service pack 3a and run setup as the instruction in this webpage.

But after I finish installing the service pack and return to install sql 2000 reporting service again, it still display a message that it require sql 2000 service pack 3a. Can any one help me to solve this problem? Because I alread install the service pack 3a but it still not work. Cry | :((

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

Re: Sql server 2000 reporting service cannot install

Dave Kreskowiak1-Nov-04 13:43

Dave Kreskowiak

1-Nov-04 13:43

This may seem like a dumb question, but did you reboot the SQL server after you installed SP3a? And, are you installing the Reporting Services as an administrator of the SQL Server?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Sql server 2000 reporting service cannot install

Mekong River1-Nov-04 15:58

Mekong River

1-Nov-04 15:58

Dave Kreskowiak wrote:
did you reboot the SQL server after you installed SP3a?

After installation I also reboot my machine and reboot SQL server service (at the system tray). But when I install, it still not working. But during the installation of sql sp3a I found the splash screen display sql 2000 service pack 3 not servic pack 3a. I don't know why, but I still continue because the file that I download get from the link of Microsoft Website.

Note: I used to install sql 2000 service pack 3 in the last 2 month, before I install the sp3a that i download from the internet yesterday.

Dave Kreskowiak wrote:
, are you installing the Reporting Services as an administrator of the SQL Server?

The user account that I use is the member of Administrators group. I think it is enough for me to install any application.

Any solution??? Confused | :confused:

A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

DTS - copying table data

shahar rr r31-Oct-04 4:43

shahar rr r

31-Oct-04 4:43

hi all,

i have a dts that copies table contents from remote server to local server.
remote table:
ItemID|name
1 |name1
2 |name22
3 |name33

local table:
ItemID|name
1 |name1
2 |name2

i want that the dts will only copy the new rows( aka. row with ItemID = 3) and leave the other rows as they are.
can any one help me create such a dts.

Re: DTS - copying table data

Jon Hulatt1-Nov-04 0:26

Jon Hulatt

1-Nov-04 0:26

You don't really want DTS. You want replication.

using System.Beer;

Re: DTS - copying table data

shahar rr r2-Nov-04 1:33

shahar rr r

2-Nov-04 1:33

dts and replication.. not the same?

how should i do this using replication?
please post some guide/tutorial/example.. thank you!

Wink | ;)

MSDE2000A.EXE Failes because of SQLREDIS.EXE

Blake V. Miller30-Oct-04 9:30

Blake V. Miller

30-Oct-04 9:30

I am setting up and MSDE Instance by using the Setup.Exe method (versus the MSI method).

The setup progresses just fine until it tries to run the SQLREDIS.EXE files.
Here is an exerpt from the verbose MSDE log file...

Starting custom action InstallSqlRedis<br />
Executing "F:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe /q:a"<br />
MSI (c) (BC:74): Font created.  Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg<br />
<br />
Installation of the Microsoft Data Access Components package failed.<br />
MSI (s) (3C!64): Product: Microsoft SQL Server Desktop Engine -- Installation of the Microsoft Data Access Components package failed.

I have manually preinstalled MDAC 2.8 and used Component Checker to verify everything is okay. Does anyone have any ideas what could be wrong?

The "F:\Program Files\Microsoft SQL Server" folder does not exist prior to nor after the setup is done/failed.

Re: MSDE2000A.EXE Failes because of SQLREDIS.EXE

Mike Dimmick1-Nov-04 2:53

Mike Dimmick

1-Nov-04 2:53

I searched for "sqlredis msde" and found this[^].

Hope it helps.

Stability. What an interesting concept. -- Chris Maunder

Re: MSDE2000A.EXE Failes because of SQLREDIS.EXE

Blake Miller2-Nov-04 8:21

Blake Miller

2-Nov-04 8:21

Yes, that was VERY helpful, and I thank you very much for that lead.

I think the problem, as others have found out, was that I was waiting on the process handle for the setup program to exit.

I will resort to examining the log file, and some other 'process ended tricks' to wait for the setup to finish instead of waiting on its handle.

Re: MSDE2000A.EXE Failes because of SQLREDIS.EXE

Blake V. Miller25-Jan-05 18:23

Blake V. Miller

25-Jan-05 18:23

Here is the solution for calling it from Visual C++...
Might help someone else out there... Sigh | :sigh:

	// Call Desktop Engine Setup.exe to install Desktop Engine<br />
	bSuccess = CreateProcess(<br />
		szSetupFilePath,<br />
		szCommandLine,<br />
		NULL,			// lpProcessAttributes<br />
		NULL,			// lpThreadAttributes<br />
		FALSE,			// do not inherit our handles<br />
		NORMAL_PRIORITY_CLASS,<br />
		NULL,			// Environment<br />
		NULL,			// current directory<br />
		&startinfo,<br />
		&procinfo<br />
		);<br />
<br />
	if( !bSuccess ){<br />
		m_ErrorWindows = ::GetLastError();<br />
		TRACE("MSDE Setup.Exe CreateProcess Error Code = %lu\r\n", m_ErrorWindows);<br />
		goto FuncExit;<br />
	}<br />
<br />
	// must use duplicated handle because the jacked up Microsoft setup will hang on the<br />
	// SQL tools setup if you are waiting on the handle returned by CreateProcess<br />
	hProcess = OpenProcess(SYNCHRONIZE|PROCESS_QUERY_INFORMATION, FALSE, procinfo.dwProcessId);<br />
<br />
	// so close theswe two handes so the jacked up Microsoft setup will not get hung<br />
	CloseHandle(procinfo.hProcess);<br />
	procinfo.hProcess = 0;<br />
	::CloseHandle(procinfo.hThread);<br />
	procinfo.hThread  = 0;<br />
<br />
	// wait several minutes for process to exit<br />
	// on my system, this only takes about 15 seconds or less<br />
	// 10 * (60 seconds per minute) * (1000 milliseconds per second)<br />
	dwWaitResult = ::WaitForSingleObject(hProcess, 10 * 60 * 1000);<br />
	TRACE("MSDE Setup.Exe Wait Result Code = %lu\r\n", dwWaitResult);<br />
<br />
	::GetExitCodeProcess(hProcess, &m_MsdeExitCode);<br />
	TRACE("MSDE Setup.Exe Exit Code = %lu\r\n", m_MsdeExitCode);

Performance solution for DataSet application with large numbers of records

Aron van Ammers30-Oct-04 6:49

Aron van Ammers

30-Oct-04 6:49

Hello,

I am building a Windows Forms .NET application entirely using typed DataSets. It is a straightforward administration application which does CRUD and some more for many tables in a database. The strategy we have followed on data access is to get all records to the client, then use them. So the Windows Forms application running on the client PC always has a complete set of records, reflecting the database. To save updates we use the GetChanges() method, so only updates are sent to the data layer. To keep the data current, the DataSets are regularly refreshed from the database.

Working entirely with typed DataSets in the presentation layer has many advantages. The basic functionality for scrolling through a table, editing records, filtering, selecting, is all there. DataSets have their peculiarities, but once you have learned to handle these, DataSets are just a pleasure to work with.

Now introducing my problem: performance with large numbers of records. All is well with tables of <10000 records. Data is loaded in couple of seconds and the performance on the client side is definitely sufficient. One part of the application however has a much larger number of records. One table has about 200000 records, and a related table has about 600000. Filling the typed DataSet with these tables works, but it takes over a minute to complete. Furthermore the performance of the application when working with this DataSet is far too low, even on modern hardware. E.g. finding a row takes seconds, not milliseconds.

I realize it's foolish to think that it is good practice to load such a large database entirely to the clients. However, I want to use the power of DataSets. How can I do this, without requiring enormous changes to the application? Any hints on and links to best practices to handle this situation would be greatly appreciated.

Regards,
Aron van Ammers

money datatype insert problem

webhay29-Oct-04 14:07

webhay

29-Oct-04 14:07

Hi there ,

i use c# to insert a money data type from a textbox but it give an exception :

i used SqlMoney.Parse(textbox.text.trim()) it dosnt work

the exception is :
Disallowed implicit conversion from data type varchar to data type money

thanks
Haytham

Re: money datatype insert problem

Aron van Ammers30-Oct-04 6:55

Aron van Ammers

30-Oct-04 6:55

How is the number formatted in the textbox? I use this to convert the string "€ 1,90" to the decimal 1.9:

Decimal.Parse(cevent.Value.ToString(), NumberStyles.Currency, null);

cheers,
Aron

Accessing DB2 using ADO.Net, C#

shri300928-Oct-04 20:42

shri3009

28-Oct-04 20:42

I am not getting any idea how to connect to the DB2 database. Can anyone give me ideas about it?

Re: Accessing DB2 using ADO.Net, C#

28-Oct-04 22:11

<%@ Page Language="c#" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
import these things

1.write your sql statement
2.open a connection like this: OleDbConnection myConn = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db2.mdb"));
this will connect to DB2
(And if you want further assistance my suggestion is read a book )
leo

update dataset with changes in database

CNU28-Oct-04 16:19

CNU

28-Oct-04 16:19

Hi,

I am getting some data from database to a dataset, binding it with a datagrid and everything works fine. Now the task ahead is like this :

The database may be changed by other user/server. Then I will get an alert. On reciving the alert I have to update the display in the datagrid. Since there are many rows in the datagrid, I cannot reload it again. So, I want read only the updated row from the database to dataset (I know which row is updated..like I know the primary key filed value)and update the data in the datagrid.

Any ideas? An example would be great!

Cheers
CNU

No value given for ine or more given requirements

jlawren728-Oct-04 14:56

jlawren7

28-Oct-04 14:56

heres the statement

Private Sub CmdSQL_Click()<br />
    Dim strSearchLName, strSearchFName As String<br />
    strSearchLName = txtSearchLName.Text<br />
    strSearchFName = txtSearchFName.Text<br />
    adoRecords.RecordSource = "Select * FROM Users Where (Last_Name) = '" & strSearchLName & "' AND (FName) = '" & strSearchFName & "' "

the varibles are getting the correct information. if i search with 1 varible, there isn't a problem.

Any ideas???
here are the order of steps:
user enters their first name & Last Name into text boxes.
they click a button a screen pops up, showing their contact info. then the log in form shows and they need to click th log in button right now, all the contacts in the contacts table are showing but if i search with only the last name, it only shows the correct contact in the form.

Re: No value given for ine or more given requirements

Edbert P28-Oct-04 21:21

Edbert P

28-Oct-04 21:21

If you only put last name, the SQL statement will be like

SELECT * FROM Users WHERE Last_Name = 'LName' AND FName = ''

Most likely it won't return you anything as there won't be a person with FName = ''
The easiest way is to use AND FName LIKE'" & strSearchFName & "%'"
The recommended way is to make sure your SQL is correct (build a dynamic SQL, e.g. remove FName from condition if FName is not supplied)

Hope it helps,

Edbert P.
Sydney, Australia.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.