Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Fast answer needed!

Posted on 2000-04-27
9
158 Views
Last Modified: 2010-04-04
Hi everyone...

I need a fast answer to the following problem:

I want to connect to a Paradox database using the TADOQuery component. I have to provide a connection string, but I can't figure out what I have to put in there. The only specification is, that I can not use a predefined DSN, since I must be able to specify the driver (and all other data) manually.

Any help?

Jonny..
0
Comment
Question by:jonnyfive
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 7

Expert Comment

by:Motaz
ID: 2755025
The best connection to Paradox tables is to use BDE, TTable, TQuery...

I didn't think that ADO can wotk with Paradox, because ADO is a Microsoft's and Microsoft didn't know Paradox.

Motaz
0
 

Author Comment

by:jonnyfive
ID: 2755038
Hi Motaz...

Sorry, you're wrong about that. If I provide a DSN, it works just fine. But I want to prevent providing a DSN, since all our products using BDE and we only start to use ADO. This would mean, that we have to install a additional DSN on all client machines, which I want to prevent. Another solution I can accept, if someone knows how to create a DSN from Delphi.

Regards, Jonny...
0
 

Author Comment

by:jonnyfive
ID: 2755051
Hi Motaz...

Sorry, you're wrong about that. If I provide a DSN, it works just fine. But I want to prevent providing a DSN, since all our products using BDE and we only start to use ADO. This would mean, that we have to install a additional DSN on all client machines, which I want to prevent. Another solution I can accept, if someone knows how to create a DSN from Delphi.

Regards, Jonny...
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 2

Expert Comment

by:NetoMan
ID: 2755468
jonnyfive.... just like a suggestion, why don´t you install the DSN from Delphi when the application doesn´t find it ?

I did that in the past with a DSN of a ODBC driver for Sybase.

You can Use RegEdit from Delphi to write the apropiates instances and keys params (like the driver path) and it´s just works equally as if you installed the DSN...

If you want to know more about it... let me know and I can provide the code I used.

NetoMan :)
0
 
LVL 1

Expert Comment

by:l8knight
ID: 2755630
The simplest answer ain't so simple...but here goes.

Create a FileDSN that points to your database, now you can ship the *.dsn file you just created with your software and access it like so...

Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="CollatingSequence=ASCII;DBQ=H:\PROGRAM FILES\COMMON FILES\BORLAND SHARED\DATA;DefaultDir=H:\PROGRAM FILES\COMMON FILES\BORLAND SHARED\DATA;Driver={Microsoft Paradox Driver (*.db )};DriverId=538;FIL=Paradox 5.X;FILEDSN=H:\Program Files\Common Files\ODBC\Data Sources\Paradox.dsn;"

or

you can open it (the *.dsn file) with a text editor and delete the

[ODBC]

from the top line, then concatenate all the lines together seperated by semi-colons and insert them into a connection string like this...

Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="CollatingSequence=ASCII;DBQ=H:\PROGRAM FILES\COMMON FILES\BORLAND SHARED\DATA;DefaultDir=H:\PROGRAM FILES\COMMON FILES\BORLAND SHARED\DATA;Driver={Microsoft Paradox Driver (*.db )};DriverId=538;FIL=Paradox 5.X;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;ParadoxNetPath=H:\WINNT\System32;ParadoxNetStyle=3.x;ParadoxUserName=admin;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;"

hope this gives you an idea

regards

l8knight
0
 
LVL 1

Accepted Solution

by:
l8knight earned 200 total points
ID: 2755635
Sorry the above comment was actually an answer. I'm new at this :) please oh please forgive me...
0
 
LVL 2

Expert Comment

by:hhamster
ID: 2756890
following
0
 
LVL 2

Expert Comment

by:NetoMan
ID: 2757037
l8knight, As you say you are new:

The philosophy here at e.e. is always post answers or suggestions as a comment because that will not block the question to other experts that maybe will have a better answer (like you). And then the people who ask will have several alternatives to resolve his problem and decide was the best alternative to him. (he can Accept a comment like if was a Answer).

So welcome!!!!

NetoMan :)
0
 
LVL 1

Expert Comment

by:l8knight
ID: 2759171
thankyou for your comments Netoman, I will abide by the e.e. philosophy from now on. :)

regards

l8knight
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi XE10, MySQL Query 4 164
Comparing dates in Delphi. Greater than/ Less than 3 208
select query - oracle 16 100
Dev express lookupcombo 3 34
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question