Data in a local file

[David P. Donahue]

How would I have a SqlConnection object point to a local file as a
database, for example a file named tables.db that's in the same folder
as the program output directory?

[Greg Young]

You would not do this with a SqlConnection.you could however do this quite
easily with an embeded databse like Sqlite http://www.sqlite.org/. You can
download the managed provider here http://adodotnetsqlite.sourceforge.net/.

Peter also has an article on it
http://www.eggheadcafe.com/articles/20040714.asp and another on the
SqlLiteHelper class which should get you going
http://www.eggheadcafe.com/articles/20050315.asp

Cheers,

Greg Young
MVP - C#
http://geekswithblogs.net/gyoung
You could however do this quite easily
"David P. Donahue" <dd******@ccs.neu.edu> wrote in message
news:uB**************@TK2MSFTNGP02.phx.gbl...

How would I have a SqlConnection object point to a local file as a
database, for example a file named tables.db that's in the same folder as
the program output directory?

[Nicholas Paldino [.NET/C# MVP]]

David,

The clases in the System.Data.SqlClient namespace are meant specifically
for connecting to Sql Server or Sql Server express. You can't just connect
to an arbitrary file.

What is the format of the data in the file? If it is for another
database provider, then you should be able to get a data provider from them
which sticks to the .NET model for data providers.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"David P. Donahue" <dd******@ccs.neu.edu> wrote in message
news:uB**************@TK2MSFTNGP02.phx.gbl...

How would I have a SqlConnection object point to a local file as a
database, for example a file named tables.db that's in the same folder as
the program output directory?

[David P. Donahue]

> What is the format of the data in the file? If it is for another

database provider, then you should be able to get a data provider from them
which sticks to the .NET model for data providers.

Not sure what specific format it's in. It was converted from a dbase
file, if that helps. Is there a way to find out what format it is?

[Michael Nemtsev]

Hello David,

For .db ext it could be several type of dbs, like foxpro, dbase and etc
I recomend to use either ODBC for this or library for native access, like
CodeBase (it works with seral types of .DB bases)

What is the format of the data in the file? If it is for another
database provider, then you should be able to get a data provider
from them which sticks to the .NET model for data providers.

DD> Not sure what specific format it's in. It was converted from a
DD> dbase file, if that helps. Is there a way to find out what format
DD> it is?
DD>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Nicholas Paldino [.NET/C# MVP]]

David,

Well, if it is a dbase file, then you could find a dbase ODBC driver and
then use the classes in the System.Data.Odbc namespace. The thing is, if it
was converted, then what was it converted to?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"David P. Donahue" <dd******@ccs.neu.edu> wrote in message
news:44************@ccs.neu.edu...

What is the format of the data in the file? If it is for another
database provider, then you should be able to get a data provider from
them which sticks to the .NET model for data providers.

Not sure what specific format it's in. It was converted from a dbase
file, if that helps. Is there a way to find out what format it is?

[David P. Donahue]

> Well, if it is a dbase file, then you could find a dbase ODBC driver and

then use the classes in the System.Data.Odbc namespace. The thing is, if it
was converted, then what was it converted to?

The most I could get from the developer who sent it to me is that it's a
Paradox file. Not something I've worked with (the only local-file
databases I've ever seen were MS Access) so I really don't know much
about that.

I can add it to my ODBC User DSN just fine, but it's been years since
I've used that. What would the connection string be for an
OdbcConnection object be then?

[David P. Donahue]

Wait, I think www.connectionstring.net has what I'm looking for (damn
this looks like a useful site, I wish I'd found it months ago). :)

[JimD]

David P. Donahue wrote:

Wait, I think www.connectionstring.net has what I'm looking for (damn
this looks like a useful site, I wish I'd found it months ago). :)

I think you mean http://www.connectionstrings.com/

Jim
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
You roll an 18 in Dex and see if you
don't end up with a girlfriend
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
JimD
Central FL, USA, Earth, Sol