Re: [sqlite] Newbie question on Data Source

2011-11-29 Thread Dave
Michael, #1 Thanks for the comments. I have the book, The Definitive Guide to SQLite from Apress by Michael Owens, but it is the 2006 first edition. Do you, or anyone, know if the new or 2nd edition is worth buying or does it just cover 1 new item? I am not afraid to buy books. You should se

Re: [sqlite] Newbie question on Data Source

2011-11-29 Thread Alaric Snell-Pym
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/29/2011 12:17 PM, Black, Michael (IS) wrote: > I'll note a few things here... [snip] Much good advice. Seconded! ABS - -- Alaric Snell-Pym http://www.snell-pym.org.uk/alaric/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Co

Re: [sqlite] Newbie question on Data Source

2011-11-29 Thread Black, Michael (IS)
e...@cox.net] Sent: Monday, November 28, 2011 5:24 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Newbie question on Data Source On 11/28/2011 4:59 PM, Simon Slavin wrote: > On 28 Nov 2011, at 10:44pm, Dave wrote: > >> On 11/28/2011 4:37 PM, Simon Slavin wrote:

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
On 11/28/2011 4:59 PM, Simon Slavin wrote: On 28 Nov 2011, at 10:44pm, Dave wrote: On 11/28/2011 4:37 PM, Simon Slavin wrote: Just to stress that the filename includes the bit after the '.'. You can have any number of files with the same part before the '.' but different extensions. To t

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Simon Slavin
On 28 Nov 2011, at 10:44pm, Dave wrote: > On 11/28/2011 4:37 PM, Simon Slavin wrote: >> Just to stress that the filename includes the bit after the '.'. You can >> have any number of files with the same part before the '.' but different >> extensions. To tell the operating system which one you

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
Thanks Simon, Actually, I knew that. Just having a bit of a multiple crash course...all at once. I just recently built this pc and have been on XP until recently too. I do some graphic stuff and have many same named pics with the various .jpg, .bmp, .gif extensions. Dave On 11/28/2011 4:37

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
Thanks Igor, I am just getting started so I am bound to get tripped up a little. :-) That was going to be my next question anyhow, about the database name. I was thinking we *had* to have the extension .db3 but you have answered that. I just have been using VB.Net less than 30 days and that

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Simon Slavin
On 28 Nov 2011, at 10:32pm, Igor Tandetnik wrote: > On 11/28/2011 5:23 PM, Dave wrote: >> Ok, I switched that and now my original database file has a .db added >> whereas the one created by my app stays the same. > > It doesn't have .db added. It had it all along, you just couldn't see it. > >

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Igor Tandetnik
On 11/28/2011 5:23 PM, Dave wrote: Ok, I switched that and now my original database file has a .db added whereas the one created by my app stays the same. It doesn't have .db added. It had it all along, you just couldn't see it. Anyway, now you can name your file however you want. Make sure th

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
Thanks John. On 11/28/2011 4:18 PM, John Drescher wrote: You probably have "Hide extensions for known types enabled in windows" When this is enabled windows does not display the extension for known types so that if you have more than 1 file with the same base name they will appear as the same

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
Ok, I switched that and now my original database file has a .db added whereas the one created by my app stays the same. Thanks, Dave On 11/28/2011 4:14 PM, Igor Tandetnik wrote: On 11/28/2011 5:13 PM, Dave wrote: I just looked again and renamed my original database file back to add the .db3 to

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Igor Tandetnik
On 11/28/2011 5:13 PM, Dave wrote: I just looked again and renamed my original database file back to add the .db3 to it and it remains in the same folder as the other file with one exception. The properties for my database shows: type: Data Base File Where the one generated at 0K with the same n

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
Yes, that is what I am trying to connect to. The problem is that it apparently doesn't connect to it as it cannot see the tables in it. So it creates another database file that has 0K in size. My database file has the correct icon next to it's name with a little key in the pic where the one tha

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread John Drescher
On Mon, Nov 28, 2011 at 5:13 PM, Dave wrote: > > > On 11/28/2011 3:59 PM, Igor Tandetnik wrote: >> >> On 11/28/2011 4:52 PM, Dave wrote: >>> >>> I am trying to learn VB.Net and SQLite at the same time. I have used VB6 >>> Classic in the past. I have VB Studio 2010 Pro and am just trying to >>> ope

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
On 11/28/2011 3:59 PM, Igor Tandetnik wrote: On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit a probl

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Igor Tandetnik
On 11/28/2011 5:08 PM, Dave wrote: I just checked and the 0K file that is created is the same name except it has .db3 added to it's name. Why is this suprising? Your connection string requests a file named MyDatabase.db3. Is this not the file you want to connect to? -- Igor Tandetnik ___

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
On 11/28/2011 3:59 PM, Igor Tandetnik wrote: On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit a probl

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Igor Tandetnik
On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit a problem I cannot figure out after plenty of trying. I

Re: [sqlite] Newbie question on Data Source

2011-11-28 Thread Marc Hornung
I think this is a bug in SQL Lite I just came across this today and found that there is an update pending that claims to resolve it Not sure if this is the link but it is the site... http://system.data.sqlite.org/index.html/timeline M -Original Message- From: sqlite-users-boun...@s