In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

TAdoDataSource and Paradox

Xailer professional forum in English
Responder
Guest

TAdoDataSource and Paradox

Mensaje por Guest »

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 Flores
Mensajes: 620
Registrado: Jue Mar 23, 2006 2:39 am

TAdoDataSource and Paradox

Mensaje por Rene Flores »

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 Flores
Mensajes: 620
Registrado: Jue Mar 23, 2006 2:39 am

TAdoDataSource and Paradox

Mensaje por Rene Flores »

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.
>
>
Guest

TAdoDataSource and Paradox

Mensaje por Guest »

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.
>>
Guest

TAdoDataSource and Paradox

Mensaje por Guest »

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.
>>
Responder