If the directory does not contain one of these files, the Paradox driver creates one. The full path of the directory containing a Paradox lock database, because it contains either the file (in Paradox 4. This sets the same option as Page Timeout in the setup dialog box. Note that this option applies to all data sources that use the ODBC driver. The default is 600 tenths of a second (60 seconds). Specifies the period of time, in tenths of a second, that a page (if not used) remains in the buffer before being removed. This sets the same option as Exclusive in the setup dialog box.įile type Paradox 3.x, Paradox 4.x, or Paradox 5.x Can be true (exclusive mode) or false (shared mode). The path specification to the driver DLL.ĭetermines whether the database will be opened in exclusive mode (accessed by only one user at a time) or shared mode (accessed by more than one user at a time). This sets the same option as Description in the setup dialog box. This sets the same option as Database in the setup dialog box.Ī description of the data in the data source. This sets the same option as Collating Sequence in the setup dialog box. When the Paradox driver is used, the sequence can be ASCII (default), International, Swedish-Finnish, or Norwegian-Danish. The sequence in which the fields are sorted. The SQLConfigDataSource function that is used to add, modify, or delete a data source dynamically uses the following keywords. For general information about this function, see the appropriate topic under ODBC API Reference.
but is running, time to move on.This topic provides Paradox Driver-specific information. Hope this helps, i sure wasted a great deal of time to get this running. Now you only have to choose your destination. "Automagicaly" everything goes as it should, you can see the paradox files appearing as tables, their columns, etc. In a Data Flow Task, add an ADO Net Source using the created connection manager Configure the created connection manager to use the provider ".Net Providers\Odbc Data Provider", and in the Data source specification select the created system dsn In SSIS, create an ADO.Net connection manager using the previous created DSN Create a System DSN with the Paradox Driver, using ODBC 32 bit Manager, usualy at :\Windows\SysWOW64\odbcad32.exe, configuring it to point to the folder where the paradox. So, after installing the BDE, solved the problem with these steps (witch i think all of you should already have tried with no success):
This is the name of the downloaded zip file "mprestwood_KB100537_attachment.zip". I have installed the 5.2.0.2 version downloaded at You need to register into the site in order to get it. Run into this problem recently when trying to import Paradox 5.x files to SQL Server 2008 R2 via SSIS in Windows 7.
0 kommentar(er)
