dBase Connection

[Kshitij Rajhans]

HI,

How to connect to the dBase database?? One option is to create a DSN and
use it.But I want to do it in some other way like just passing a
connection string or like that.

Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mark Johnson]

http://www.mj10777.de/NETFramework/A...orer/index.htm

This Project can also read dBase Files
See /DataBase/DataBase.cs Property i_EngineType where the Connection strings
for ODBC, OLEDB and Sql are built.
dBase is EngineType 10, 11 and 12.

The Help file also documents the Connection Strings.

Mark Johnson, Berlin Germany
mj*****@mj10777 .de

"Kshitij Rajhans" <ks************ *@rediffmail.co m> schrieb im Newsbeitrag
news:uD******** ******@TK2MSFTN GP10.phx.gbl...

HI,

How to connect to the dBase database?? One option is to create a DSN and
use it.But I want to do it in some other way like just passing a
connection string or like that.

Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Cindy Winegarden]

In news: uD************* *@TK2MSFTNGP10. phx.gbl,
Kshitij Rajhans <ks************ *@rediffmail.co m> wrote:

How to connect to the dBase database?? One option is to create a DSN
and use it.But I want to do it in some other way like just passing a
connection string or like that.

Hi Kshitij,

You may be able to read your Dbase tables with the FoxPro and Visual FoxPro
OLE DB provider, available from
http://msdn.microsoft.com/vfoxpro/do...s/default.aspx.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci************* *@mvps.org www.cindywinegarden.com

[Anders Eriksson]

On Wed, 03 Mar 2004 22:51:54 -0800, Kshitij Rajhans wrote:

HI,

How to connect to the dBase database?? One option is to create a DSN and
use it.But I want to do it in some other way like just passing a
connection string or like that.

Have a look at "ADO Connection Strings" By Carlos Antollini
http://www.codeproject.com/database/...ionstrings.asp

BTW, DON'T CLICK ON THE SHORTCUTS, they are pointing to the wrong page.
Just browse the page!
The way I usually do it is to create an UDL file, just create a textfile
and rename it so it has the extension .UDL
Then double-click on it. You will now get a "wizard" for creating a
connection string.

I select 'Microsoft Jet 4.0 OLE DB' as the provider.
Then you need to edit Extended Properties under the All tab
it should have the value: dBase 5.0
NB! Microsoft does NOT support dBase database formats above 5.0!!!

The big advantage of the UDL file is that you can change everything without
touching the program!

To open the database just enter the path to the udl file.

NB! This is ADO in C++ and not for ADO.NET, but I think you get the
picture...
CString udl
udl = "c:\\dummy.udl" ; // here you read the registry or something
m_pConn->Open(_bstr_t(u dl),
_bstr_t ( "" ),
_bstr_t ( "" ),
adModeUnknown );

// Anders

--
To me, boxing is like couples having sex, except there's no foreplay,
no naked people and the people are hitting each other with big red gloves.