"Shaun Wilde" <shaun_wilde@nospam.co.uk> wrote in message
news:eX1vuJ4hDHA.1172@TK2MSFTNGP09.phx.gbl...
> I get the following exception when using the CF SP2 on the emulator when
> trying to use
> GetInsertCommand or GetUpdateCommand
>
> I do NOT get this exception when using the original framework as deployed
by
> VS.NET 2003
>
> First Error
>
> A native exeption occurred in HMI_2003.exe.
> Select Quit and then restart this program, or select Details for more
> information.
>
> Press 'Details'
>
> ExceptionCode: 0xc0000005
> ExceptionAddress 0x0114414c
> Reading 0x00000001
>
> code that produces this
>
> Private cnnConnection As System.Data.SqlServerCe.SqlCeConnection
> Private adpRequiredDataAdapter As SqlServerCe.SqlCeDataAdapter
>
> 'create connection
> cnnConnection = New System.Data.SqlServerCe.SqlCeConnection("Data Source =
"
> & PathToDB & "; Password=" & _password)
>
> Dim strSQLString As String = "SELECT * FROM tTable Where idNo=752101"
>
> ' create adapter
> adpRequiredDataAdapter = New
> System.Data.SqlServerCe.SqlCeDataAdapter(strSQLString, cnnConnection )
>
> Dim cmdBuilder As SqlServerCe.SqlCeCommandBuilder
> ' create builder
> cmdBuilder = New SqlServerCe.SqlCeCommandBuilder(adpRequiredDataAdapter)
>
> ' add quotes
> cmdBuilder.QuotePrefix = """"
> cmdBuilder.QuoteSuffix = """"
>
> 'assign Insert command
> adpRequiredDataAdapter.InsertCommand = cmdBuilder.GetInsertCommand() '
> exception happens here
>
> or
>
> 'assign update command
> adpRequiredDataAdapter.UpdateCommand = cmdBuilder.GetUpdateCommand() '
> exception happens here
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003
>
>

"Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message
news:%23Z5LzE9hDHA.1480@TK2MSFTNGP12.phx.gbl...
> Please refrain from using SP2 at the moment. Use SP1 until SP2 is
announced
> again (right now it is not available)
>
> "Shaun Wilde" <shaun_wilde@nospam.co.uk> wrote in message
> news:eX1vuJ4hDHA.1172@TK2MSFTNGP09.phx.gbl...
> > I get the following exception when using the CF SP2 on the emulator when
> > trying to use
> > GetInsertCommand or GetUpdateCommand
> >
> > I do NOT get this exception when using the original framework as
deployed
> by
> > VS.NET 2003
> >
> > First Error
> >
> > A native exeption occurred in HMI_2003.exe.
> > Select Quit and then restart this program, or select Details for more
> > information.
> >
> > Press 'Details'
> >
> > ExceptionCode: 0xc0000005
> > ExceptionAddress 0x0114414c
> > Reading 0x00000001
> >
> > code that produces this
> >
> > Private cnnConnection As System.Data.SqlServerCe.SqlCeConnection
> > Private adpRequiredDataAdapter As SqlServerCe.SqlCeDataAdapter
> >
> > 'create connection
> > cnnConnection = New System.Data.SqlServerCe.SqlCeConnection("Data Source
=
> "
> > & PathToDB & "; Password=" & _password)
> >
> > Dim strSQLString As String = "SELECT * FROM tTable Where idNo=752101"
> >
> > ' create adapter
> > adpRequiredDataAdapter = New
> > System.Data.SqlServerCe.SqlCeDataAdapter(strSQLString, cnnConnection )
> >
> > Dim cmdBuilder As SqlServerCe.SqlCeCommandBuilder
> > ' create builder
> > cmdBuilder = New SqlServerCe.SqlCeCommandBuilder(adpRequiredDataAdapter)
> >
> > ' add quotes
> > cmdBuilder.QuotePrefix = """"
> > cmdBuilder.QuoteSuffix = """"
> >
> > 'assign Insert command
> > adpRequiredDataAdapter.InsertCommand = cmdBuilder.GetInsertCommand() '
> > exception happens here
> >
> > or
> >
> > 'assign update command
> > adpRequiredDataAdapter.UpdateCommand = cmdBuilder.GetUpdateCommand() '
> > exception happens here
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003
> >
> >
>
>

"Paul" <Paul@Don'tChuffingSpamMe.com> wrote in message
news:ble1l9$2cn$1$830fa79d@news.demon.co.uk...
> Why? What's wrong with SP2?
>
> "Alex Feinman [MVP]" <public_news@alexfeinman.com> wrote in message
> news:%23Z5LzE9hDHA.1480@TK2MSFTNGP12.phx.gbl...
> > Please refrain from using SP2 at the moment. Use SP1 until SP2 is
> announced
> > again (right now it is not available)
> >
> > "Shaun Wilde" <shaun_wilde@nospam.co.uk> wrote in message
> > news:eX1vuJ4hDHA.1172@TK2MSFTNGP09.phx.gbl...
> > > I get the following exception when using the CF SP2 on the emulator
when
> > > trying to use
> > > GetInsertCommand or GetUpdateCommand
> > >
> > > I do NOT get this exception when using the original framework as
> deployed
> > by
> > > VS.NET 2003
> > >
> > > First Error
> > >
> > > A native exeption occurred in HMI_2003.exe.
> > > Select Quit and then restart this program, or select Details for more
> > > information.
> > >
> > > Press 'Details'
> > >
> > > ExceptionCode: 0xc0000005
> > > ExceptionAddress 0x0114414c
> > > Reading 0x00000001
> > >
> > > code that produces this
> > >
> > > Private cnnConnection As System.Data.SqlServerCe.SqlCeConnection
> > > Private adpRequiredDataAdapter As SqlServerCe.SqlCeDataAdapter
> > >
> > > 'create connection
> > > cnnConnection = New System.Data.SqlServerCe.SqlCeConnection("Data
Source
> =
> > "
> > > & PathToDB & "; Password=" & _password)
> > >
> > > Dim strSQLString As String = "SELECT * FROM tTable Where idNo=752101"
> > >
> > > ' create adapter
> > > adpRequiredDataAdapter = New
> > > System.Data.SqlServerCe.SqlCeDataAdapter(strSQLString, cnnConnection )
> > >
> > > Dim cmdBuilder As SqlServerCe.SqlCeCommandBuilder
> > > ' create builder
> > > cmdBuilder = New
SqlServerCe.SqlCeCommandBuilder(adpRequiredDataAdapter)
> > >
> > > ' add quotes
> > > cmdBuilder.QuotePrefix = """"
> > > cmdBuilder.QuoteSuffix = """"
> > >
> > > 'assign Insert command
> > > adpRequiredDataAdapter.InsertCommand = cmdBuilder.GetInsertCommand() '
> > > exception happens here
> > >
> > > or
> > >
> > > 'assign update command
> > > adpRequiredDataAdapter.UpdateCommand = cmdBuilder.GetUpdateCommand() '
> > > exception happens here
> > >
> > >
> > > ---
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003
> > >
> > >
> >
> >
>
>