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.

Provider=MSDASQL.1;
Persist Security Info=False;
Extended Properties="CollatingSequence=ASCII;
DefaultDir=G:\SYSTEM;
Driver={Microsoft Paradox Driver (*.db )};
DriverId=538;FIL=Paradox 5.X;
FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\MyPDXDataSource.dsn;
MaxBufferSize=2048;
MaxScanRows=8;
PageTimeout=5;
ParadoxNetPath=C:\WINNT\system32;
ParadoxNetStyle=4.x;
ParadoxUserName=admin;
SafeTransactions=0;
Threads=3;
UID=admin;
UserCommitSync=Yes;"


.

Relevant Pages

  • Re: ADO connections question
    ... Function CreateADOObjects(ConnectionString as string) ... you'll see this error if the connection has not been ... I have a specific login form that calls the dbLogin function as shown ... Dim strCriteria As String ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Nochmals Treeview
    ... private void button1_Click(object sender, System.EventArgs e) { ... private void TabelleAnlegen(string strDBPfad, string strDB, string strTabellenName){ ... OleDbConnection connection = new OleDbConnection; ... OleDbCommand command = new OleDbCommand; ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)
  • RE: Error using Login control ASP.NET App_Data Folder
    ... the UserInstance type of connection string is for SQLEXPRESS only and is ... Server Management Studio and use a standard connection ... An error has occurred while establishing a connection to the server. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ExecuteReader requires an open and available Connection.
    ... you have ALL your users sharing one connection. ... Public Shared Function GetServerAs String ... Dim theServer As String ...
    (microsoft.public.dotnet.framework.aspnet)
  • Change Connection String during runtime
    ... connection is stored in the app.config file. ... connection string without exiting the application. ... Dim newConnection As String ... Private Sub RecordDatabase_Enter(ByVal sender As Object, ...
    (microsoft.public.dotnet.languages.vb)