Queries on Win32 DBPipe support

Discussion forum about all things SqlBase.
a_sivababu
India
Posts: 501
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Queries on Win32 DBPipe support

Post by a_sivababu » 12 Apr 2015, 04:17

Hi All,
Just would like to know whether DBPipe supports for win32. The reason is that, I have seen this features in DevCon 2014 material but in Gupta site for 6.3 new changes, it does not carry this features along with others.

Thanks!

Siva A

Ana Paula Bonani

Re: Queries on Win32 DBPipe support

Post by Ana Paula Bonani » 15 Apr 2015, 11:58

Hi Siva,

Yes, please look for "SqlDbPipe" functions in the TD API Reference Guide.pdf in your 6.3 installation \Books folder.

There's a little note saying that DBPipe/win32 is implemented only for Oracle and SQLServer.

Regards,

a_sivababu
India
Posts: 501
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Re: Queries on Win32 DBPipe support

Post by a_sivababu » 11 May 2015, 10:42

Hi Ana,
Thanks. I am not yet getting much information for win32 DBPipe implementation. And also, the important function SqlConnectDbPipe() is missing in the above API reference.

There was DBPipe book in TD 6.2 and this is now missed in TD 6.3 books. Can this be updated and released for win32 as well?.

And also, I could see the Oct 2014 news letter for delivering better documentation. is that something planned in TD 7.0?
http://www.guptatechnologies.com/News-E ... -2014.html

I always feel that we need to refer TD books, devcon material, Gupta academy training and this onsite forum to understand the available syntax to implement any functionalities.

Thanks!
Siva A

a_sivababu
India
Posts: 501
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Re: Queries on Win32 DBPipe support

Post by a_sivababu » 13 May 2015, 04:47

I Just started to test the connectivity of Oracle/SQL Server with .NET connection string using SqlConnectDBPipe(). However, It gives error like TNS connection identifier problem in Oracle (but my oracle works fine with native tools as well TD connection) and Driver/Provider error (but this .NET connection string works fine in TDMobile) for SQL Server.

DEVCON for Oracle connection sample is also giving same problem.

Can you please share the sample and required .NET OLEDB components in the Client ?

Appreciate your help!

I feel we could proceed to check any new functionalities only if there is proper documentation with sample. I see this voice from other customers too. There are 4 API function for DBPipe win32 connection but Only 2 is available in API reference online books.

Ana Paula Bonani

Re: Queries on Win32 DBPipe support

Post by Ana Paula Bonani » 13 May 2015, 15:39

Hi Siva,

You said: "There was DBPipe book in TD 6.2 and this is now missed in TD 6.3 books. Can this be updated and released for win32 as well?".

Yes, I've already reported that and it will be included back in a future release of 6.3.

I've asked Jean-Marc to work with you on this thread. You should hear back from him soon.

Apologies for the lack of documentation. We're working to resolve it.

Regards,

Jean-Marc Gemperle

Re: Queries on Win32 DBPipe support

Post by Jean-Marc Gemperle » 13 May 2015, 15:53

Hi,

Because now TD .NET ( hence DBPIPEWin32) uses the Oracle.ManagedDataAccess.dll to connect ORACLE instead of Oracle.DataAccess.dll. the Oracle.ManagedDataAccess.dll is the full .NET version and does not requires OCI libraries.
You can install it by using ODP.NET 32 or 64 bit installer.
In this case it uses different location for tnsnames.ora from standard ORACLE client.
That's why TNS name setting does not work.

So since I myself have the older client I connect this way to ORACLE via DBPIPE

Call SqlConnectDbPipe(hSql , "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN2012R2VM)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orclwin1252)));User Id=support;Password=support;", 0)

For SLQSERVER this be
Call SqlConnectDbPipe(hSql , "Data Source=WIN2012R2VM;Initial Catalog=support;User ID=support;Password=support", 1)

NOTE the last parameter 0 Oracle 1 SQLServer the only 2 brand we support

For your test I recommend you to use at first DBPIPE Desktop server ( the UI one ) as it is simplier to put in place and more talkative ( log )

The bellow is the TYPICAL <YOUR_APP>.EXE.config to connect to DBPIPE desktop
You would need to change the UNCOMMENTED endpoint address to match yours
Also NOTE
<add key="UseRemoteConnections" value="true"/>
that IMPLIES you WANT TO USE DBPIPE connection

HTH

