ECPG Connect user :variable problem
От | Ryan Mooney |
---|---|
Тема | ECPG Connect user :variable problem |
Дата | |
Msg-id | 20030819221656.GA10232@pcslink.com обсуждение исходный текст |
Ответы |
Re: ECPG Connect user :variable problem
Re: ECPG Connect user :variable problem |
Список | pgsql-interfaces |
Hello, I'm having a major problem using ecpg with 7.4beta1. The problem is that if I try to pass in the username or password as :variables to the EXEC SQL CONNECT code they are essentially ignored (replaced by " ?"). I've tried it on both redhat 7.2 IA64 and Redhat 9.0 IA32 (different enough that I don't think its the platform). I also tried it with postgres 7.3.2 which seemed to do the "right thing" and put the variables into the ECPGconnect call. Any thoughts? ------------------------------<snip "connect.pgc">--------------------------------- int pg_connect(void) { EXEC SQL BEGIN DECLARE SECTION; char *target = "dbname"; char *connection_name = "myconnection"; char *uname = "myuser"; char *password = "mypassword"; EXEC SQL END DECLARE SECTION; EXEC SQL CONNECT TO :target as :connection_name user :uname using :password; } ------------------------------<snip "connect.c">--------------------------------- int pg_connect(void) { /* exec sql begin declare section */ #line 5 "connect.pgc"char * target = "dbname" ; #line 6 "connect.pgc"char * connection_name = "myconnection" ; #line 7 "connect.pgc"char * uname = "myuser" ; #line 8 "connect.pgc"char * password = "mypassword" ; /* exec sql end declare section */ #line 9 "connect.pgc" { ECPGconnect(__LINE__, 0, target , " ?" , " ?" , connection_name, 0); } #line 11 "connect.pgc" } -- >-=-=-=-=-=-=-<>-=-=-=-=-=-<>-=-=-=-=-=-<>-=-=-=-=-=-<>-=-=-=-=-=-=-< Ryan Mooney ryan@pcslink.com <-=-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-><-=-=-=-=-=-=->
В списке pgsql-interfaces по дате отправления: