sqlite provider

[Jon Paal]

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

 

[Robert Simpson]

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]

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]

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

 

[Jon Paal]

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 Simpson]

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]

all my other websites are performing fine, some with access, some with sql server.

 

[Robert Simpson]

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

 

[Jon Paal]

looks to be the same type of problem...