Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

-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)

Re: [sqlite] Newbie question on Data Source

ent: 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: >>> Ju

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: 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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

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

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

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

Re: [sqlite] Newbie question on Data Source

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

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

Re: [sqlite] Newbie question on Data Source

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.

Re: [sqlite] Newbie question on Data Source

...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dave Sent: Monday, November 28, 2011 4:53 PM To: General Discussion of SQLite Database Subject: [sqlite] Newbie question on Data Source I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I

[sqlite] Newbie question on Data Source

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 keep getting the error message: