R&R 12.5 opening a DB in VB6

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
GLShapesLLC_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

R&R 12.5 opening a DB in VB6

Post by GLShapesLLC_(Guest) » Wed Aug 05, 2009 9:41 am

"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.

GLShapesLLC_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: R&R 12.5 opening a DB in VB6

Post by GLShapesLLC_(Guest) » Wed Aug 05, 2009 11:11 am

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

Post Reply