Home / user-31377

Xavier Crespo's questions

Martin Hope
Xavier Crespo
Asked: 2020-06-29 23:25:05 +0800 CST
  • 0

In a web application I use 2 connections to 2 different Oracle 10g servers, I use Visual Studio 2015 Professional, and I have installed the Oracle ODAC 12 libraries on the development computer, I have said library referenced in the application Oracle.DataAccess.dll.

The thing is that the connection to one of the servers works correctly and when it has to open the connection to another, it will report the error:

 ORA-03134: Connections to this server version are no longer supported

Can you give me any clue as to where the problem is? Apparently both ORACLE servers have the same configuration.

asp.net
Martin Hope
Xavier Crespo
Asked: 2020-03-11 04:09:39 +0800 CST
  • 0

I omit to count the number of hours I have invested to solve this problem but here it goes: I have a report in crystal report and I need to connect it to the PostgreSQL 9.3 database but without ODBC, through a connectionstring or whatever, the case is that in the application I use the NPGSQL v3.2.1 connector to work with the database but I don't know how to make the CR report connect to the database. the IDE I use is VS2015 PROF and OS Windows7 prof 64bits. Can you give me a hand? Thank you.

postgresql
Martin Hope
Xavier Crespo
Asked: 2020-03-02 00:54:39 +0800 CST
  • 2

Crystal ReportI'm trying to install the en module Visual Studio 2015and I can't see the report editor.

I explain:

I have downloaded from the SAP website the support pack18 64bits, my SO WIN 7 professional 64bits.

The thing is that once installed I am not able to understand what references I have to add in order to have the report designer in my visual studio 2015 environment.

visual-studio-2015
Martin Hope
Xavier Crespo
Asked: 2020-02-29 00:23:34 +0800 CST
  • 1

I have migrated from PostgreSQL 8.3 to PostgreSQL 9.3 in order to use the improvements implemented in this version. With version 8.2 I had no problem handling errors when trying to insert a duplicate record with unique key since the program (Visual Studio 2013 vb.net) received a message from PostgreSQL and acted accordingly with a TRY...CATCH. But since I have migrated to 9.3, when doing a insert, the program waits to receive a message from PostgreSQL 9.3 and does not continue. I attached example code:

Public Sub EjecutaComando(ByVal StringSql As String)
    'Procedure básico para ejecutar Insert i Updates sin tenerlas que implementar en cada uno de los procesos
    Dim data As New NpgsqlCommand
    data.Connection = MiConexio
    data.CommandText = StringSql
    Try
        AbrirConexion()
        data.ExecuteNonQuery()
    Catch ex As Exception
        nada()
    Finally
        CerrarConexion()
        data.Dispose()
    End Try
End Sub

If the statement is insertagainst a table with a unique key, the code stops at data.ExecuteNonQuery(). I run the query from PgAdmin and it returns an error message of duplicate Key. The Npgsql version I use is 2.012.0.

Can someone enlighten me where the problem is?

vb.net