Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: How can I connect from vb6 to a CR9 report having two ODBC connections?

    I try to open a report from vb6 (this report has two ODBC connections ). An error appears in the second connection.
    This is my code, but I don't know how to connect the second ODBC.

    Set crApplication = CreateObject("CrystalRuntime.Application")
    Set crReport = crApplication.OpenReport("report.rpt")
    crReport.Database.LogOnServer "p2sodbc.dll", "x1", "x1", "user", "pass"

    Thank you.

  2. #2
    Join Date
    Sep 2003
    Posts
    1

    Unhappy Vb 6 and crystal report using p2sora7.dll

    Hope someone can help me.

    I have a working vb 6.0 with crystal report that reports based on data on a oracle 8.0.5. What i have to do is to make it work from nt4 to w2k.

    When i ran the report i get an error message telling me that i cannot logon to server with an error :'20536'.

    This is the code:

    Private rptCrystal As Object

    Set rptCrystal = CreateObject("Crystal.CrystalReport")

    rptCrystal.Connect = "DSN=" & Trim$(strConnect) & ";UID=userid;PWD=password;DSQ="

    nConnection = rptCrystal.LogOnServer("p2sora7.dll", strConnect, "", "userid", "password") 'here line generates the error

    i would really appreciate any help!

    Antonio.

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Respuesta a Consulta

    Hola

    El problema es Simple, la Conexión via ODBC no esta registrada.-

    Cuando utilizas Crystal report con Conexion ODBC a oracle utilizando CROR8 , este debe ser agregado en el Registro del Sistema.

    Crear Archivo .ini y hacer doble click en ese archivo con el contenido que elija, debe aceptar para que las lineas se inserten en el registro.

    Solucion Win95/98
    ------------------------------------------------------------------------
    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\CROR8]
    "Driver"="C:\\WINDOWS\\System\\Cror814.dll"
    "ArraySize"="60000"
    "CatalogOptions"="0"
    "Description"=""
    "LockTimeOut"=""
    "LogonID"=""
    "ProcedureRetResults"="1"
    "ServerName"=""
    "EnableStaticCursorsForLongData"="0"
    "ApplicationUsingThreads"="1"
    "EnableDescribeParam"="0"
    "Servers"=""
    -------------------------------------------------------------------------------

    Solucion Win2K
    -------------------------------------------------------------------------------
    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\CROR8]
    "Driver"="C:\\WINNT\\System32\\Cror814.dll"
    "ArraySize"="60000"
    "CatalogOptions"="0"
    "Description"=""
    "LockTimeOut"=""
    "LogonID"=""
    "ProcedureRetResults"="1"
    "ServerName"=""
    "EnableStaticCursorsForLongData"="0"
    "ApplicationUsingThreads"="1"
    "EnableDescribeParam"="0"
    "Servers"=""
    -------------------------------------------------------------------------------

    Atentamente
    Rodrigo Alvarado
    ralvarad@adsl.tie.cl
    Talca-Chile

Posting Permissions

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