JM

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<system.serviceModel>
<bindings>
<ws2007HttpBinding>
<binding name="UnifyHttpService" closeTimeout="00:00:30"
openTimeout="00:00:30" receiveTimeout="00:00:30" sendTimeout="00:00:30"
bypassProxyOnLocal="false" transactionFlow="false" hostNameComparisonMode="StrongWildcard"
maxBufferPoolSize="524288" maxReceivedMessageSize="1048576"
messageEncoding="Text" textEncoding="utf-8" useDefaultWebProxy="true"
allowCookies="false">
<readerQuotas maxDepth="32" maxStringContentLength="65536" maxArrayLength="1048576"
maxBytesPerRead="4096" maxNameTableCharCount="16384" />
<reliableSession enabled="false" />
<security mode="Message" />
</binding>
</ws2007HttpBinding>
<netTcpBinding>
<binding name="UnifyNetTcpService" closeTimeout="00:10:30"
openTimeout="00:10:30" receiveTimeout="00:10:30" sendTimeout="00:10:30"
transactionFlow="false" hostNameComparisonMode="StrongWildcard"
maxBufferPoolSize="524288" maxReceivedMessageSize="65536" >
<readerQuotas maxDepth="32" maxStringContentLength="65536" maxArrayLength="1048576"
maxBytesPerRead="4096" maxNameTableCharCount="16384" />
<reliableSession enabled="true" />
<security mode="None" />
</binding>
</netTcpBinding>
</bindings>
<client>
<!-- You can use following endpoint to connect DBPipeServer/IIS supporting ws2007HttpBinding -->
<!--
<endpoint address="http://localhost/DBPipeServer/DBPipeServer.svc"
binding="ws2007HttpBinding" bindingConfiguration="UnifyHttpService"
contract="DBPipe.IDBPipeServer" name="UnifyHttpService"/>
-->
<!-- You can use following endpoint to connect DBPipeServer/Desktop and
DBPipeServer/IIS configured to use NetTcpBinding -->
<endpoint address="net.tcp://WIN2012R2VM:8000/Gupta/DBPipeServer"
binding="netTcpBinding" bindingConfiguration="UnifyNetTcpService"
contract="DBPipe.IDBPipeServer" name="UnifyNetTcpService" />
</client>
</system.serviceModel>
<appSettings>
<!--
You can specify one of following 3 values for UseRemoteConnection.
true - force to use remote connection
false - use only local connection
auto - use remote connection if local connection is not available
-->
<add key="UseRemoteConnections" value="true"/>
</appSettings>
<!--
Use / edit the section below to enable client side WCF (DBPipe) logging
To read the resulting ClientServiceModelTrace.svclog, use Microsoft's log viewer,
svctraceviewer.exe, available as part of the Windows SDK.
See http://msdn.microsoft.com/en-us/library/ms732023.aspx for more information on this tool.
-->
<!--
<system.diagnostics>
<trace autoflush="true" />
<sources>
<source name="System.ServiceModel.MessageLogging" switchValue="Warning, ActivityTracing">
<listeners>
<add name="clientServiceModelListener" />
</listeners>
</source>
<source name="System.ServiceModel" switchValue="Warning, ActivityTracing" propagateActivity="true">
<listeners>
<add name="clientServiceModelListener" />
</listeners>
</source>
</sources>
<sharedListeners>
<add initializeData="ClientServiceModelTrace.svclog"
type="System.Diagnostics.XmlWriterTraceListener, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
name="clientServiceModelListener" traceOutputOptions="Timestamp">
</add>
</sharedListeners>
</system.diagnostics>
-->
</configuration>

a_sivababu
India
Posts: 501
Joined: 10 Mar 2017, 08:46
Location: Chennai,India

Re: Queries on Win32 DBPipe support

Post by a_sivababu » 15 May 2015, 11:45

Thanks a lot Ana for supporting this issue as JM inputs resolves my problem.

@JM, Thanks for sharing the information on ODP.NET and I understand that there is a change in the SQL Server connection strings too which I note it down. This resolves my problem as everything else was mentioned in the DEVCon.

This is now tested and works like charm. Let me start doing the testing with my application and check all connection are working fine. I just observed that the SalTblPopulate with "Select * from tbl" (without giving columns) is not working.

Thanks a lot once again!.

Siva A

Ana Paula Bonani

Re: Queries on Win32 DBPipe support

Post by Ana Paula Bonani » 15 May 2015, 14:28

Appreciate the feedback, Siva.

Thanks,

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests