Database Discussion Boards

Mega124-Jul-09 2:35

24-Jul-09 2:35

I have a customer who refuses to move from an old version of Great Plains 'pre-microsoft' on a novell server using Btrieve 6.15. I am looking for help/advice to make a small VB app that will let them query and print a listing from a specific DAT file. This is being done on a local copy of the data 'not live' on an XP machine. While not new to Vb, I only use it to play and relax 'just don't have the time any more'. I will be using VB 2008 and I guess I need help with the following:

1. What files will I need for the connection to this type of data?

2. What would the connection string look like.

I think those should be my only problems.

Thanks in advance and all help is greatly appriciated.

Re: Novell, Btrieve and data access

Mycroft Holmes24-Jul-09 16:14

Mycroft Holmes

24-Jul-09 16:14

Try connectionstrings.com

Never underestimate the power of human stupidity
RAH

PageBreak not rendered in Web Archive in SSRS

Member 461901624-Jul-09 1:32

Member 4619016

24-Jul-09 1:32

Hi

I am facing an issue in page break when the report is rendered as web archive in SSRS. I have applied PageBreak for the report on a group. This page break is rendered correctly when I view the report in PDF but the page break doesnt come when rendered in Web Archive.

Is there any way to apply Page Break to web archive?? I cant use InteractiveHeight for the pagebreak.

Please help ...

Thanks.

sanky

Re: PageBreak not rendered in Web Archive in SSRS

Eddy Vluggen24-Jul-09 4:39

Eddy Vluggen

24-Jul-09 4:39

I don't know about SSRS, but a webarchive is in fact just a webpage. It's kinda difficult to put a page-break in a webpage, but this[^] site might help.

Good luck Smile | :)

error 40 : named pipes

saeidfarahi23-Jul-09 22:57

saeidfarahi

23-Jul-09 22:57

i have this connection string in one of my applications but i got the famous
erro 40 . i tried many forums and found many suggestions but none of them could help!

string _connectionstring =
"server=" + Environment.MachineName +";Initial Catalog=myDatabase;"+
"user id=myLogin;password=myPassword;trusted_connection = true;";

please notice that this application works on local computer , not a network. OMG | :OMG:

Re: error 40 : named pipes

Muhammad Mazhar23-Jul-09 23:42

Muhammad Mazhar

23-Jul-09 23:42

Open surface area configurations of SQL server and allow remote connections. It seems that you haven't enabled them up till now that's why network users can't connect to your database.

Share your experience with others
Check my Blog...

Parameters problem

jonhbt23-Jul-09 19:35

jonhbt

23-Jul-09 19:35

I am running the following MS ACCESS select command from a c# method.

SELECT USERINFO.USERID, CHECKINOUT.CHECKTIME, CHECKINOUT.CHECKTYPE, DEPARTMENTS.DEPTNAME, USERINFO.NAME FROM (CHECKINOUT INNER JOIN USERINFO ON CHECKINOUT.USERID = USERINFO.USERID) INNER JOIN DEPARTMENTS ON USERINFO.DEFAULTDEPTID = DEPARTMENTS.DEPTID WHERE CHECkINOUT.CHECKTIME BETWEEN @fromDate and @toDate " + sensors + "ORDER BY DEPARTMENTS.DEPTNAME;"

The problem is that the parameters that I am passing, which are in date format are throwing an ivalid criteria exception. This is how I am passing the parameters

cmd.Parameters.AddWithValue("fromDate", todayDate);
     cmd.Parameters.AddWithValue("toDate", tomorrowDate);

Can one identify why it is telling me ivalid criteria when the values should be dates?

Re: Parameters problem

Abhijit Jana23-Jul-09 19:49

Abhijit Jana

23-Jul-09 19:49

jonhbt wrote:
The problem is that the parameters that I am passing, which are in date format are throwing an ivalid criteria exception. This is how I am passing the parameters

cmd.Parameters.AddWithValue("fromDate", todayDate);
cmd.Parameters.AddWithValue("toDate", tomorrowDate);

You didn't use @ with the parameter.
Here is you modified code,

cmd.Parameters.AddWithValue("@fromDate", todayDate);
     cmd.Parameters.AddWithValue("@toDate", tomorrowDate);

This will help you Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: Parameters problem

jonhbt23-Jul-09 19:58

jonhbt

23-Jul-09 19:58

It didn't work either it is showwing me the following error.

