|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sqlite provideranyone have any success with a provider for sqlite3 ?
I've tried here: http://sqlite.phxsoftware.com but it crashes ASP.net 2.0 all others I've looked at are for .net 1.1 or are undocumented alpha's Define "crashes" ...
The forums on the website are quite active and I have a pretty good track record of answering questions there. There are also quite a few people using it in ASP.NET 2.0 successfully and who frequent the forums to answer questions there. Robert Simpson Programmer at Large Show quote "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:uCuEu%23u9GHA.5064@TK2MSFTNGP04.phx.gbl... > anyone have any success with a provider for sqlite3 ? > > I've tried here: http://sqlite.phxsoftware.com > but it crashes ASP.net 2.0 > > all others I've looked at are for .net 1.1 or are undocumented alpha's > > > > > These two errors are example
Event Type: Error Event Source: .NET Runtime 2.0 Error Reporting Event Category: None Event ID: 5000 Date: 10/22/2006 Time: 4:12:18 PM User: N/A Computer: Description: EventType clr20r3, P1 aspnet_wp.exe, P2 2.0.50727.42, P3 4333aece, P4 system.data.sqlite, P5 1.0.35.1, P6 45076fb7, P7 213, P8 31, P9 system.nullreferenceexception, P10 NIL. Event Type: Error Event Source: ASP.NET 2.0.50727.0 Event Category: None Event ID: 1000 Date: 10/23/2006 Time: 9:18:58 AM User: N/A Computer: Description: aspnet_wp.exe (PID: 4948) stopped unexpectedly. Show quote "Robert Simpson" <rmsimpson@noemail.noemail> wrote in message news:e1LzKDv9GHA.2316@TK2MSFTNGP04.phx.gbl... > Define "crashes" ... > > The forums on the website are quite active and I have a pretty good track record of answering questions there. There are also > quite a few people using it in ASP.NET 2.0 successfully and who frequent the forums to answer questions there. > > Robert Simpson > Programmer at Large > > > "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:uCuEu%23u9GHA.5064@TK2MSFTNGP04.phx.gbl... >> anyone have any success with a provider for sqlite3 ? >> >> I've tried here: http://sqlite.phxsoftware.com >> but it crashes ASP.net 2.0 >> >> all others I've looked at are for .net 1.1 or are undocumented alpha's >> >> >> >> >> > > Unfortunately there's no usable stack trace in there for me to try and
diagnose the error ... does the program work using another database back-end such as Sql Server? Robert Show quote "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:eUckaTv9GHA.4376@TK2MSFTNGP03.phx.gbl... > These two errors are example > > Event Type: Error > Event Source: .NET Runtime 2.0 Error Reporting > Event Category: None > Event ID: 5000 > Date: 10/22/2006 > Time: 4:12:18 PM > User: N/A > Computer: > Description: > EventType clr20r3, P1 aspnet_wp.exe, P2 2.0.50727.42, P3 4333aece, P4 > system.data.sqlite, P5 1.0.35.1, P6 45076fb7, P7 213, P8 31, P9 > system.nullreferenceexception, P10 NIL. > > Event Type: Error > Event Source: ASP.NET 2.0.50727.0 > Event Category: None > Event ID: 1000 > Date: 10/23/2006 > Time: 9:18:58 AM > User: N/A > Computer: > Description: > aspnet_wp.exe (PID: 4948) stopped unexpectedly. > > > > "Robert Simpson" <rmsimpson@noemail.noemail> wrote in message > news:e1LzKDv9GHA.2316@TK2MSFTNGP04.phx.gbl... >> Define "crashes" ... >> >> The forums on the website are quite active and I have a pretty good track >> record of answering questions there. There are also quite a few people >> using it in ASP.NET 2.0 successfully and who frequent the forums to >> answer questions there. >> >> Robert Simpson >> Programmer at Large >> >> >> "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message >> news:uCuEu%23u9GHA.5064@TK2MSFTNGP04.phx.gbl... >>> anyone have any success with a provider for sqlite3 ? >>> >>> I've tried here: http://sqlite.phxsoftware.com >>> but it crashes ASP.net 2.0 >>> >>> all others I've looked at are for .net 1.1 or are undocumented alpha's >>> >>> >>> >>> >>> >> >> > > > Unfortunately there's no usable stack trace in there for me to try and This is the only error message I get> diagnose the error ... >does the program work using another database back-end it's a datareader for SQLite.> such as Sql Server? If I use a different database, then I'd have to create a different datareader function/connection/etc ... so ? Show quote > > Robert > > "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:eUckaTv9GHA.4376@TK2MSFTNGP03.phx.gbl... >> These two errors are example >> >> Event Type: Error >> Event Source: .NET Runtime 2.0 Error Reporting >> Event Category: None >> Event ID: 5000 >> Date: 10/22/2006 >> Time: 4:12:18 PM >> User: N/A >> Computer: >> Description: >> EventType clr20r3, P1 aspnet_wp.exe, P2 2.0.50727.42, P3 4333aece, P4 system.data.sqlite, P5 1.0.35.1, P6 45076fb7, P7 213, P8 >> 31, P9 system.nullreferenceexception, P10 NIL. >> >> Event Type: Error >> Event Source: ASP.NET 2.0.50727.0 >> Event Category: None >> Event ID: 1000 >> Date: 10/23/2006 >> Time: 9:18:58 AM >> User: N/A >> Computer: >> Description: >> aspnet_wp.exe (PID: 4948) stopped unexpectedly. >> >> >> >> "Robert Simpson" <rmsimpson@noemail.noemail> wrote in message news:e1LzKDv9GHA.2316@TK2MSFTNGP04.phx.gbl... >>> Define "crashes" ... >>> >>> The forums on the website are quite active and I have a pretty good track record of answering questions there. There are also >>> quite a few people using it in ASP.NET 2.0 successfully and who frequent the forums to answer questions there. >>> >>> Robert Simpson >>> Programmer at Large >>> >>> >>> "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:uCuEu%23u9GHA.5064@TK2MSFTNGP04.phx.gbl... >>>> anyone have any success with a provider for sqlite3 ? >>>> >>>> I've tried here: http://sqlite.phxsoftware.com >>>> but it crashes ASP.net 2.0 >>>> >>>> all others I've looked at are for .net 1.1 or are undocumented alpha's >>>> >>>> >>>> >>>> >>>> >>> >>> >> >> > > Exactly... If you get the same error using a different database provider,
then that would indicate an error with your code rather than with the underlying provider. Show quote "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:%23pOk2gy9GHA.4356@TK2MSFTNGP05.phx.gbl... > >> Unfortunately there's no usable stack trace in there for me to try and >> diagnose the error ... > > This is the only error message I get > > >does the program work using another database back-end >> such as Sql Server? > > it's a datareader for SQLite. > If I use a different database, then I'd have to create a different > datareader function/connection/etc ... so ? > > >> >> Robert >> >> "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message >> news:eUckaTv9GHA.4376@TK2MSFTNGP03.phx.gbl... >>> These two errors are example >>> >>> Event Type: Error >>> Event Source: .NET Runtime 2.0 Error Reporting >>> Event Category: None >>> Event ID: 5000 >>> Date: 10/22/2006 >>> Time: 4:12:18 PM >>> User: N/A >>> Computer: >>> Description: >>> EventType clr20r3, P1 aspnet_wp.exe, P2 2.0.50727.42, P3 4333aece, P4 >>> system.data.sqlite, P5 1.0.35.1, P6 45076fb7, P7 213, P8 31, P9 >>> system.nullreferenceexception, P10 NIL. >>> >>> Event Type: Error >>> Event Source: ASP.NET 2.0.50727.0 >>> Event Category: None >>> Event ID: 1000 >>> Date: 10/23/2006 >>> Time: 9:18:58 AM >>> User: N/A >>> Computer: >>> Description: >>> aspnet_wp.exe (PID: 4948) stopped unexpectedly. >>> >>> >>> >>> "Robert Simpson" <rmsimpson@noemail.noemail> wrote in message >>> news:e1LzKDv9GHA.2316@TK2MSFTNGP04.phx.gbl... >>>> Define "crashes" ... >>>> >>>> The forums on the website are quite active and I have a pretty good >>>> track record of answering questions there. There are also quite a few >>>> people using it in ASP.NET 2.0 successfully and who frequent the forums >>>> to answer questions there. >>>> >>>> Robert Simpson >>>> Programmer at Large >>>> >>>> >>>> "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message >>>> news:uCuEu%23u9GHA.5064@TK2MSFTNGP04.phx.gbl... >>>>> anyone have any success with a provider for sqlite3 ? >>>>> >>>>> I've tried here: http://sqlite.phxsoftware.com >>>>> but it crashes ASP.net 2.0 >>>>> >>>>> all others I've looked at are for .net 1.1 or are undocumented alpha's >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > all my other websites are performing fine, some with access, some with sql server.
Show quote "Robert Simpson" <rmsimpson@nospam.nospam> wrote in message news:ewixKky9GHA.4708@TK2MSFTNGP05.phx.gbl... > Exactly... If you get the same error using a different database provider, then that would indicate an error with your code rather > than with the underlying provider. > > > "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:%23pOk2gy9GHA.4356@TK2MSFTNGP05.phx.gbl... >> >>> Unfortunately there's no usable stack trace in there for me to try and >>> diagnose the error ... >> >> This is the only error message I get >> >> >does the program work using another database back-end >>> such as Sql Server? >> >> it's a datareader for SQLite. >> If I use a different database, then I'd have to create a different datareader function/connection/etc ... so ? >> >> >>> >>> Robert >>> >>> "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:eUckaTv9GHA.4376@TK2MSFTNGP03.phx.gbl... >>>> These two errors are example >>>> >>>> Event Type: Error >>>> Event Source: .NET Runtime 2.0 Error Reporting >>>> Event Category: None >>>> Event ID: 5000 >>>> Date: 10/22/2006 >>>> Time: 4:12:18 PM >>>> User: N/A >>>> Computer: >>>> Description: >>>> EventType clr20r3, P1 aspnet_wp.exe, P2 2.0.50727.42, P3 4333aece, P4 system.data.sqlite, P5 1.0.35.1, P6 45076fb7, P7 213, P8 >>>> 31, P9 system.nullreferenceexception, P10 NIL. >>>> >>>> Event Type: Error >>>> Event Source: ASP.NET 2.0.50727.0 >>>> Event Category: None >>>> Event ID: 1000 >>>> Date: 10/23/2006 >>>> Time: 9:18:58 AM >>>> User: N/A >>>> Computer: >>>> Description: >>>> aspnet_wp.exe (PID: 4948) stopped unexpectedly. >>>> >>>> >>>> >>>> "Robert Simpson" <rmsimpson@noemail.noemail> wrote in message news:e1LzKDv9GHA.2316@TK2MSFTNGP04.phx.gbl... >>>>> Define "crashes" ... >>>>> >>>>> The forums on the website are quite active and I have a pretty good track record of answering questions there. There are also >>>>> quite a few people using it in ASP.NET 2.0 successfully and who frequent the forums to answer questions there. >>>>> >>>>> Robert Simpson >>>>> Programmer at Large >>>>> >>>>> >>>>> "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:uCuEu%23u9GHA.5064@TK2MSFTNGP04.phx.gbl... >>>>>> anyone have any success with a provider for sqlite3 ? >>>>>> >>>>>> I've tried here: http://sqlite.phxsoftware.com >>>>>> but it crashes ASP.net 2.0 >>>>>> >>>>>> all others I've looked at are for .net 1.1 or are undocumented alpha's >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > Is this the same issue that was brought up by a user on the forums regarding
the sqlite provider being slow loading a page? If not, can you send me some source code so I can duplicate the issue? Robert Show quote "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message news:%23iyLk0y9GHA.3480@TK2MSFTNGP04.phx.gbl... > all my other websites are performing fine, some with access, some with sql > server. > > > > "Robert Simpson" <rmsimpson@nospam.nospam> wrote in message > news:ewixKky9GHA.4708@TK2MSFTNGP05.phx.gbl... >> Exactly... If you get the same error using a different database provider, >> then that would indicate an error with your code rather than with the >> underlying provider. >> >> >> "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message >> news:%23pOk2gy9GHA.4356@TK2MSFTNGP05.phx.gbl... >>> >>>> Unfortunately there's no usable stack trace in there for me to try and >>>> diagnose the error ... >>> >>> This is the only error message I get >>> >>> >does the program work using another database back-end >>>> such as Sql Server? >>> >>> it's a datareader for SQLite. >>> If I use a different database, then I'd have to create a different >>> datareader function/connection/etc ... so ? >>> >>> >>>> >>>> Robert >>>> >>>> "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message >>>> news:eUckaTv9GHA.4376@TK2MSFTNGP03.phx.gbl... >>>>> These two errors are example >>>>> >>>>> Event Type: Error >>>>> Event Source: .NET Runtime 2.0 Error Reporting >>>>> Event Category: None >>>>> Event ID: 5000 >>>>> Date: 10/22/2006 >>>>> Time: 4:12:18 PM >>>>> User: N/A >>>>> Computer: >>>>> Description: >>>>> EventType clr20r3, P1 aspnet_wp.exe, P2 2.0.50727.42, P3 4333aece, P4 >>>>> system.data.sqlite, P5 1.0.35.1, P6 45076fb7, P7 213, P8 31, P9 >>>>> system.nullreferenceexception, P10 NIL. >>>>> >>>>> Event Type: Error >>>>> Event Source: ASP.NET 2.0.50727.0 >>>>> Event Category: None >>>>> Event ID: 1000 >>>>> Date: 10/23/2006 >>>>> Time: 9:18:58 AM >>>>> User: N/A >>>>> Computer: >>>>> Description: >>>>> aspnet_wp.exe (PID: 4948) stopped unexpectedly. >>>>> >>>>> >>>>> >>>>> "Robert Simpson" <rmsimpson@noemail.noemail> wrote in message >>>>> news:e1LzKDv9GHA.2316@TK2MSFTNGP04.phx.gbl... >>>>>> Define "crashes" ... >>>>>> >>>>>> The forums on the website are quite active and I have a pretty good >>>>>> track record of answering questions there. There are also quite a >>>>>> few people using it in ASP.NET 2.0 successfully and who frequent the >>>>>> forums to answer questions there. >>>>>> >>>>>> Robert Simpson >>>>>> Programmer at Large >>>>>> >>>>>> >>>>>> "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot com> wrote in message >>>>>> news:uCuEu%23u9GHA.5064@TK2MSFTNGP04.phx.gbl... >>>>>>> anyone have any success with a provider for sqlite3 ? >>>>>>> >>>>>>> I've tried here: http://sqlite.phxsoftware.com >>>>>>> but it crashes ASP.net 2.0 >>>>>>> >>>>>>> all others I've looked at are for .net 1.1 or are undocumented >>>>>>> alpha's >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > |
|||||||||||||||||||||||
Other interesting topics