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

Bug Maybe: Consecutive White Spaces Disappeared.

Hi,
When the report comes from the server (ie: not from the preview in
VS.Net) the consecutive white spaces in values are lost. Only one
white space is left. They are shown correctly in the preview though.
Example:
the value of a field expression is: ="xxx yyy"
the browser shows: "xxx yyy".
Is there work around this or it's a bug?
Thanks in advance.
DanniNever mind.
It started to work but I don't know what got changed.

Browser time out: when executing a DTS package

Hello All,
I am am having a strange problem. I am trying to execute a DTS package
from VB .NET (.aspx) page. The DTS package takes 21 minutes to execute.
When the aspx page sends a command to MS SQL server to execute this DTS
package it starts executing. After 8 minutes the .aspx page shows error
"Cannot Find Server" and errors out with a white screen. The
inetresting thing is the DTS package is still being executed in backend
and completes execution successfully.
I have no clue why this is happening because there are other DTS
packages that I am executing through the same .aspx page that takes
about 3 minutes to complete execution and are working absolutely fine.
By the way I have a stored procedure wrapper over every DTS package. So
when i have to execute a DTS package I execute a stored which inturn
executes a DTS package.
Thanks for reading my query. If you have any suggestions please let me
know.
Thank you in advance.The aspx page (or the command object, or whatever you are using to execute
the stored procedure) has a timeout property. When the timeout value is
reached the web page times out.
Can you increase the timeout for that one database call?
Keith Kratochvil
"Al-Pacino" <dipenshahis@.yahoo.com> wrote in message
news:1142435924.265991.289090@.e56g2000cwe.googlegroups.com...
> Hello All,
> I am am having a strange problem. I am trying to execute a DTS package
> from VB .NET (.aspx) page. The DTS package takes 21 minutes to execute.
> When the aspx page sends a command to MS SQL server to execute this DTS
> package it starts executing. After 8 minutes the .aspx page shows error
> "Cannot Find Server" and errors out with a white screen. The
> inetresting thing is the DTS package is still being executed in backend
> and completes execution successfully.
> I have no clue why this is happening because there are other DTS
> packages that I am executing through the same .aspx page that takes
> about 3 minutes to complete execution and are working absolutely fine.
> By the way I have a stored procedure wrapper over every DTS package. So
> when i have to execute a DTS package I execute a stored which inturn
> executes a DTS package.
> Thanks for reading my query. If you have any suggestions please let me
> know.
> Thank you in advance.
>|||Hi Keith,
I tried setting the time out for the command object but it still does
not work right.
It has the exact same behaviour.
Keith Kratochvil wrote:
> The aspx page (or the command object, or whatever you are using to execute
> the stored procedure) has a timeout property. When the timeout value is
> reached the web page times out.
> Can you increase the timeout for that one database call?
> --
> Keith Kratochvil
>
> "Al-Pacino" <dipenshahis@.yahoo.com> wrote in message
> news:1142435924.265991.289090@.e56g2000cwe.googlegroups.com...

Browser Time Out: when executing a DTS package

Hello All,

I am am having a strange problem. I am trying to execute a DTS package
from VB .NET (.aspx) page. The DTS package takes 21 minutes to execute.

When the aspx page sends a command to MS SQL server to execute this DTS

package it starts executing. After 8 minutes the .aspx page shows error

"Cannot Find Server" and errors out with a white screen. The
inetresting thing is the DTS package is still being executed in backend

and completes execution successfully.

I have no clue why this is happening because there are other DTS
packages that I am executing through the same .aspx page that takes
about 3 minutes to complete execution and are working absolutely fine.

By the way I have a stored procedure wrapper over every DTS package. So

when i have to execute a DTS package I execute a stored which inturn
executes a DTS package.

Thanks for reading my query. If you have any suggestions please let me
know.

Thank you in advance.Hi

Have you though about doing this through a job and not waiting?

John

"Al-Pacino" <dipenshahis@.yahoo.com> wrote in message
news:1142436273.071208.313680@.e56g2000cwe.googlegr oups.com...
> Hello All,
> I am am having a strange problem. I am trying to execute a DTS package
> from VB .NET (.aspx) page. The DTS package takes 21 minutes to execute.
> When the aspx page sends a command to MS SQL server to execute this DTS
> package it starts executing. After 8 minutes the .aspx page shows error
> "Cannot Find Server" and errors out with a white screen. The
> inetresting thing is the DTS package is still being executed in backend
> and completes execution successfully.
>
> I have no clue why this is happening because there are other DTS
> packages that I am executing through the same .aspx page that takes
> about 3 minutes to complete execution and are working absolutely fine.
>
> By the way I have a stored procedure wrapper over every DTS package. So
> when i have to execute a DTS package I execute a stored which inturn
> executes a DTS package.
>
> Thanks for reading my query. If you have any suggestions please let me
> know.
>
> Thank you in advance.