{System.Data.OleDb.OleDbException: Data type mismatch in criteria expression

Re: Parameters problem

DoctorMick24-Jul-09 0:08

DoctorMick

24-Jul-09 0:08

If you step through the code and hover over todayDate and tomorrowDate what are there values?

Re: Parameters problem

Baran M24-Jul-09 0:16

Baran M

24-Jul-09 0:16

Do you find any difficulties to use Add() Function,
cmd.Parameters.Add("@fromDate", SqlDbType.System.Data.SqlDbType.Date)

cmd.Parameters.Item(0).Value = todayDate;

Using Add() function you can avoid datatype conflicts here.

Education is not a way to escape poverty — it is a way of fighting it.

Generate report snapshot programatically in SQL Reporting Services

sunit_8223-Jul-09 12:44

sunit_82

23-Jul-09 12:44

To explain the problem definition let me take a simple example. Lets say I have a report with Year as the parameter. So when i go to the report i have to select the year from a dropdownlist and click 'View report' button to view the report. assuming that for each year there are millons of records, I don't want to wait for long time for the report to show.

I know there is a caching and snapshot history features in SQL reporting services. But in both ways it would cache or save snapshot of report only for default value of parameter specified or for a particular report requested with selected parameter. It will not cache or snapshot for all possible parameter combinations. In my example i have taken only one parameter 'Year' and it may have lets say 10 values(2000-2009). But if i have another report with 'Year' and 'Month' parameters, then there would be 120 (10x12) possible reports combinations.

So my requirement is to some how(programatically or using web service or any other way) cache or snapshot all these possible reports using various combinations of parameters for a particular report.
Also would like to mention that the possible values for a parameter may also come from database. Like for 'Year' we might get the various values possible from a table in our database.

This requirement is so that user do not have to wait for long time when he requests a report with any parameter selected. This is to be done using SQL Reporting Services. Cheers! Thumbs Up | :thumbsup:

s.a.w.

Re: Generate report snapshot programatically in SQL Reporting Services

Mike Ellison24-Jul-09 4:10

Mike Ellison

24-Jul-09 4:10

This sounds like the kind of thing you may want to do with a cube and Analysis Services. And here's a link to a blog post describing how to then integrate the .mdx query in Reporting Services.

http://joeblog.homnick.com/Lists/Posts/Post.aspx?List=db4a6966%2D2b11%2D448d%2Da4ba%2D1550e74c89ba&ID=33[^]

MishaInTheCloud.blogspot.com

SQL Stored procedure help

cdietschrun23-Jul-09 8:30

cdietschrun

23-Jul-09 8:30

Can someone tell me what's wrong with this code? Basically the sp takes in one parameter and is creating a new record in tbl_swbom_checklist the values, with the package variable being set by the parameter, the rest being set by tbl_swbom_checklist_template entries.

CREATE PROCEDURE dbo.sp_CreateChecklistForPackage 
(
@PACKAGE varchar(255)
)
AS 

INSERT INTO TBL_SWBOM_CHECKLIST
(
PACKAGE,
TEMPLATEOWNER,
STEPNUMBER,
STEPNAME,
DESCRIPTION,
LASTCHANGE,
LASTCHANGEBY
)
values
(
@PACKAGE,
SELECT
TEMPLATEOWNER,
STEPNUMBER,
STEPNAME,
DESCRIPTION,
LASTCHANGE,
LASTCHANGEBY
FROM SWManagement.dbo.TBL_SWBOM_CHECKLIST_TEMPLATES
)
GO

Re: SQL Stored procedure help

Ashfield23-Jul-09 8:34

Ashfield

23-Jul-09 8:34

Try this

INSERT INTO TBL_SWBOM_CHECKLIST
(
PACKAGE,
TEMPLATEOWNER,
STEPNUMBER,
STEPNAME,
DESCRIPTION,
LASTCHANGE,
LASTCHANGEBY
)
select
@PACKAGE,
TEMPLATEOWNER,
STEPNUMBER,
STEPNAME,
DESCRIPTION,
LASTCHANGE,
LASTCHANGEBY
FROM SWManagement.dbo.TBL_SWBOM_CHECKLIST_TEMPLATES

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: SQL Stored procedure help

cdietschrun23-Jul-09 9:35

cdietschrun

23-Jul-09 9:35

With that one, I get an error I had before in my ASP page from calling this procedure:

"Conversion from string "" to type 'Double' is not valid."

Does that mean some of the types of the columns in the databases don't match? Also confusing to me is that none of the columns are of type string or double. (I'm fairly new to SQL)

Thanks kindly for your help.

Re: SQL Stored procedure help

cdietschrun23-Jul-09 9:48

cdietschrun

23-Jul-09 9:48

Actually, nevermind, I figured it out. Thanks!

Concurrency Issue - Restict Select query ( view) till another user modifies it.

meerabhuva23-Jul-09 4:07

meerabhuva

23-Jul-09 4:07

How do I check that or restrict the row to be selected if same row is modified by other user.

For eg. I have created following table.

Consider below tables;
1. Bills Table
Fields Description

BillNo - Bill No Unique (Primary) - No duplicates allowed.
Customer - Customer Name -Non Blank
BillAmt - Bill Total -Not Empty & Only Positive Values
Collected - Collection Done against this bill No Negative Values & shud never be more than BillAmt

2. Collection Table
Fields Description

RcptNo - Receipt No. Unique (Primary) - No duplicates allowed.
RcptAmt - Receipt Total - Cheque / Collection Value.

