Showing posts with label write. Show all posts
Showing posts with label write. Show all posts

Monday, March 19, 2012

Bug MissingMethodException in application

Hello!

I wrote an application which runs correctly on my iPaq HP 5500 series. I used VB .Net 2003 to write it. I bougth a new Pocket PC iPaq HP hx 2790b. I deployed this application on my new Pocket PC. I get an exception when the application tries to execute this instruction "LEng = New SqlCeEngine("Data Source= " & AccessBase).". The exception is "MissingMethodException". I don't know what to do?


All the best,

Yang

Hello!

I wrote an application which runs correctly on my iPaq HP 5500 series. I used VB .Net 2003 to write it. I bougth a new Pocket PC iPaq HP hx 2790b. I deployed this application on my new Pocket PC. I get an exception when the application tries to execute this instruction "LEng = New SqlCeEngine("Data Source= " & AccessBase).". The exception is "MissingMethodException". I don't know what to do?


All the best,

Yang

|||

Hi Yang,

First of all your connection string does not look ok. Secondly can you check that SQL Compact is actually getting deployed to you PPC when you deploy the application? Also let me know which verison of SQL Compact are you using?

Manish Agnihotri

Program Manager

SQL Compact

|||

Just a few questions:

- Have you installed the same version of SQLCE?

- Which .NET Compact Framework are you using?

ow, and google is your friend :

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=679548&SiteID=1

Greetings from the rainy Netherlands

Wednesday, March 7, 2012

buffered trigger

Hallo i need to read/write data using triggers between two remote MSSQL2K servers, over an unstable connection.
Can trigger operations be buffered, so they are completed when connection is on?
Or should i make the triggers to write into local tables, then replicated in merge? (i would like to avoid this)

No. Trigger is part of the active transaction so if you have an unstable remote connection, I would suggest you queue your data into a worker queue table and process it later. I suggest you take a look at Service Broker in book online. It's designed for message queue/processing.

|||

This asyncronous read/write data can be resolved using SQL Service Broker a feature of SQL Server Express 2005 (that is free).

My ideea is :

1.The trigger of SQL2K1 server write the data in a Table1 of SQL2K1

2.SSSBroker get the data of Table1 in a Table2 from SSEXPRESServer in a Database1

3.From Table2 SSExpress copy data to SQL2K2

HTH

Monday, February 13, 2012

Break Apart Data Using While Loop

I need to break apart the following data into multiple records but I am not
sure how to write the code. The record identifier is the ;
RecordID DataInfo
1 "abc", "def"; "ghi", "jkl"
2 "abc", "def", "ghi"; "jkl", "mno"
Data in a new table will be
RecordID DataInfo
1 "abc", "def"
1 "ghi", "jkl"
2 "abc", "def", "ghi"
2 "jkl", "mno"
Thanks for the help!If the delimiter ; only appears once in the DataInfo column you could
do something like this...
Create Table #TableA
(
Record Integer,
DataInfo varchar(50)
)
Insert Into #TableA
Select 1, '"abc", "def"; "ghi", "jkl"'
Union
Select 2, '"abc", "def", "ghi"; "jkl", "mno" '
Create Table #TableB
(
Record Integer,
DateInfo Varchar(50)
)
Insert Into #TableB
Select Record, Replace((Ltrim(Rtrim(Left(DataInfo,
(CharIndex(';',DataInfo)))))), ';','')
>From #TableA
Union
Select Record, Replace((Ltrim(Rtrim(Right(DataInfo,
(CharIndex(';',Reverse(DataInfo))))))), ';','')
>From #TableA
Select * From #TableA
Select * From #TableB
Drop Table #TableA
Drop Table #TableB
HTH
Barry|||Sorry my example wasn't specific enough. The delimiter can appear multiple
times in the column.
"Barry" wrote:

> If the delimiter ; only appears once in the DataInfo column you could
> do something like this...
>
> Create Table #TableA
> (
> Record Integer,
> DataInfo varchar(50)
> )
> Insert Into #TableA
> Select 1, '"abc", "def"; "ghi", "jkl"'
> Union
> Select 2, '"abc", "def", "ghi"; "jkl", "mno" '
> Create Table #TableB
> (
> Record Integer,
> DateInfo Varchar(50)
> )
>
> Insert Into #TableB
> Select Record, Replace((Ltrim(Rtrim(Left(DataInfo,
> (CharIndex(';',DataInfo)))))), ';','')
> Union
> Select Record, Replace((Ltrim(Rtrim(Right(DataInfo,
> (CharIndex(';',Reverse(DataInfo))))))), ';','')
>
> Select * From #TableA
> Select * From #TableB
> Drop Table #TableA
> Drop Table #TableB
>
> HTH
> Barry
>|||
As an alternative you can use a numbers table
as in http://www.aspfaq.com/show.asp?id=2516
and can do this
select Record,
ltrim(substring(DataInfo,
Number,
charindex(';',
DataInfo + ';',
Number) - Number)) as DataInfo
from #TableA
inner join Numbers on Number between 1 and len(DataInfo) + 1
and substring(';' + DataInfo, Number, 1) = ';'|||Or regular expressions...
http://www.sqlservercentral.com/col...oolkitpart2.asp
"Anonymous" <Anonymous@.discussions.microsoft.com> wrote in message
news:37F08AA1-FC30-42C9-B50F-50B0FA9FD7B5@.microsoft.com...
>I need to break apart the following data into multiple records but I am not
> sure how to write the code. The record identifier is the ;
> RecordID DataInfo
> 1 "abc", "def"; "ghi", "jkl"
> 2 "abc", "def", "ghi"; "jkl", "mno"
> Data in a new table will be
> RecordID DataInfo
> 1 "abc", "def"
> 1 "ghi", "jkl"
> 2 "abc", "def", "ghi"
> 2 "jkl", "mno"
> Thanks for the help!
>

