vb.net 如何打开 .db 悖论文件
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/15948333/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to open the .db paradox file
提问by Rahul Shirphule
i want to view the test.db file, i search for it's editor but didn't get any one So please help to see the it in editor as like sql server.
我想查看 test.db 文件，我搜索了它的编辑器，但没有找到任何一个 所以请帮助在编辑器中查看它，就像 sql server 一样。
i found some sqlite editor but it's not an sqlite file on most forum it say that it is an paradox .db file.
我找到了一些 sqlite 编辑器，但在大多数论坛上它不是一个 sqlite 文件，它说它是一个悖论 .db 文件。
So how do i open it
那么我该如何打开它
Thanks
谢谢
回答by Tor Langlo
To access Paradox tables in .NET you can use ODBC. Here's a small example (in C#):
要访问 .NET 中的 Paradox 表，您可以使用 ODBC。这是一个小例子（在 C# 中）：
private static void RunMinimumParadoxTest()
{
const string ConnectionStringFormat =
"Driver={{Microsoft Paradox Driver (*.db )}};Uid={0};UserCommitSync=Yes;Threads=3;SafeTransactions=0;" +
"ParadoxUserName={0};ParadoxNetStyle=4.x;ParadoxNetPath={1};PageTimeout=5;MaxScanRows=8;" +
"MaxBufferSize=65535;DriverID=538;Fil=Paradox 7.X;DefaultDir={2};Dbq={2};CollatingSequence={3}";
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.Odbc");
using (DbConnection connection = factory.CreateConnection())
{
string userName = "Tor";
string paradoxNetPath = @"C:\BdeNet";
string databasePath = @"C:\LangloMainSrv\LData\Ordre\LordWin\Database2011";
string collatingSequence = "Norwegian-Danish";
connection.ConnectionString =
String.Format(ConnectionStringFormat, userName, paradoxNetPath, databasePath, collatingSequence);
connection.Open();
using (DbCommand command = connection.CreateCommand())
{
command.CommandText = "select Count(*) from [OrdreDet] where [Ordrenr] = 81699002";
object itemCount = command.ExecuteScalar();
Console.WriteLine("Order items: {0}", itemCount);
Console.ReadKey();
}
}
}
Also see the following link for more details: http://msdn.microsoft.com/en-us/library/ms710922(VS.85).aspx.
另请参阅以下链接以了解更多详细信息：http: //msdn.microsoft.com/en-us/library/ms710922(VS.85).aspx。
回答by Patrick Moloney
A Paradox db file contains just one flat table. The actual structure of the DB file changed over time and different versions. But you can usually open the DB file with MS Excel - of course that changed over different versions too.
Paradox db 文件只包含一个平面表。DB 文件的实际结构随着时间和版本的不同而变化。但是您通常可以使用 MS Excel 打开 DB 文件 - 当然在不同版本中也会发生变化。
As noted above, other database applications, also including Paradox for Dos and Paradox for Windows, will open the file and other features as well. The key, for example is in the PX file with the same table name.
如上所述，其他数据库应用程序，包括 Paradox for Dos 和 Paradox for Windows，也将打开文件和其他功能。例如，密钥位于具有相同表名的 PX 文件中。
All of this assumes the table is not password protected, which an application database could be - or that you know the password. Beware if you get an error to that effect.
所有这些都假设该表不受密码保护，应用程序数据库可能是密码保护 - 或者您知道密码。请注意，如果您遇到这种情况的错误。
回答by Samuli Hyn?nen
You can open and view Paradox database files using Database Desktop that is shipped with Borland C++Builder. A free alternative is BB's Database Desktop. The software may require administrator privileges to run correctly.
您可以使用 Borland C++Builder 附带的 Database Desktop 打开和查看 Paradox 数据库文件。一个免费的替代品是BB 的数据库桌面。该软件可能需要管理员权限才能正确运行。
回答by prem
You can use gnumeric spreadsheet, paradox-db-reader or BB database desktop to read db paradox file. BB database dekstop able to read XG0 file too.
您可以使用 gnumeric 电子表格、paradox-db-reader 或 BB 数据库桌面来读取 db paradox 文件。BB 数据库 dekstop 也能够读取 XG0 文件。
回答by Mic
BB's Database Desktop now called JEDI Database Desktop, but project is closed and it couldn't edit my table. I have had to use some hack: open *.db file in MS Excel 2007, edit it, export to *.csv, close file then Open *.db file in Paradox Data Editor 3.2.0, clear all table data and import previosly saved csv-file. And it works (don't know why but this app can't insert row in my file itself)!
BB 的数据库桌面现在称为 JEDI 数据库桌面，但项目已关闭且无法编辑我的表。我不得不使用一些技巧：在 MS Excel 2007 中打开 *.db 文件，编辑它，导出到 *.csv，关闭文件然后在 Paradox Data Editor 3.2.0 中打开 *.db 文件，清除所有表数据并导入以前保存的 csv 文件。它有效（不知道为什么，但此应用程序无法在我的文件本身中插入行）！