Browse through a list of databases on a given server

Hi,
I would like to allow the user of my ADO.NET application to browse through a list of the available databases on a given server. INFORMATION_SCHEMA in SQL Server Books Online doesn't describe how to do this. How can I do this?
TIA,
RoyceSELECT * FROM master..sysdatabases|||In VB6,use traditional adodb object.We can get any level schema infomation of sql server by OpenSchema method.
I pasted VB6 sample codes ,hope it should be helpful to u.

example:
Dim cn As New ADODB.Connection
Dim rs As ADODB.Recordset

cn.Open "Provider=SQLOLEDB.1;Password="""";Persist Security Info=True;User ID=sa;Data Source=wmcw"
Set rs = cn.OpenSchema(adSchemaCatalogs)

Do While Not rs.EOF
Debug.Print rs.Fields("CATALOG_NAME").Value & vbTab & rs.Fields("DESCRIPTION").Value
rs.MoveNext
Loop

Bother switching from MSDE to Access database?

We wrote our .Net 2.0 application using MSDE.
However, the demo programs we have sent out
many times have trouble installing MSDE on the
customer's computer.
We are thinking about converting our database from
MSDE to access because of this practical problem.
The question is this:
Will the sql server 2005 replacement for MSDE have
an easier time installing than MSDE?
thanks in advance
jay
jay w
jay,
I'll let the SQL Server experts here address the installation issues of SQL
Express. My limited experience with Express is that it is an easier install.
But if you're considering Access I thought you might be interested in SQL
Server Compact Edition:
http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=en
Although the current download is RC1, release is expected for the first week
in December. Installation can be as simple as copying a few DLLs and a
database is a single file, but you would need to change your .NET 2.0 code
slightly to use the SqlCe namespace rather than SqlClient. SQL Compact also
does not support stored procedures or triggers, but then neither does
Access.
Ginny Caughey
Device Application Development MVP
"jay w" <jayw@.discussions.microsoft.com> wrote in message
news:CBD1EFCA-92AD-49C4-958F-B1CB061DA6CD@.microsoft.com...
> We wrote our .Net 2.0 application using MSDE.
> However, the demo programs we have sent out
> many times have trouble installing MSDE on the
> customer's computer.
> We are thinking about converting our database from
> MSDE to access because of this practical problem.
> The question is this:
> Will the sql server 2005 replacement for MSDE have
> an easier time installing than MSDE?
> thanks in advance
> jay
> --
> jay w
|||For SQL Express the setup has been completely rewritten but it still uses
the Windows installer technology so there are places where it can fail. For
demo purposes you might want to look at SQL Server Compact Edition. It is
smaller and simpler than SQL Express or Access. It doesn't have all the
features of SQL Server Express but it is more compatible than Access would
be.
http://msdn2.microsoft.com/en-us/library/ayee3tzx.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"jay w" <jayw@.discussions.microsoft.com> wrote in message
news:CBD1EFCA-92AD-49C4-958F-B1CB061DA6CD@.microsoft.com...
> We wrote our .Net 2.0 application using MSDE.
> However, the demo programs we have sent out
> many times have trouble installing MSDE on the
> customer's computer.
> We are thinking about converting our database from
> MSDE to access because of this practical problem.
> The question is this:
> Will the sql server 2005 replacement for MSDE have
> an easier time installing than MSDE?
> thanks in advance
> jay
> --
> jay w
|||This article may provide you some pointers about using Unattended
installations with SQL Server.
SQL Server 2005 UnAttended Installations
http://www.devx.com/dbzone/Article/31648
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"jay w" <jayw@.discussions.microsoft.com> wrote in message
news:CBD1EFCA-92AD-49C4-958F-B1CB061DA6CD@.microsoft.com...
> We wrote our .Net 2.0 application using MSDE.
> However, the demo programs we have sent out
> many times have trouble installing MSDE on the
> customer's computer.
> We are thinking about converting our database from
> MSDE to access because of this practical problem.
> The question is this:
> Will the sql server 2005 replacement for MSDE have
> an easier time installing than MSDE?
> thanks in advance
> jay
> --
> jay w

Both Versions of .NET & Reporting Services

I have a windows 2000 SP4 server on which I have installed Reporting Services
but keep getting a "Access Denied 401" error.
Could this be because I am running both versions of .NET
.net 1.0 SP1
.net 1.1
?
--
EdgarNot as long as ASP.NET is using the latest version (1.1). You might try
aspnet_regiis -i in the 1.1 directory.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:769E4D70-3104-4D12-AE5C-690664353C7C@.microsoft.com...
>I have a windows 2000 SP4 server on which I have installed Reporting
>Services
> but keep getting a "Access Denied 401" error.
> Could this be because I am running both versions of .NET
> .net 1.0 SP1
> .net 1.1
> ?
> --
> Edgar|||Brian,
When I installed RS, the setup automatically put it in the "Default" Web
Site. I have since moved it to a different Web Site & Copied all the
permissions, etc. Does RS have to be on its on dedicated Web Site (Ip
Address) or can it simply be made part of a different web site as a new
Virtual Directory (mysite.com/Reports)?
"Brian Welcker [MS]" wrote:
> Not as long as ASP.NET is using the latest version (1.1). You might try
> aspnet_regiis -i in the 1.1 directory.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "mresanchez" <mresanchez@.donot-spam.com> wrote in message
> news:769E4D70-3104-4D12-AE5C-690664353C7C@.microsoft.com...
> >I have a windows 2000 SP4 server on which I have installed Reporting
> >Services
> > but keep getting a "Access Denied 401" error.
> >
> > Could this be because I am running both versions of .NET
> > .net 1.0 SP1
> > .net 1.1
> > ?
> > --
> > Edgar
>
>|||It can be in any web site. However, unless you are running Windows Server
2003, all application within a web site share the same version of the
frameworks (since there is only one worker process). On Windows Server 2003,
you can create multiple application pools with different versions of the
Frameworks and then assign applications to them.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:6620EDB4-04EB-4A1E-83DD-28153B2F02DB@.microsoft.com...
> Brian,
> When I installed RS, the setup automatically put it in the "Default" Web
> Site. I have since moved it to a different Web Site & Copied all the
> permissions, etc. Does RS have to be on its on dedicated Web Site (Ip
> Address) or can it simply be made part of a different web site as a new
> Virtual Directory (mysite.com/Reports)?
> "Brian Welcker [MS]" wrote:
>> Not as long as ASP.NET is using the latest version (1.1). You might try
>> aspnet_regiis -i in the 1.1 directory.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "mresanchez" <mresanchez@.donot-spam.com> wrote in message
>> news:769E4D70-3104-4D12-AE5C-690664353C7C@.microsoft.com...
>> >I have a windows 2000 SP4 server on which I have installed Reporting
>> >Services
>> > but keep getting a "Access Denied 401" error.
>> >
>> > Could this be because I am running both versions of .NET
>> > .net 1.0 SP1
>> > .net 1.1
>> > ?
>> > --
>> > Edgar
>>

both .net transaction and stored procedure transaction together

Hi ALL

I want to know that is it possible that i use the .net transaction and inside of that i use tha stored procedure transaction ,nested transaction with .net and stored procedure?

is it like the nested transaction in stored procedure that we use both 2 transactions in stored procedure or not ?

thanks

To use .NET code in SQL you need to enable CLR Integration via the Surface Area Configuration Utility. This need only be done once.

Next you need to compile your .NET assembly to a DLL. This DLL will be called into MS SQL.

From within MS SQL you load the assembly by using the statement:

CREATE ASSEMBLY <ass_name>
FROM '<path to dll>'

CREATE function <function name> (<any parameters>)
returns <any return value>
[with returns null on null input]
external name <ass_name>.[<dll ns.class>].<dll method>

The .NET assembly can be removed once it is pulled into MS SQL since the binary is from that point onwards referenced internally.

|||Shouldn't a transaction be atomic? Why would you use 2 transactions?|||

The transaction is atomic. Once you import the CLR code into the assembly (a one time processes) and you define the T-SQL function to call the imported code you have an atomic function.

The only difference is that MS SQL's internal .NET Framework will be running the code, rather than the T-SQL interpretur.

Hope this helps.

Al

|||

Thanks, but I was answering on the original question ;-)

|||SQL Server has no support for nested transactions. Nesting of transactions only increments @.@.TRANCOUNT and it is the final commit that has control over the outcome of the entire transaction. You should however take a look at the new TransactionScope class in .NET Framework 2.0 which has promotable transactions concept. It is not clear if you want to link the .NET transaction with the SQL transaction and this can be done by using the TransactionScope class i.e., if multiple resource managers are involved then transaction automatically becomes a distributed transaction.