Xailer & OZ Software

Hi!
Trying to open a Paradox database that is already opened by another
application I get this error:
[Microsoft][ODBC Paradox Driver] Unexpected error from extern database
driver (11270)
When I close the other application I can open the database from my Xailer
program.
The other app does not open the database in exclusive mode - using Excel, I
can open
the file after the other app was started.
What can I do?
Best regards, Timm.

Timm:
Here's the trick:
Since there's no an ADO native connection for Paradox, you must use an
ODBC connection.
The ODBC connection needs a DSN in order to connect to the Paradox
Database, so, you must go the ODBC Data Sources in the Administrative
Tools into the Control panel, and create a new DSN to access paradox.
When configuring the DSN, click in the button "OPTION" at the bottom of
the configuration dialog, it will show more options, there's the trick:
Mark the checkbox EXCLUSIVE and you are DONE !!!!!!
Try it and let us know
Regards
Rene Flores
http://www.ciber-tec.com
Sodtalbers escribió:
> Hi!
>
> Trying to open a Paradox database that is already opened by another
> application I get this error:
> [Microsoft][ODBC Paradox Driver] Unexpected error from extern database
> driver (11270)
>
> When I close the other application I can open the database from my Xailer
> program.
> The other app does not open the database in exclusive mode - using Excel, I
> can open
> the file after the other app was started.
>
> What can I do?
>
> Best regards, Timm.
>
>

Timm:
Here's the trick:
Since there's no an ADO native connection for Paradox, you must use an
ODBC connection.
The ODBC connection needs a DSN in order to connect to the Paradox
Database, so, you must go the ODBC Data Sources in the Administrative
Tools into the Control panel, and create a new DSN to access paradox.
When configuring the DSN, click in the button "OPTION" at the bottom of
the configuration dialog, it will show more options, there's the trick:
Mark the checkbox EXCLUSIVE and you are DONE !!!!!!
Try it and let us know
Regards
Rene Flores
http://www.ciber-tec.com
Sodtalbers escribió:
> Hi!
>
> Trying to open a Paradox database that is already opened by another
> application I get this error:
> [Microsoft][ODBC Paradox Driver] Unexpected error from extern database
> driver (11270)
>
> When I close the other application I can open the database from my Xailer
> program.
> The other app does not open the database in exclusive mode - using Excel, I
> can open
> the file after the other app was started.
>
> What can I do?
>
> Best regards, Timm.
>
>

Rene,
many thanks for your answer!
I switched from ToAdoDataSource to ToOdbcDataSource but the problem remains:
[Microsoft][ODBC Paradox Driver] Unexpected error from extern database
driver (11270)
Best regards, Timm.
"Rene Flores" <"rflores[nospam]"@ciber-tec.com> schrieb im Newsbeitrag
news:[email=4a16d1af@svctag-j7w3v3j....]4a16d1af@svctag-j7w3v3j....[/email]
> Timm:
>
> Here's the trick:
>
> Since there's no an ADO native connection for Paradox, you must use an
> ODBC connection.
>
> The ODBC connection needs a DSN in order to connect to the Paradox
> Database, so, you must go the ODBC Data Sources in the Administrative
> Tools into the Control panel, and create a new DSN to access paradox.
>
> When configuring the DSN, click in the button "OPTION" at the bottom of
> the configuration dialog, it will show more options, there's the trick:
>
> Mark the checkbox EXCLUSIVE and you are DONE !!!!!!
>
> Try it and let us know
>
> Regards
>
> Rene Flores
> http://www.ciber-tec.com
>
>
> Sodtalbers escribió:
>> Hi!
>>
>> Trying to open a Paradox database that is already opened by another
>> application I get this error:
>> [Microsoft][ODBC Paradox Driver] Unexpected error from extern database
>> driver (11270)
>>
>> When I close the other application I can open the database from my Xailer
>> program.
>> The other app does not open the database in exclusive mode - using Excel,
>> I can open
>> the file after the other app was started.
>>
>> What can I do?
>>
>> Best regards, Timm.
>>

Rene,
many thanks for your answer!
I switched from ToAdoDataSource to ToOdbcDataSource but the problem remains:
[Microsoft][ODBC Paradox Driver] Unexpected error from extern database
driver (11270)
Best regards, Timm.
"Rene Flores" <"rflores[nospam]"@ciber-tec.com> schrieb im Newsbeitrag
news:[email=4a16d1af@svctag-j7w3v3j....]4a16d1af@svctag-j7w3v3j....[/email]
> Timm:
>
> Here's the trick:
>
> Since there's no an ADO native connection for Paradox, you must use an
> ODBC connection.
>
> The ODBC connection needs a DSN in order to connect to the Paradox
> Database, so, you must go the ODBC Data Sources in the Administrative
> Tools into the Control panel, and create a new DSN to access paradox.
>
> When configuring the DSN, click in the button "OPTION" at the bottom of
> the configuration dialog, it will show more options, there's the trick:
>
> Mark the checkbox EXCLUSIVE and you are DONE !!!!!!
>
> Try it and let us know
>
> Regards
>
> Rene Flores
> http://www.ciber-tec.com
>
>
> Sodtalbers escribió:
>> Hi!
>>
>> Trying to open a Paradox database that is already opened by another
>> application I get this error:
>> [Microsoft][ODBC Paradox Driver] Unexpected error from extern database
>> driver (11270)
>>
>> When I close the other application I can open the database from my Xailer
>> program.
>> The other app does not open the database in exclusive mode - using Excel,
>> I can open
>> the file after the other app was started.
>>
>> What can I do?
>>
>> Best regards, Timm.
>>