Not a member of a trusted SQL connection

Posted on 2004-10-28
Last Modified: 2012-05-05
Have read that unless the UserID and Password is specified in the DSN open command then NT4 will use Windows authentication. I have found this to be true, semmingly intermittently, and need to force SQL authentication (even though it IS set to do so within the DSN!). Therefore trying to add these properties to CrystalReports (using the RDC) with the LogOnServer command:

crxReport.Database.LogOnServer("SQLOLEDB", etc..)...however, errors saying: "the database DLL crdb_oledb.dll cannot be loaded".

Interestingly I've noticed that prior to this error the tables(1).connectionproperties.item("User ID") field is not available (subscript out of range) but "Password" and others are. Closing the form and trying again often resolves the problem for a while. Could this be a memory leak of some kind ?
Question by:CliffordEvans

    Author Comment

    I resolved this by connecting using ADO OLEDB instead of ODBC RDO.

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    911 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now