Link to home
Start Free TrialLog in
Avatar of cacandz
cacandz

asked on

Connection String setup...

how do i set up Connection String property for ADO?
Avatar of Motaz
Motaz

What kind of database you which to connect to?

You can make it by clicking build button then follow the wizard.
ASKER CERTIFIED SOLUTION
Avatar of Motaz
Motaz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This is an example of connecting to MS-Access database:

'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' +
'ADatabaseName' + ';Persist Security Info=False';

Motaz
If u need setup ado connstr in your program like in delphi:

uses ADOConEd;

...

    ADOConnection1.ConnectionString := Edit1.Text;
    EditConnectionString(ADOConnection1);
    Edit1.Text := ADOConnection1.ConnectionString;
cacandz:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

accept Motaz's comment as answer

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

geobul
EE Cleanup Volunteer