3. Col_Ref Table - Collection Reference, A Child Table for Collection to store its referred (multiple) bills.
Fields Description

RcptNo - Receipt No. Unique (Primary) - No duplicates allowed.
Ref_BillNo - Referred Bill No.
Ref_Billamt - Referred Bill Amount

I have some records. for eg.
1) I have Bill no. 00001 with amount 10,000/- in Bills Table.

At the same time another user is accessing Collection Table and referring the same Bill no. and accepts receipts and updating amount in Collection table in Bills table.

If user is accessing Bill number he will not get actual amount of collection so i want to restict user for viewing the Bill number which is getting modified by another user using Receipt option in web application. The back end will sql server 2005. How do I do that ?

Before allowing the Edit, Check if the record this invoice is not locked, only then lock the same & allow editing of this entry only for the Invoice Amount & later on <> / <> release the lock. Otherwise Pop message "Update is in progress for this entry, try again later..."

Please guide.

Thanks in advance.

Re: Concurrency Issue - Restict Select query ( view) till another user modifies it.

David Mujica23-Jul-09 4:29

David Mujica

23-Jul-09 4:29

You may want to consider using your own locking logic with the help of "sp_getapplock".

http://msdn.microsoft.com/en-us/library/ms189823.aspx[^]

Be very careful when implementing a locking strategy you may bring your entire application to a screeching halt if locks are not released in a timely manner.

You may want to use the sp_getapplock as a method to warn users that a particular account is being updated and not place any hard locks. You could also use this to indicate who has the "lock".

Good luck.

update table with split function

jrsreenivas23-Jul-09 3:44

jrsreenivas

23-Jul-09 3:44

hi Friends i have a problem

i have a two tables
1.Customer
2,Purchases

customer table has [ Customer_id(int),name(varchar)]
purchases table has [ purchase_no(int)(identity),Customer_id(int),Delivered(bool)]

i will all the custmor_id's in string format
and i want to update the delivered field in the purchases table with bool =1 and
customer_id with split function

i am using this query - where fnSlplit is spliting the customer_id
into table format but not updating the purchases table

UPDATE purchases SET Delivered= 1
INNER JOIN dbo.fnSplit(@CustomerList,',') AS S
ON
REDEMPTION_CODE = S.ID
WHERE REDEMPTION_CODE = S.ID

please help to solve this problem.

Re: update table with split function

leckey23-Jul-09 10:10

leckey

23-Jul-09 10:10

I could be wrong, but I think you need to do the split function first, store that in a variable, and then use that variable for the update. You have S.ID in the inner join and in the where clause--you need one or the other.

I have not tried this, but something along these lines:

DECLARE @newCustID VARCHAR(10)
SET @newCustID = dbo.fnSplit(@CustomerList,',')

UPDATE purchases SET Delivered = 1
WHERE REDEMPTION_CODE = @newCustID

Hope it helps.

Back in the blog beatch!
http://CraptasticNation.blogspot.com/[^]

Re: update table with split function

Robin_Roy27-Jul-09 17:25

Robin_Roy

27-Jul-09 17:25

Which Version of SQL Server are you using.
In SQL Server 2008, you can pass Table Value Parameter to your stored procedure and in such a case no need to pass delimited string of ID's.

If not, you need to create a Table Variable and store the IDs in the Table Variable first using the Split UDF and then use the same in the statement. Also you can iterate through your table of IDs and then update the purchases table.

MSMQ Performance Monitoring

UmaMahesh suda23-Jul-09 3:08

UmaMahesh suda

23-Jul-09 3:08

Hi

This is Mahesh, working as a technical Lead for performance testing & engineer activities.

Currently I am working on e -learning application which was developed in .net & Classic ASP.

During performance testing I am facing some issues with MSMQ performance for overloaded of messages.

I need to monitor the applciation for MSMQ is there any freeware performance monitoring tools available in the market.

What are basic performance counters needs to monitor for MSMQ?

If anyone has the exp in MSMQ please share with me.

I am awaiting for your kind response.

Thank you,
Mahesh

Re: MSMQ Performance Monitoring

leckey23-Jul-09 10:14

leckey

23-Jul-09 10:14

Google MSMQ Monitor--you will find lots of helpful results there.

Back in the blog beatch!
http://CraptasticNation.blogspot.com/[^]

ExecuteScalar()

sandhya1422-Jul-09 22:08

sandhya14

22-Jul-09 22:08

hi all,

this is my oracle StoredProcedure

PROCEDURE PEAP_SelectActiveYear
(
Cur_RCT1 OUT GLOBALPKG.RCT1
)
AS
BEGIN

OPEN Cur_RCT1 FOR
SELECT ActiveYear
FROM PeapParameters;
RETURN;
END;

in the code am trying to fetch the value using ExecuteScalar()

but not retrieving
Frown | :-(

Anything need to be changed to the procedure?

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