Results 1 to 4 of 4

Thread: [RESOLVED] [2005] How to Avoid Access Database password at runtime ?

  1. Dec 10th, 2006, 11:17 AM #1
    Coool
    Coool is offline

    Thread Starter
    Hyperactive Member Coool's Avatar
    Join Date
    Feb 2006
    Location
    System.Coool
    Posts
    333

    Resolved [RESOLVED] [2005] How to Avoid Access Database password at runtime ?

    Hi guys,

    I have created report and making report dynamically using SelectionFormula.

    However, I have to give password at runtime all the time.

    Can anyone tell me, How to cope up with ?
    I am using .NET 2010 with Windows 7
    Reply With Quote Reply With Quote
  2. Dec 10th, 2006, 04:35 PM #2
    bmahler
    bmahler is offline
    Frenzied Member bmahler's Avatar
    Join Date
    Oct 2005
    Location
    Somewhere just west of the Atlantic
    Posts
    1,568

    Re: [2005] How to Avoid Access Database password at runtime ?

    what type of report is it? Crystal Reports? Access Report? without knowing this it is hard to give you an answer other than you would need to pass the login information to your report from your application.
    Boooya
    • Visual Studio 2008 Professional
    • Don't forget to use [CODE]your code here[/CODE] when posting code
    • Don't forget to rate helpful posts!
    • If you're question was answered please mark your thread [Resolved]


    Code Contributions:
    PHP
    PHP Image Gallery v1.0 • PHP Image Gallery v2.0
    VB 2005
    Find Computers on a network • Simple License Encryption • SQL Server Database Access dll • Use Reflection to Return Crystal ReportDocument • Silently Print PDF • Generic Xml Serailizer

    Useful Links: (more to come)
    MSDN (The first and foremost) • MSDN Design Guidelines • API Reference • Inno Setup Compiler • Inno Setup Preprocessor • ISTool - Fairly easy to use GUI for creating inno setup projects • Connection Strings • NAnt -Automated Builds • Cruise Control .NET - Frontend for automated builds
    Reply With Quote Reply With Quote
  3. Dec 10th, 2006, 04:38 PM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: [2005] How to Avoid Access Database password at runtime ?

    Sounds like a Crystal Report. There is the login credentials when you connect via an ado connection. plus there are .SetLogOnInfo methods for authentication too.
    VB Code:
    1. Report.Database.Tables(1).SetLogOnInfo sServer, sDatabase, sUserName, sUserPwd
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  4. Dec 10th, 2006, 09:56 PM #4
    Coool
    Coool is offline

    Thread Starter
    Hyperactive Member Coool's Avatar
    Join Date
    Feb 2006
    Location
    System.Coool
    Posts
    333

    Re: [2005] How to Avoid Access Database password at runtime ?

    thank you very much. I have also find another way to do so
    CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.Password = "xyz"
    I am using .NET 2010 with Windows 7
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width