Page 1 of 1
R&R 12.5 opening a DB in VB6
Posted: Wed Aug 05, 2009 9:41 am
by GLShapesLLC_(Guest)
"Always asks me for Oracle Logon PWD."__Can anyone give me a snippet of code that will allow me to open an R&R with a database connection. I can get to the point of where it^s about to open but then I^m prompt for a password. When I do enter the password everything is ok but most users always forget their passwords. ____I thought it would be something close to report1.password = "whatever" like in 6.5 but it^s not working.__BTW all other connections in the code work (to open the db in oracle.)__Any help would be great.____Thank you.
=> RE: R&R 12.5 opening a DB in VB6
Posted: Wed Aug 05, 2009 11:11 am
by GLShapesLLC_(Guest)
Nevermind I got it.__I had it in the wrong spot.____^Report1.UserName = "xtrusion" ^"qc"__^Report1.Password = "xtrusion" ^"control"__Report1.Printer = "?" ^"QCMATRIX" ^"MIS LJ"__Report1.Include = 2 ^2 - override__Report1.Filter = "qa_printed = ^P^"__Report1.Destination = 2 ^2 - printer__Report1.ReportName = "Printqc"__Report1.ReportLibrary = "C:QCprojqc_print.rp6"__^MsgBox report1.ReportLibrary & ", " & report1.ReportName__Report1.DataSource = sservername & "-RR"__Report1.UserName = "xtrusion"__Report1.Password = "xtrusion"__Report1.Action = 1