Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-15 Thread Simon Slavin
On 15 Apr 2014, at 10:14am, Ralf wrote: > Yes. Everything is Working as expected when i access the DB with any Browser. > It is just the powershell environment Then the chances are that the problem is with PowerShell, not SQLite. Simon. ___ sqlite-u

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-15 Thread Ralf
On 15. April 2014 09:46:43 MESZ, Joe Mistachkin wrote: > >Ralf wrote: >> >> I just tried... No change :-( >> > >Have you looked at the contents of the database using the SQLite >command >line tool for Windows? > > https://www.sqlite.org/2014/sqlite-shell-win32-x86-3080403.zip > >-- >Joe Mist

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-15 Thread Joe Mistachkin
Ralf wrote: > > I just tried... No change :-( > Have you looked at the contents of the database using the SQLite command line tool for Windows? https://www.sqlite.org/2014/sqlite-shell-win32-x86-3080403.zip -- Joe Mistachkin ___ sqlite-users

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-15 Thread Ralf
On 15. April 2014 01:55:40 MESZ, Joe Mistachkin wrote: > >Ralf Jantschek wrote: >> >> The connection as such is ok. Updates are working. It is only the >> executereader that is troubling me >> > >For database files that need a UNC path, four leading backslashes are >required. > >Without them, som

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Joe Mistachkin
Ralf Jantschek wrote: > > The connection as such is ok. Updates are working. It is only the > executereader that is troubling me > For database files that need a UNC path, four leading backslashes are required. Without them, some things may appear to work correctly; however, it might also exhib

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Ralf Jantschek
4 20:36 > An: 'General Discussion of SQLite Database' > Betreff: Re: [sqlite] Problems with executereader in System.Data.SQLite > > > Ralf Jantschek wrote: > > > >$cn.ConnectionString = "Data Source=\\..." > > > > If you are

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Joe Mistachkin
Ralf Jantschek wrote: > >$cn.ConnectionString = "Data Source=\\..." > If you are opening a database on a network share, there must now be four leading backslashes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Ralf Jantschek
;<<<< > -Ursprüngliche Nachricht----- > Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] Im Auftrag von Joe Mistachkin > Gesendet: Freitag, 11. April 2014 21:02 > An: 'General Discussion of SQLite Database' > Betreff: Re: [

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-11 Thread Joe Mistachkin
Ralf Jantschek wrote: > > I have the following table: > > Table: > > Field1Field2 > > 12 > Could you please show the schema for the table involved in this query? > > I am trying to access the values with > > "Select * from table;" > > But the sel

[sqlite] Problems with executereader in System.Data.SQLite

2014-04-11 Thread Ralf Jantschek
Hello, i hope this is the right Forum. I have the following table: Table: Field1Field2 12 I am trying to access the values with "Select * from table;" But the select doesn't return "1 2" as expected, it returns the FieldCount which