Results 1 to 5 of 5

Thread: Crystal Report sql conn in VB.net

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2020
    Posts
    8

    Post Crystal Report sql conn in VB.net

    report is asking for sql db password everytime it opens. Anyone who can sort this out.
    Last edited by arvinddx; Oct 21st, 2020 at 10:03 AM.

  2. #2
    Wall Poster TysonLPrice's Avatar
    Join Date
    Sep 2002
    Location
    Columbus, Ohio
    Posts
    3,503

    Re: Crystal Report sql conn in VB.net

    Try switching the connection to "Windows Authentication".
    Please remember next time...elections matter!

  3. #3

    Thread Starter
    New Member
    Join Date
    Oct 2020
    Posts
    8

    Re: Crystal Report sql conn in VB.net

    It is a good option but I dont want that.

  4. #4
    Wall Poster TysonLPrice's Avatar
    Join Date
    Sep 2002
    Location
    Columbus, Ohio
    Posts
    3,503

    Re: Crystal Report sql conn in VB.net

    Maybe you could use ODBC?
    Please remember next time...elections matter!

  5. #5
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    33,067

    Re: Crystal Report sql conn in VB.net

    The real answer is that you should be setting the authentication, including the user and password on the report and all subreports ...

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

Tags for this 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
  •  



Click Here to Expand Forum to Full Width