MY DAC sql

hI,

MyDac component.

I installed the trial. What happens when the 60 days are over. Will executable programs ive made with it stop working?

Also,

Can someone give me an example of how to connect to an exising SQL database using MyDac

Ill need it so onformcreate, it connects and enters a new field in the SQL.

if you can write an example, so i can edit the details of my SQL server , pass and database.
966Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mahdi78Commented:
try this

with MyConnection1 do
 begin
 Server := 'yourserver';
 Port := 0; // your MSSQl port
 Username := 'username';
 Password := 'passwoed';
 Database := 'yourdatabase';
 connect;
end;
0
966Author Commented:
what component should i put on the form, As there is lots by mydac
0
966Author Commented:
hang on, ignore that. ^^  give me a few mins
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

966Author Commented:
thanks it works great, but how wouldi add something into the table, say for example.. under users add another field ?
0
966Author Commented:
and also is there a way to list the database ? or if its too long code, tollist the database name
0
Mahdi78Commented:
to open table use the following

MyTable1.Connection := Myconnection1;
MyTable1.TableName := 'yourtable';
MyTable1.Open;

to get database list into ListBox1 use the following

procedure TForm1.Button1Click(Sender: TObject);
begin
Myconnection1.GetDatabaseNames(ListBox1.Items);
end;
0
966Author Commented:
sorry i dont mean to ask questions, but

1) how would i actually add a name inside the users field of the SQL, its the onyl field there

2) where can i get information examples and tutorial on these compoents

3) what happens when trial expires, does it effect any of my applications i have created ?
0
966Author Commented:
also

Myconnection1.GetDatabaseNames(ListBox1.Items);

how can that list DATABASE_HELLO instead of them all
0
Mahdi78Commented:
1 - If you know SQL add field with TMyQuery, else use TMyTable
2 - About tutorial, check Demo folder of component
3 - I don't know what happen
4 - to use DATABASE_HELLO database use my fist post

with MyConnection1 do
 begin
 Server := 'yourserver';
 Port := 0;
 Username := 'username';
 Password := 'passwoed';
 Database := 'DATABASE_HELLO';
 connect;
end;
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
As far as your initial question, I believe they will not work but if they do, you will be in violation of the EULA.

The trial version is just that for a trial.  It is meant to allow you to see if Crystal is for you.  
In the  past, Crystal has been very careful in guarding and protecting its products.  I have seen nothing to change that with their acquisition by SAP.  If anything they have gotten more aggressive.

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.