Re: [sqlite] SQLite on Windows 2003

No, actually, not bin. I have tried it from the root directory and the App_Data directory using absolute paths. I will try your approach. Thanks Allan, Joe Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL TECHNOLOGY 2 Contra Way Merrimack, NH 03054 603.791.5113 cell:

Re: [sqlite] SQLite on Windows 2003

Hi Igmar, Yeah, I think it is related to that. I am not new to ASP.NET nor to Windows 2003. I am new to SQLite, however. But I think you are on to something. I even changed the file name extension to .txt and it still doesn't work, although it does work in the console application. Thanks, Joe

Re: [sqlite] SQLite on Windows 2003

First of all, I want to thank everyone that has replied to this email thread. I still do not have a successful opening of the SQLite connection in my ASP.NET C# application on Windows 2003. I have done the following: The connection opens successfully with the SQLite command tool. It opens

Re: [sqlite] SQLite on Windows 2003

.@sqlite.org] On Behalf Of Simon Slavin BJ> Sent: Tuesday, April 06, 2010 3:33 PM BJ> To: General Discussion of SQLite Database BJ> Subject: Re: [sqlite] SQLite on Windows 2003 BJ> On 6 Apr 2010, at 8:30pm, Burnett, Joe wrote: >> I have a SQLite application running just fine o

Re: [sqlite] SQLite on Windows 2003

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Tuesday, April 06, 2010 3:33 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite on Windows 2003 On 6 Apr 2010, at 8:30pm, Burnett, Joe wrote

[sqlite] SQLite on Windows 2003

Hi All., I have a SQLite application running just fine on Windows XP SP3. I am attempting to move the application to Windows 2003 Enterprise Edition. However, the connection open method returns null. The connection string is good. The database file is there. I have the appropriate permissions on

Re: [sqlite] Select * from tablename results in an exception

ned. Pavel On Tue, Mar 30, 2010 at 5:23 PM, Burnett, Joe <joe.burn...@fmr.com> wrote: > Thank you all for the replies. The message was a bit of a red herring. > I had issues in my SQLite DB schema - VARCHAR(64) was not big enough. > > Joe Burnett | Principal Software Engineer | F

Re: [sqlite] Select * from tablename results in an exception

Thank you all for the replies. The message was a bit of a red herring. I had issues in my SQLite DB schema - VARCHAR(64) was not big enough. Joe Burnett | Principal Software Engineer | FIDELITY INSTITUTIONAL TECHNOLOGY 2 Contra Way Merrimack, NH 03054 603.791.5113 cell: 603.289.0481

Re: [sqlite] Select * from tablename results in an exception

: [sqlite] Select * from tablename results in an exception On 30 Mar 2010, at 2:01pm, Burnett, Joe wrote: > I am using SQLite in a C# .NET application. I am inserting into tables > without any issues as confirmed by the SQLite Admin tool. > However, later in the application, I want

Re: [sqlite] Select * from tablename results in an exception

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Tuesday, March 30, 2010 9:23 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Select * from tablename results in an exception On 30 Mar 2010, at 2:01pm, Burnett, Joe wrote: >string sql = &quo

[sqlite] Select * from tablename results in an exception

Hi All, I am using SQLite in a C# .NET application. I am inserting into tables without any issues as confirmed by the SQLite Admin tool. However, later in the application, I want to query the table where I inserted the data, I get the following exception: "Failed to enable constraints. One or