<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=us-ascii" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Joost van der Sluis wrote:
<blockquote cite="mid:1228129599.6795.18.camel@wsjoost" type="cite">
<pre wrap="">Op maandag 01-12-2008 om 16:45 uur [tijdzone +1030], schreef Eric March:
</pre>
<blockquote type="cite">
<pre wrap="">Tom Lisjac wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi Eric,
</pre>
<blockquote type="cite">
<pre wrap="">I have followed source advice but can't connect.
Can anyone help and/or is there a manual?
</pre>
</blockquote>
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">Error: invalid compiler: file
There must be something in my source looking for a compiler in the wrong
place :-(
</pre>
</blockquote>
<pre wrap="">The errors you're getting in the tutorial example are from some hard
coded paths in the database_try.lpi project file. It's not a problem
with your system. Since Lazarus has changed since the example was
written, it might be easier to start your project with the sqldb
components.
To install sqldb, go to "Package->Open package file", select and
install the lazarus/components/sqldb/sqldblaz.lpk package. After
Lazarus recompiles, you should see a "SQLdb" tab. Drop a Mysql50
(TMySQL50Connection) on a new form. In the object inspector for this
component, enter the hostname (probably localhost), a database (test
or mysql as an example or a database you've already created) and the
username and password for the database or the "root" you set when
installing mysql. At this point, establishing a successful mysql
connection is being able to set the Connected property to true without
an error.
</pre>
</blockquote>
<pre wrap="">Thanks heaps for the help. I Get this far and changing "Connected" to
"True"
gives the error
"Cannot load MySQL library "libmysqlclient.so. Please check your
installation."
</pre>
</blockquote>
<pre wrap=""><!---->
Maybe we have to improve that error-message even further. You have to
install MySQL to be able to work with it.
So install the mysql-client before you can use it.
On linux it could be that you also have to install the '-dev' package.
Joost
_______________________________________________
Lazarus mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Lazarus@lazarus.freepascal.org">Lazarus@lazarus.freepascal.org</a>
<a class="moz-txt-link-freetext" href="http://www.lazarus.freepascal.org/mailman/listinfo/lazarus">http://www.lazarus.freepascal.org/mailman/listinfo/lazarus</a>
</pre>
</blockquote>
Thank you all for your patience. I installed the MYSQL Library <br>
and now can set MySQL50Connection1 to true without an error.<br>
I tested it by entering an invalid database name in the properties <br>
(contact instead of contacts) and got an expected error. I then <br>
placed SQLTransaction1 and SQLQuery1 on the form. I presume <br>
I need to set the properties on SQLTransaction1 before I set <br>
properties on SQLQuery1. Soo, the situation is ....<br>
<br>
<br>
MySQL50Connection1 properties:<br>
CharSet = blank<br>
Connected = True<br>
DatabaseName = contacts<br>
Dialect = 0<br>
Hostname = localhost<br>
KeepConnection = True<br>
LoginPrompt = False<br>
Name = MySQL50Connection1<br>
Params = (TStrings) = empty<br>
Password = blank<br>
Role = blank<br>
Streamedconnected = True<br>
Tag = 0<br>
*Transaction = blank<br>
UserName = root<br>
<br>
*I can change Transaction property to SQLTransaction1 but doesn't make
any difference.<br>
<br>
<br>
<br>
SQLTransaction1 properties:<br>
Action = caNone<br>
Active = False (Won't change to true, but does not return any error
when attempted)<br>
If I blank out the Database property and attempt Active = True <br>
get an error Database not assigned.<br>
Database = MySQL50Connection1 (The only drop down option as expected)<br>
Params = (TStringList) which is empty<br>
Tag = 0<br>
<br>
<br>
<br>
I am guessing the SQLTransaction1 needs to be set to TRUE before I can <br>
set the SQLQuery1 properties. I get (and expected) an error on
SQLQuery1.<br>
<br>
SQLQuery1 properties:<br>
Active = False "True" gives error = "Transaction of connection not
set" (Expected)<br>
Database = MySQL50Connection1<br>
DataSource = (blank)<br>
..<br>
..<br>
SQL = select * from people (A table in the contacts db)<br>
StatementType = stSelect<br>
Tag = 0<br>
Transaction = SQLTransaction1<br>
<br>
Also, MYSQL details below, in case it helps.<br>
<br>
mysql> \s<br>
--------------<br>
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using
readline 5.2<br>
<br>
Connection id: 98<br>
Current database: contacts<br>
Current user: root@localhost<br>
SSL: Not in use<br>
Current pager: stdout<br>
Using outfile: ''<br>
Using delimiter: ;<br>
Server version: 5.0.51a-3ubuntu5.3 (Ubuntu)<br>
Protocol version: 10<br>
Connection: Localhost via UNIX socket<br>
Server characterset: latin1<br>
Db characterset: latin1<br>
Client characterset: latin1<br>
Conn. characterset: latin1<br>
UNIX socket: /var/run/mysqld/mysqld.sock<br>
Uptime: 2 days 38 min 8 sec<br>
<br>
Threads: 5 Questions: 10934 Slow queries: 0 Opens: 245 Flush
tables: 1 Open tables: 64 Queries per second avg: 0.062<br>
--------------<br>
<br>
mysql> <br>
<br>
<br>
TIA<br>
Eric March<br>
<br>
<br>
</body>
</html>