[fpc-pascal] Connecting to a database from a commandline pascal program

Terry A. Haimann terry at haimann.us
Fri Feb 16 16:25:31 CET 2018


Hello,

I am trying to write a command Line Pascal program to connect to a MySQL
database using the ZeosDBO Library. I am sure I have done something
stupid. 

I have it now so that it will compile, but it crashes as soon as I try
to modify my TZConnection variable.


I have it defined as:

	MyConnection:		TZconnection;

And code is defined as:

	WriteLn('2');
	MyConnection.Create(Nil);
	// MyQuery.Create(Nil);
	WriteLn('2.0);
	MyConnection := '127.0.0.1';
	WriteLn('2.1');
	MyConnection.Protocol	:= 'mysql';
	WriteLn('2.2');
	MyConnection.Database 	:= 'MyDatabase';
	WriteLn('2.3');
	MyConnection.User	:= 'MyUser';
	WriteLn('2.4');
	MyConnection.Password 	:= 'MyPass';
	WriteLn('2.5');
	MyConnection.Connected := True;
	WriteLn('2.6');

It never hits 2.0, so I believe it is dying on the create. Am I doing
the create wrong?  I can't find any examples as too doing this, I have
tried googling it.  Most of the examples I see are doing this from
Lazarus.  Not from a command line Free Pascal program. 

Thanks in advance, 	Terry H. 



More information about the fpc-pascal mailing list