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 
see my VB6 collection. :) Can you recommend a must have well written 
database design book?


#2 Believe me, I know it is hard to get out of my VB6 and if I knew it 
would work forever, I probably wouldn't. But Microsoft dropped support 
years ago. I started with a TI994A and moved up to a Commodore C64 and 
actually ran a BBS with SCSI hard drives attached to it. Did the same 
with a Commodore C128. Still have the equipment and it still works. I 
build all my computers. I have the Visual Studio Pro so I can look at C# 
but I had C++ in my Classic Studio and stayed with Visual Basic. For my 
needs it is powerful enough.


#3 This list has helped me get set up as I found the old ADO provider 
(1.0.66) and had some questions on the correct package to download from 
the System.Data.SQLite. Then the designer was missing but now I see it 
is almost ready and will come out next release. That is good.


My database needs or wants are simple at the present time. When I wrote 
my main app that is shareware I couldn't quite figure out the data base 
stuff and I also was worried someone would just steal my data base and 
use it to form a competing product. The password with Access seemed easy 
to break if you Googled it. So I hard coded my data into the app but 
that made it a bunch of extra work to add new items in the proper order 
that was necessary as there were multiple fields. As I rewrite the app, 
the main reason for all this upgrading, I will surely come up with new 
situations and challenges. Simple things come to mind like allowing the 
end user to change the data, but if they muck it up, allow them to get 
back to the default data base. My app deals with formulas that require 
accuracy and hard coding data preserves that.


The another reason I stayed away from .NET as I read how easy it was for 
people to steal your hard work. I read about Obfuscation and it seemed 
like it may or may not work all that good, but it looks like that is all 
we have so I have to trust it. Visual Studio Pro comes with a standard 
or basis Obfuscator but I have found other ones for free and some 
costing in the thousands.


Dave

On 11/29/2011 6:17 AM, Black, Michael (IS) wrote:

I'll note a few things here...



#1 If you want to learn about "database design" or "how to code in language X" 
get a book on those and not on a particular product (you may want the product book too if you need 
it but those tend to be less helpful).

#2 Your first language will be hard to get "out of".  I've done over 60 
languages now and C# is one of only a few that I was impressed with and worth the trouble 
to learn.  Ada was the other one (but for completely different reasons).  I still prefer 
C though C++ can be more helpful at times (advanced data structures).

#3 This list is probably one of the best learning things you can do that doesn't take "study 
time".  When somebody poses a problem try to solve it yourself without seeing the 
"answer" that inevitably comes up here.  One of the better ways of learning is doing.



Michael D. Black

Senior Scientist

Advanced Analytics Directorate

Advanced GEOINT Solutions Operating Unit

Northrop Grumman Information Systems




___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7UzwwACgkQRgz/WHNxCGo8YQCfbuHuGn+TswVZvoaBdKvvUTfc
LuIAnRklSLS0P/KgE29lF6GHuvlnnonq
=U2zn
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Newbie question on Data Source

2011-11-29 Thread Black, Michael (IS)
I'll note a few things here...



#1 If you want to learn about "database design" or "how to code in language X" 
get a book on those and not on a particular product (you may want the product 
book too if you need it but those tend to be less helpful).

#2 Your first language will be hard to get "out of".  I've done over 60 
languages now and C# is one of only a few that I was impressed with and worth 
the trouble to learn.  Ada was the other one (but for completely different 
reasons).  I still prefer C though C++ can be more helpful at times (advanced 
data structures).

#3 This list is probably one of the best learning things you can do that 
doesn't take "study time".  When somebody poses a problem try to solve it 
yourself without seeing the "answer" that inevitably comes up here.  One of the 
better ways of learning is doing.



Michael D. Black

Senior Scientist

Advanced Analytics Directorate

Advanced GEOINT Solutions Operating Unit

Northrop Grumman Information Systems


From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Dave [thesche...@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:
>>> 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 want you must 
>>> include the bit after the '.'.
>>   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.
> My job involves dealing with lots of people who aren't good at computers and 
> the fact that, by default, the OS hides file extensions confuses the hell out 
> of them.  I'm not taking a shot at Windows here: the Macintosh OS does the 
> same thing.
>
> It also means you see files with names like 'paper.doc.docx.docx.PDF'.
>
> Simon.

I hear you... I once had a shareware app that I bought that the guy that
coded it had a weird way of saving progress by nesting folders all named
the same. I was watching a backup app once and thought, wtf, when I saw
\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\.
I am pretty good with computers actually but still can get caught
looking like a nob here and there. :-) I am one of the guys that was a
diehard VB6 Classic user and when I upgraded to .NET 2002 I was
instantly mad at the so called VB7 as it was nothing like the upgrade we
were expecting or wanting. I got the $20 update for .NET 2003 and looked
at it and stayed with VB6 Classic. I looked at Delphi, RealBASIC, and
PowerBasic, and realized I like VB. Now I thought I better get caught up
before Win8 starts messing with legacy apps. And as far as data base
programming, I am still a noob. I read all the thick Access books years
ago and spent a lot of time trying to learn but always reached a point
where I got totally confused when it came to design and primary and
foreign keys and relationship designer views. So here I go again. I
don't give up easy.
Thanks,
Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 tell the operating system which one you want you must include the bit after 
the '.'.

  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.

My job involves dealing with lots of people who aren't good at computers and 
the fact that, by default, the OS hides file extensions confuses the hell out 
of them.  I'm not taking a shot at Windows here: the Macintosh OS does the same 
thing.

It also means you see files with names like 'paper.doc.docx.docx.PDF'.

