Results 1 to 5 of 5

Thread: Deployment help

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    6

    Deployment help

    I am deploying an application using VB6 with Crystal Reports 8.5.

    I am using using Visual Studio Installer for packaging. This application automatically includes the needed basic dll's for CR8.5 (craxdrt.dll, etc.) and manually added the other dll's needed (p2ssql.dll, etc.).

    I don't encounter any errors in the building of my msi file but when I install it in a desktop without CR8.5, "pdssql.dll not found" message box appears.

    I have consulted/researched from other messageboards and learned that I need to include Implode.dll and others. Also, I read the help file included in CR8.5 and added all the needed files but still, it doesn't work.

    I learned that CR8.5 has a utility that will list all the dll's needed by an application but can't use it coz I am using Win2k.

    I have downloaded a lot of applications like ProcessExplorer in order for me to know what are the dll's needed but I find it incomplete.

    I have asked my boss about it and still he referred me to the help file included in CR8.5.

    I AM VERY DESPERATE!!! HELP!

    Thanks a lot!

    - Bench Brat

    -------------------------------------------
    God's in His heaven, All's right in the world.

    Your heart is like glass, very fragile...

    Someday we'll share this cigarette
    You and me like we used to
    Outside the dark parking lot
    Where you told me that life happens once you close your eyes

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Deployment help

    I read the help file included in CR8.5.
    Which help file? There is one called RunTime.hlp which explains everything.

    Which database are you accessing? Which method are you using? If SQL Server via native driver, there is a file called NTWDBLIB.DLL that needs to be included as well.

  3. #3

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    6

    Re: Deployment help

    Quote Originally Posted by brucevde
    Which help file? There is one called RunTime.hlp which explains everything.

    Which database are you accessing? Which method are you using? If SQL Server via native driver, there is a file called NTWDBLIB.DLL that needs to be included as well.
    Yeah, that one.

    And I'm using MSSQL 2000 as my backend.
    God's in His heaven, All's right in the world.

    Your heart is like glass, very fragile...

    Someday we'll share this cigarette
    You and me like we used to
    Outside the dark parking lot
    Where you told me life happens once you close your eyes

  4. #4

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    6

    Re: Deployment help

    i have included all the files listed in the help file.

    the application shows a messagebox with this error

    run-time error '-2147192153 (800472a7)':

    Configuration error.

    file could not be opened because the library "pdssql.dll" cannot be found.

    i have included implode.dll and p2ssql.dll

    i am using crystal reports 8.5
    God's in His heaven, All's right in the world.

    Your heart is like glass, very fragile...

    Someday we'll share this cigarette
    You and me like we used to
    Outside the dark parking lot
    Where you told me life happens once you close your eyes

  5. #5

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    6

    Re: Deployment help

    here's the snippet:

    Dim repapp As New CRAXDDRT.Application
    Dim crCrd As New CRAXDDRT.Report

    Set crCrd = repapp.OpenReport(App.Path & "\Report.rpt")
    crCrd.Database.LogOnServer "p2ssql.dll", Trim(DB_Source), Trim(DB_Name), Trim(User_Name), Trim(Pass_Word)

    where:

    DB_Source = database location (either an ip address or host/server name)
    DB_Name = database name
    God's in His heaven, All's right in the world.

    Your heart is like glass, very fragile...

    Someday we'll share this cigarette
    You and me like we used to
    Outside the dark parking lot
    Where you told me life happens once you close your eyes

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