Database connection

[beti]

I have created a new database through Database profile. I can also retrieve data when I preview my report. However, when I actually run the application, it gave me an error saying "Transaction not connected".

I can not find what was the problem.
I have copy the Database connection sytnax onto the application open script
ie.
// Profile testing db
SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "xxx"
SQLCA.ServerName = "hkgxxxyr01"
SQLCA.LogId = "xxx"
SQLCA.AutoCommit = False
SQLCA.DBParm = ""
Open(w_window01)

I also declared dw_1.settransObject(sqlca)
dw_1.retrieve()
on the window where I will be called.

Please if anyone can solve my problem!
Thanks

 

[rt63]

I do not see any connect statement. Normally , it should come after sqlca definition

SQLCA.DBMS = ......
....
SQLCA.DBParm = .....


Connect using SQLCA;


open(w_window1)

using SQLCA is optional. You can give only connect also.

RT

 

[beti]

ah...yes...I'm missing a "Connect using SQLCA" Statement

Thanks RT!