RE: [sqlite] Using SQLlite as a db in an IIS website directory

2004-10-26 Thread Roger Hawkins
not work, do > the same for the IWAM_ account. > > also, check that the virtual directory you are accessing the > db from (in IIS setup), was WRITE permissions enabled. > > > -Original Message- > > From: Roger Hawkins [mailto:[EMAIL PROTECTED] > > Sent: Tuesday,

[sqlite] Using SQLlite as a db in an IIS website directory

2004-10-26 Thread Roger Hawkins
Hi, On my win2000 Pro machine everything works fine running SQLlite using SQLite.net as a database for a web application. On my 2003 server however I get: 'attempt to write a readonly database' when trying to perform a write to the db. I can read from db fine. There appears to be nothing obvio

RE: [sqlite] Resetting primary key auto-increment after table re-create

2004-03-08 Thread Roger Hawkins
Sorry...That's what I meant - scary you can insert into a table that has this property without first setting The propert off without re-seeding - ie. How Sybase and SqlServer handle this.. It would be good if this was documented a little clearer Thx all for your assistance - onward and upwa

RE: [sqlite] Resetting primary key auto-increment after table re-create

2004-03-07 Thread Roger Hawkins
Thanks...I will try this... > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Monday, 8 March 2004 4:13 PM > To: Roger Hawkins > Cc: [EMAIL PROTECTED] > Subject: Re: [sqlite] Resetting primary key auto-increment > after table

RE: [sqlite] Resetting primary key auto-increment after table re-create

2004-03-07 Thread Roger Hawkins
Original Message- > From: Will Leshner [mailto:[EMAIL PROTECTED] > Sent: Monday, 8 March 2004 3:47 PM > To: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> > Subject: Re: [sqlite] Resetting primary key auto-increment > after table re-create > > > >

[sqlite] Resetting primary key auto-increment after table re-create

2004-03-07 Thread Roger Hawkins
Hi, Regarding my request below... Ive searched the documentation on the website and I am still no clearer on how this is achieved Any info greatly appreciated, Cheers, Roger " Ticket 636: Retaining autoincrement (Primary key) generated values I need to re-create a table to add a column o