Sunday, February 12, 2012

BPA Questions

Does BPA only read the database being scaned?
How do I print the report?
I only have a copy button, where's the print button?
Does BPA write anything to the database being scanned?
Thanks
> Does BPA only read the database being scaned?
Yes

> How do I print the report?
You can use Copy Report and paste it into Word and print from that
There is also the option to use Reporting Services to report on the results
and you can print from that, save to PDF etc
There are examples of reports that come with it

> I only have a copy button, where's the print button?
I don't think there is one (see above)

> Does BPA write anything to the database being scanned?
No
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
news:3747E300-1A39-4F44-91ED-71487D15179C@.microsoft.com...
> Does BPA only read the database being scaned?
> How do I print the report?
> I only have a copy button, where's the print button?
> Does BPA write anything to the database being scanned?
> Thanks
>
|||Hi Guys,
I was playing with the BPA and looks good but found that it does not
check for the SA password when I change it to Null or modify it to be
blank.
Is it something wrong with my machine or BPA does not check the
passwords at all.
I thought the BPA should pick up the accounts which have blank
passwords or the same name etc and this should be on the top of list
for the BPA tool to do .
Let me know your thoughts guys.
Cheers
--Ramesh
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message news:<ur9jiI$aEHA.2840@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> Yes
> You can use Copy Report and paste it into Word and print from that
> There is also the option to use Reporting Services to report on the results
> and you can print from that, save to PDF etc
> There are examples of reports that come with it
> I don't think there is one (see above)
> No
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Robert Salazar" <RobertSalazar@.discussions.microsoft.com> wrote in message
> news:3747E300-1A39-4F44-91ED-71487D15179C@.microsoft.com...
|||Hi Ramesh
BPA currently does not have any security checks. To do security you can use
Baseline Security Analyzer (http://www.microsoft.com/mbsa )
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"rams" <ramesh_sql@.yahoo.com> wrote in message
news:5ea6b47e.0407191828.41423a18@.posting.google.c om...
> Hi Guys,
> I was playing with the BPA and looks good but found that it does not
> check for the SA password when I change it to Null or modify it to be
> blank.
> Is it something wrong with my machine or BPA does not check the
> passwords at all.
> I thought the BPA should pick up the accounts which have blank
> passwords or the same name etc and this should be on the top of list
> for the BPA tool to do .
> Let me know your thoughts guys.
> Cheers
> --Ramesh
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:<ur9jiI$aEHA.2840@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
results[vbcol=seagreen]
message[vbcol=seagreen]

Friday, February 10, 2012

Border Disappears

When I write an expression for the visability of a cell, I am finding that
the border disappears when Hide = True. I don't really want the cell to
disappear, just the text contained within it. And I want the border to always
show up.
Any ideas how I can make this happen?
Thanks,
LisaI can think of two solutions;
It is probably easier to put the test on the contents, so in the value
property use a test something like this;
=IIf(Parameters!HideValues.Value, "", Fields!MyField.Value)
If you want to hide background colours too, use this method in the
backgroundcolor property. In fact use this method almost anywhere, I
use it heavily.
This next one is a bit of hack I'm afraid. Create a rectangle object
outside the table, inside the rectangle place a textbox. Rename it to
something more recognisable. Now cut and paste the rectangle into the
cell in the table you want. Now you can hide just the textbox inside
the rectangle without affecting the cell itself.
Chris
Lisa wrote:
> When I write an expression for the visability of a cell, I am finding
> that the border disappears when Hide = True. I don't really want the
> cell to disappear, just the text contained within it. And I want the
> border to always show up.
> Any ideas how I can make this happen?
> Thanks,
> Lisa|||You could try writing an expression to change the font colour to the same as
the cell background colour...
"Lisa" wrote:
> When I write an expression for the visability of a cell, I am finding that
> the border disappears when Hide = True. I don't really want the cell to
> disappear, just the text contained within it. And I want the border to always
> show up.
> Any ideas how I can make this happen?
> Thanks,
> Lisa|||This would work but if you were to highlight the cell by dragging the
cursor across you would see what's in it.
Chris
Mary Bray [SQL Server MVP] wrote:
> You could try writing an expression to change the font colour to the
> same as the cell background colour...
> "Lisa" wrote:
> > When I write an expression for the visability of a cell, I am
> > finding that the border disappears when Hide = True. I don't
> > really want the cell to disappear, just the text contained within
> > it. And I want the border to always show up.
> >
> > Any ideas how I can make this happen?
> >
> > Thanks,
> >
> > Lisa|||Hi Lisa
if you want the text to disappear you should erase the text from the cell.
Markus
"Lisa" wrote:
> When I write an expression for the visability of a cell, I am finding that
> the border disappears when Hide = True. I don't really want the cell to
> disappear, just the text contained within it. And I want the border to always
> show up.
> Any ideas how I can make this happen?
> Thanks,
> Lisa|||This is not a good idea Mary, I have already seen that the color of the text
in textboxes does have influence on PDF generation.
I put lots of textboxes in the head area of a table and when setting the
textcolor=backcolor the generated PDF looked another way as it looked with
visible text in the boxes.
Markus
"Mary Bray [SQL Server MVP]" wrote:
> You could try writing an expression to change the font colour to the same as
> the cell background colour...
> "Lisa" wrote:
> > When I write an expression for the visability of a cell, I am finding that
> > the border disappears when Hide = True. I don't really want the cell to
> > disappear, just the text contained within it. And I want the border to always
> > show up.
> >
> > Any ideas how I can make this happen?
> >
> > Thanks,
> >
> > Lisa