Thread: Testing embedded SQL in C
<div style="background-color:"><p>Hi,<p>How are you doing?<p>First, I am testing if this email address is valid. It is
thefirst time that I am using this account. I have a question about how to start write embedded SQL in C programming
code.What are the basic requirements in the .pgc file to have the embedded SQL running.<p>This is my coding which is
aimedat testing if embedded SQL in C programming code is possible for my operating system Debian GNU/Linux.<p>#include
<stdio.h><p><br/>int main ( )<br />{<p>EXEC SQL CONNECT TO <a href="mailto:database@sql.{ip
address}.com">database@sql.{ipaddress}.com</a> :80;<p>EXEC SQL INSERT INTO database (tab_number) VALUES (4);<br />EXEC
SQLSELECT * FROM database;<p>return 1;<p>}<p> <p>Regards,<p>Huan<p>Huan Bui<p>347-602-7029<p><a
href="mailto:hbnt@hotmail.com">hbnt@hotmail.com</a><p><br/><br /><br /> <div><p> </div></div><br clear="all" /><hr /><a
href="http://g.msn.com/8HMBENUS/2755??PS=47575"target="_top">Check out all that glitters with the MSN Entertainment
Guideto the Academy Awards� </a>
On Mon, 2007-02-12 at 15:16 -0500, HT NB wrote:
> Hi,
>
> How are you doing?
>
> First, I am testing if this email address is valid. It is the first
> time that I am using this account. I have a question about how to
> start write embedded SQL in C programming code. What are the basic
> requirements in the .pgc file to have the embedded SQL running.
>
> This is my coding which is aimed at testing if embedded SQL in C
> programming code is possible for my operating system Debian GNU/Linux.
>
> #include <stdio.h>
>
>
> int main ( )
> {
>
> EXEC SQL CONNECT TO database@sql.{ip address}.com :80;
>
> EXEC SQL INSERT INTO database (tab_number) VALUES (4);
> EXEC SQL SELECT * FROM database;
>
> return 1;
>
> }
>
>
see http://www.postgresql.org/docs/8.2/static/ecpg.html
see also
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/ecpg/test/
HT NB wrote:
> Hi,
>
> How are you doing?
>
> First, I am testing if this email address is valid. It is the first time that I
> am using this account. I have a question about how to start write embedded SQL
> in C programming code. What are the basic requirements in the .pgc file to have
> the embedded SQL running.
>
> This is my coding which is aimed at testing if embedded SQL in C programming
> code is possible for my operating system Debian GNU/Linux.
>
> #include <stdio.h>
>
>
> int main ( )
> {
>
> EXEC SQL CONNECT TO database@sql.{ip address}.com <mailto:database@sql.{ip
> address}.com> :80;
try -
EXEC SQL CONNECT TO database@{ip address}:5432 USER mylogin;
The one thing from your code I would question is your specifying port
80. That is the port for a web server not postgresql. Can you access the
postgresql server directly or are you trying to get to it through a web
server? If you are going through the web server then embedded sql won't
work, you will need to deal with http requests and responses.
> EXEC SQL INSERT INTO database (tab_number) VALUES (4);
> EXEC SQL SELECT * FROM database;
>
> return 1;
>
> }
>
--
Shane Ambler
pgSQL@007Marketing.com
Get Sheeky @ http://Sheeky.Biz