You can translate the question and the replies:

DENODO connection to .NET(Entity Framework/ADO .NET)

Hi, I'm currently trying to access Denodo VDP server from .NET. Currently I'm using the samples we have on the installation folder. Sadly I couldn't make it run since there's an error occuring. **Here's the app.config on my .NET project:** > <?xml version="1.0" encoding="utf-8"?> > <configuration> > <configSections> > <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> > <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> > <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --></configSections> > <entityFramework> > <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" /> > <providers> > <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /> > <provider invariantName="Npgsql" type="Npgsql.NpgsqlServices, Npgsql.EntityFramework" /> > </providers> > </entityFramework> > <system.data> > <DbProviderFactories> > <remove invariant="Npgsql" /> > <add name="Npgsql Data Provider" invariant="Npgsql" support="FF" description=".Net Framework Data Provider for Postgresql" type="Npgsql.NpgsqlFactory, Npgsql" /> > </DbProviderFactories> > </system.data> > <connectionStrings> > <add name="SampleContext" connectionString="Server=localhost;Port=9999;Database=non_secret;User Id=admin;Password=admin;" providerName="Npgsql" /> > </connectionStrings> > <startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8" /></startup></configuration> > ** Here's the vdp.log error I encounter everytime the I run the .NET project and an error occur.** > 7515261 [DNI(1787)] ERROR 2021-11-24T17:36:24.450 com.denodo.internal.o.a.r.netty.RMIServerHandler [] - EXCEPTION CAUGHT: Invalid protocol handshake request, prefix is not match > java.io.IOException: Invalid protocol handshake request, prefix is not match > at com.denodo.internal.o.a.r.messages.HandshakeManager.verifyRequest(HandshakeManager.java:91) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.o.a.r.netty.ServerHandshakeHandler.channelRead(ServerHandshakeHandler.java:57) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:324) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:311) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.handler.codec.ByteToMessageDecoder.decodeRemovalReentryProtection(ByteToMessageDecoder.java:506) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.handler.codec.ByteToMessageDecoder.callDecode(ByteToMessageDecoder.java:440) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:276) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:357) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:379) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:365) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:719) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:655) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:581) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.channel.nio.NioEventLoop.run(NioEventLoop.java:493) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) ~[denodo-asyncrmi.jar:8.0.1] > at com.denodo.internal.i.n.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) [denodo-asyncrmi.jar:8.0.1] > at java.lang.Thread.run(Thread.java:834) [?:?]
user
24-11-2021 04:47:49 -0500

1 Answer

Fix it using "ODBC" port. But another weird configuration needed for this to work is to add a "template1" database in Denodo.
user
25-11-2021 21:10:10 -0500
You must sign in to add an answer. If you do not have an account, you can register here