966
asked on
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.
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.
ASKER
what component should i put on the form, As there is lots by mydac
ASKER
hang on, ignore that. ^^ give me a few mins
ASKER
thanks it works great, but how wouldi add something into the table, say for example.. under users add another field ?
ASKER
and also is there a way to list the database ? or if its too long code, tollist the database name
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.GetDatabaseN ames(ListB ox1.Items) ;
end;
MyTable1.Connection := Myconnection1;
MyTable1.TableName := 'yourtable';
MyTable1.Open;
to get database list into ListBox1 use the following
procedure TForm1.Button1Click(Sender
begin
Myconnection1.GetDatabaseN
end;
ASKER
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 ?
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 ?
ASKER
also
Myconnection1.GetDatabaseN ames(ListB ox1.Items) ;
how can that list DATABASE_HELLO instead of them all
Myconnection1.GetDatabaseN
how can that list DATABASE_HELLO instead of them all
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
with MyConnection1 do
begin
Server := 'yourserver';
Port := 0; // your MSSQl port
Username := 'username';
Password := 'passwoed';
Database := 'yourdatabase';
connect;
end;