Re: ADO with paradox


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: "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default d
    ... OdbcConnection to connect to a DB2 data source. ... ODBC driver for DB2 has been installed properly. ... You can generate a connection string with a .udl ... Select provider and connection to connect to the ODBC data source. ...
    (microsoft.public.data.oledb)
  • Re: Getting Access vba connection string to identify the user
    ... But when I try to create a connection string that doesn't ... use this explicit definition, I get permission issues, and no ... How do I get the form (and vba code) to use the user's ... an ODBC data source, for instance). ...
    (comp.databases.ms-access)
  • RE: Q: using DSN
    ... Dim dsn As String = ConfigurationSettings.AppSettings ... You must first create the DSN via the "ODBC Data Source Administrator" ... Then use the following connection string - with your own DSN ...
    (microsoft.public.dotnet.framework.aspnet)
  • ODBC Prompt
    ... ".Properties= adPromptAlways" rendered an error stating ... Any clues on how to prompt the ODBC Data source dialog box and return ... the connection string after the user has selected the desired DSN? ...
    (microsoft.public.dotnet.languages.vb)
  • MailMerge with SQL Server, OpenDataSource problem
    ... Attaches the specified data source to the active document, ... Microsoft Query file instead of a specifying a data source, ... connection string, and a query string. ...
    (microsoft.public.office.developer.automation)