Hi

I am newbie to QTP , trying to do database connectivity with informix server.

When I add DB checkpoint by specifying connection String , SQL stmt manually it works fine.

Connection String created through wizard is
strConn= "
DRIVER={IBM INFORMIX ODBC DRIVER};UID=user;PWD=password;DATABASE=testdb;HOST =h420b;SRVR=qa1;SERV=socqa1;PRO=onsoctcp;CLOC=en_U S.CP1252;DLOC=en_US.819;
"

When I used the same connection string in the script, I get empty connection object
here is code snippet.

set conn = CreateObject ("ADODB.connection")
conn.open strConn
set rs=conn.Execute( "select * from test)
msgbox rs(1).value
conn.close


Am I missing anything?

Thanks,