Simon.


I hear you... I once had a shareware app that I bought that the guy that 
coded it had a weird way of saving progress by nesting folders all named 
the same. I was watching a backup app once and thought, wtf, when I saw 
\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\.  
I am pretty good with computers actually but still can get caught 
looking like a nob here and there. :-) I am one of the guys that was a 
diehard VB6 Classic user and when I upgraded to .NET 2002 I was 
instantly mad at the so called VB7 as it was nothing like the upgrade we 
were expecting or wanting. I got the $20 update for .NET 2003 and looked 
at it and stayed with VB6 Classic. I looked at Delphi, RealBASIC, and 
PowerBasic, and realized I like VB. Now I thought I better get caught up 
before Win8 starts messing with legacy apps. And as far as data base 
programming, I am still a noob. I read all the thick Access books years 
ago and spent a lot of time trying to learn but always reached a point 
where I got totally confused when it came to design and primary and 
foreign keys and relationship designer views. So here I go again. I 
don't give up easy.

Thanks,
Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 want you must 
>> include the bit after the '.'.

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

My job involves dealing with lots of people who aren't good at computers and 
the fact that, by default, the OS hides file extensions confuses the hell out 
of them.  I'm not taking a shot at Windows here: the Macintosh OS does the same 
thing.

It also means you see files with names like 'paper.doc.docx.docx.PDF'.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 PM, Simon Slavin wrote:

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.

Anyway, now you can name your file however you want. Make sure that, whichever 
name you choose, you use the same name in the connection string.

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 want you must include the bit after 
the '.'.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 
doesn't help any.

Cheers,
Dave

On 11/28/2011 4:32 PM, 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.

Anyway, now you can name your file however you want. Make sure that, 
whichever name you choose, you use the same name in the connection 
string.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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.
> 
> Anyway, now you can name your file however you want. Make sure that, 
> whichever name you choose, you use the same name in the connection string.

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 want you must include the bit after 
the '.'.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 that, 
whichever name you choose, you use the same name in the connection string.

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 but with a different icon in the explorer view.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 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 name is:
type: DB3 File


Go to Control Panel | Folder Options | View. Uncheck "Hide extensions 
for known file types" setting, and click OK. Now you can see *real* 
names of your files.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 name is:
type: DB3 File


Go to Control Panel | Folder Options | View. Uncheck "Hide extensions 
for known file types" setting, and click OK. Now you can see *real* 
names of your files.

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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 that is created just has an icon that looks like a sheet 
of paper.

Dave

On 11/28/2011 4:09 PM, Igor Tandetnik wrote:

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?

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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
>>> 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:
>>>
>>> SQLite Error
>>> no such table: MyTableName
>>>
>>> I have the database in the project folder on my Win7 64 Pro system. The
>>> app, when run, creates an empty database file of the same name as my
>>> database file which is 13KB in size.
>>
>> What do you mean, of the same name? It's impossible to have two files with
>> the exact same name in the same folder. The two names must be different in
>> some way.  Figure out what this difference is, then it probably will become
>> clear why it happens.
>
> 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 name is:
> type: DB3 File
>

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 but with a different icon in the explorer
view.

John M. Drescher
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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
problem I cannot figure out after plenty of trying. I keep getting the
error message:

SQLite Error
no such table: MyTableName

I have the database in the project folder on my Win7 64 Pro system. The
app, when run, creates an empty database file of the same name as my
database file which is 13KB in size.


What do you mean, of the same name? It's impossible to have two files 
with the exact same name in the same folder. The two names must be 
different in some way.  Figure out what this difference is, then it 
probably will become clear why it happens.


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 name is:
type: DB3 File

Thanks,
Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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
problem I cannot figure out after plenty of trying. I keep getting the
error message:

SQLite Error
no such table: MyTableName

I have the database in the project folder on my Win7 64 Pro system. The
app, when run, creates an empty database file of the same name as my
database file which is 13KB in size.


What do you mean, of the same name? It's impossible to have two files 
with the exact same name in the same folder. The two names must be 
different in some way.  Figure out what this difference is, then it 
probably will become clear why it happens.


I just checked and the 0K file that is created is the same name except 
it has .db3 added to it's name.

Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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

SQLite Error
no such table: MyTableName

I have the database in the project folder on my Win7 64 Pro system. The
app, when run, creates an empty database file of the same name as my
database file which is 13KB in size.


What do you mean, of the same name? It's impossible to have two files 
with the exact same name in the same folder. The two names must be 
different in some way.  Figure out what this difference is, then it 
probably will become clear why it happens.

--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


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

SQLite Error
no such table: MyTableName

I have the database in the project folder on my Win7 64 Pro system. The app,
when run, creates an empty database file of the same name as my database
file which is 13KB in size. My SQLconnect.ConnectionString = "data source
=C:\Users\Dave\Documents\Visual Studio
2010\Projects\WindowsApplication5\MyDatabase.db3"

Anything to help me get off to a good start will be much appreciated. I am
using the latest 1.0.77.0 SQLite dll.

Thanks,
Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Newbie question on Data Source

2011-11-28 Thread Dave
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:


SQLite Error
no such table: MyTableName

I have the database in the project folder on my Win7 64 Pro system. The 
app, when run, creates an empty database file of the same name as my 
database file which is 13KB in size. My SQLconnect.ConnectionString = 
"data source =C:\Users\Dave\Documents\Visual Studio 
2010\Projects\WindowsApplication5\MyDatabase.db3"


Anything to help me get off to a good start will be much appreciated. I 
am using the latest 1.0.77.0 SQLite dll.


Thanks,
Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users