Re: ADO with paradox

That works! Thanks.That's similar to what I had done in the past with an
Access database.


I cannot establish a connection to the Paradox database for my tADOQuery
object. Apparently, I can assign a tADOConnection object or a connection
string to the query object. So I am using a connection string, just to
try
and eliminate components.

In the connection string dialog, I opt to "Use Connection String". In the
build process, it asks me to select (and create) an ODBC data source. I
don't understand this part. I have used ADO with an MSAccess database,
and
this did not require a data source. Anyway my connection string ends up
looking like this. (without the carriage returns). I don't know why it
puts
the curly braces around the driver.
You can connect to Paradox with the Jet Oledb provider with a connection
string
like this
'Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Paradox 7.X;Persist
Security Info=False;Data Source=C:\YourDir\';

This doesn't work all that well but better than using ODBC

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.

Relevant Pages

  • Re: Syntax
    ... The connection string format is not valid. ... connection string with zero components is set on database connection manager. ... Access database connection string, and not the Expression issue you're ...
    (microsoft.public.sqlserver.dts)
  • Re: [SOLVED] Cannot display provider-specific login prompt
    ... scenario where the program wouldn't have to know about the database, ... ConnectionStringBuilder up to a PropertyGrid for the end user to populate), ... details of the connection, for the sake of the program being able to connect ... information about the connection string that I will need. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Complicated Connection Problems bewteen ADP and SQL Server
    ... front end on the 5-8 workstations where the users happen to sit. ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... thought that I should instead change my connection string to something ...
    (microsoft.public.access.adp.sqlserver)
  • Re: DateCreated
    ... > Access database. ... you haven't indicated what breaks or what error you get when you change the connection string and any code ...
    (microsoft.public.vb.database.ado)
  • Re: Fujitsu NetCobol 8.0
    ... You cannot use a connection string in the way you have shown and expect it ... Any Fujitsu NetCobol / PowerCobol users here? ... Use the ADO control provided in PowerCOBOL, ...
    (comp.lang.cobol)