Re: [sqlite] bug? Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite.
Well...I didn't compile the SQLite binaries. I don't have the SQLite source code, so Sharpdevelop could not have compiled it. So the folder path must have been set there by whoever/whatever compiled the SQLite binaries. I certainly have no folder path that resembles that one. I guess I see this as a SQLite bug in that someone wrote code that caused the error to occur when it fact it should not have occurred. Unless... is it possible that I'm using the wrong DLL file? Lou. Joe Mistachkin-3 wrote: > > > LouOttawa wrote: >> >> You explained that: "The path you are seeing is from the machine used to >> build the released binaries." I understand your explanation, but is this > not >> then a bug in SQLite? Doesn't "someone" build the binaries on the "SQLite >> machine" so to speak? >> > > No, it's not a bug. The compiler automatically embeds the original source > location in the PDBs. > >> >> I mean - its not a SharpDevelop problem, is it? >> > > Not really. It's probably just reading the PDB and assuming that the > source > code should be available locally in the same location as when it was > built. > That assumption is invalid in this case; however, in the more general case > of > projects being developed with SharpDevelop, that might be OK. > > -- > Joe Mistachkin > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/bug--Can%27t-load-file-SQLiteConnection.cs-under-c%3A%5Cdev%5Csqlite%5Cdotnet%5CSystem.Data.SQLite.-tp33353617p33372245.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Site/Login Confusion
I can loggin under Nabble without a problem. But the SQLite web site at "http://www.sqlite.org/src/login; seems to be quite separate in its credentials, although it lists bug reports that I entered in Nabble. What is that website for? -- View this message in context: http://old.nabble.com/Site-Login-Confusion-tp33367132p33367132.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug? Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite.
Joe... You explained that: "The path you are seeing is from the machine used to build the released binaries." I understand your explanation, but is this not then a bug in SQLite? Doesn't "someone" build the binaries on the "SQLite machine" so to speak? I mean - its not a SharpDevelop problem, is it? Will it go into the "bug report list"? Lou. Joe Mistachkin-3 wrote: > > > LouOttawa wrote: >> >> Why is it looking for the ".cs" file? Why does it look for in the > indicated >> folder. >> > > That message is coming from your IDE (SharpDevelop?) when it uses the PDB > symbol information in an attempt to locate the source code for the > SQLiteConnection class. The path you are seeing is from the machine used > to > build the released binaries. > >> >> The code is essentially below. The GetSchema generates the error. >> > > The correct argument to pass to GetSchema in this case is > "MetaDataCollections" > (with an "s" at the end). > > -- > Joe Mistachkin > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/bug--Can%27t-load-file-SQLiteConnection.cs-under-c%3A%5Cdev%5Csqlite%5Cdotnet%5CSystem.Data.SQLite.-tp33353617p33367058.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] bug? Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite.
OK. I will pass it on to the bug reporting system at SharpDevelop. Thanks for your help. Lou. Joe Mistachkin-3 wrote: > > LouOttawa wrote: >> >> Why is it looking for the ".cs" file? Why does it look for in the > indicated >> folder. >> > > That message is coming from your IDE (SharpDevelop?) when it uses the PDB > symbol information in an attempt to locate the source code for the > SQLiteConnection class. The path you are seeing is from the machine used > to > build the released binaries. > > -- > Joe Mistachkin > -- View this message in context: http://old.nabble.com/bug--Can%27t-load-file-SQLiteConnection.cs-under-c%3A%5Cdev%5Csqlite%5Cdotnet%5CSystem.Data.SQLite.-tp33353617p33354996.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] bug? Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite.
All the info is in the attached file. Here are a few details. The error is: "Can't load file SQLiteConnection.cs under c:\dev\sqlite\dotnet\System.Data.SQLite." Why is it looking for the ".cs" file? Why does it look for in the indicated folder. -- I wonder if I am using the correct DLL: "System.Data.SQLite from this version: "sqlite-netFx40-static-binary-bundle-Win32-2010-1.0.79.0". On the web. The IDE is: SharpDevelop Version : 4.1.0.8000-736b5b66 .NET Version : 4.0.30319.239 OS Version : Microsoft Windows NT 5.1.2600 Service Pack 3 I'm working under .dotNet Framework V4. The code is essentially below. The GetSchema generates the error. --- private void MetaDataCollections() { // SQLiteFactory factory=new SQLiteFactory(); using (SQLiteConnection connection = new SQLiteConnection()) { connection.ConnectionString = @"Data Source=I:\001-CurrentWork\SqliteTestDB1.s3db"; connection.Open(); if (connection.State!= ConnectionState.Open) { MessageBox.Show(@"Connection failed"); this.Close(); } DataTable dt = connection.GetSchema(@"MetaDataCollection"); DisplayDataTable(dt,"MetaDataCollections.xls"); } } - http://old.nabble.com/file/p33353617/SQLiteDisplay.zip SQLiteDisplay.zip -- View this message in context: http://old.nabble.com/bug--Can%27t-load-file-SQLiteConnection.cs-under-c%3A%5Cdev%5Csqlite%5Cdotnet%5CSystem.Data.SQLite.-tp33353617p33353617.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Testing a new SQLite Data Provider with SQLite?
Simon Slavin-3 wrote: > > > On 2 Feb 2012, at 3:00pm, LouOttawa wrote: > >> Simon Slavin-3 wrote: >> >>> SQLite3.exe is a stand-alone program which lets you type SQL commands. >>> It >>> has no connection with Data Providers. Unless you want to run it you >>> don't even have to have a copy on your computer. >> >> Then, once I create a database file, I should be able to use the data >> provider to open the file? Is that correct? > > A SQLite database file is just a file. It can be read and understood by > many different programs. sqlite3.exe is just one more program which > understands that file format. You can make a database with sqlite3.exe, > but then read and write it with a program you've written yourself. Or > vice versa. > > The Data Provider you're talking about is something you have chosen to use > because of the programming environment you have chosen to use. It's not > needed by every program which uses SQLite. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > OK, That's just a nice way of saying "Yes, you are correct". Thanks very much. Writing code can sometimes warp your mind and I sometimes just have to come up for a reality check. -- View this message in context: http://old.nabble.com/Testing-a-new-SQLite-Data-Provider-with-SQLite--tp33245016p33254182.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Testing a new SQLite Data Provider with SQLite?
Simon Slavin-3 wrote: > > SQLite3.exe is a stand-alone program which lets you type SQL commands. It > has no connection with Data Providers. Unless you want to run it you > don't even have to have a copy on your computer. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Then, once I create a database file, I should be able to use the data provider to open the file? Is that correct? -- View this message in context: http://old.nabble.com/Testing-a-new-SQLite-Data-Provider-with-SQLite--tp33245016p33250700.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Testing a new SQLite Data Provider with SQLite?
I am in the process of writing a new SQLite Data Provider, but I'm a bit confused about testing it. Do I need to have SQLite3.exe installed to manually create a test database? and then I assume I need the SQLite DLLs for that App that communicates with the database. Is that correct? -- View this message in context: http://old.nabble.com/Testing-a-new-SQLite-Data-Provider-with-SQLite--tp33245016p33245016.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users