473,729 Members | 2,243 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem in Accessing SQL Server Views from Oracle Using TG4MSQL(Transpa rent gateway Connectivity)

Dear All,
I am using the oracle transparent gateway connectivity with sql server
using tg4msql,as far as

settings are concerned those were set and Connectivity is working Fine,
and getting the response

from that server.
here is description what I done as:-There is a View on Sqlserver which
is Join of 6 tables and have

data around 1 million in 2 tables and 0.5 million in rest of the
tables, as the Query for creating

sqlserver view is given below:

CREATE view Account_anila_t est as
SELECT ......(around 50 Columns)
FROM GE_Init.dbo.Per son INNER JOIN
GE_Init.dbo.Kon to ON GE_Init.dbo.Per son.Person_ID =

GE_Init.dbo.Kon to.Person_ID INNER JOIN
GE_Init.dbo.Pro dukt ON GE_Init.dbo.Kon to.Produkt_ID =

GE_Init.dbo.Pro dukt.Produkt_ID LEFT OUTER JOIN
GE_Init.dbo.CRM Konto ON GE_Init.dbo.Kon to.Konto_ID =

GE_Init.dbo.CRM Konto.Konto_ID LEFT OUTER JOIN
GE_Init.dbo.cal cKontoOBSdt ON GE_Init.dbo.Kon to.Konto_ID =

GE_Init.dbo.cal cKontoOBSdt.Kon to_ID LEFT OUTER JOIN

GE_Init.dbo.cal cKonto ON GE_Init.dbo.Kon to.Konto_ID =

GE_Init.dbo.cal cKonto.Konto_ID
WHERE (GE_Init.dbo.Ko nto.SlettetKont o = 0) AND
(GE_Init.dbo.CR MKonto.MarkertF orSletting = 0
OR GE_Init.dbo.CRM Konto.MarkertFo rSletting IS NULL)

Now,I made a table in oracle adjacent to sqlserver View and Inserted
data as:

INSERT INTO ACCOUNT_TEST11( .....)
SELECT .............
FROM Person@dbl_getg c1 a INNER JOIN
Konto@dbl_getgc 1 b ON a."Person_ID" = b."Person_ID" INNER JOIN
Produkt@dbl_get gc1 c ON b."Produkt_ID " = c."Produkt_ID " LEFT OUTER JOIN

CRMKonto@dbl_ge tgc1 d ON b."Konto_ID" = d."Konto_ID" LEFT OUTER JOIN
calcKontoOBSdt@ dbl_getgc1 e ON b."Konto_ID" = e."Konto_ID" LEFT OUTER
JOIN

calcKonto@dbl_g etgc1 f ON b."Konto_ID" = f."Konto_ID"
WHERE (b."SlettetKont o" = 0) AND (d."MarkertForS letting" = 0 OR
d."MarkertForSl etting" IS NULL);

This insert Satement worked fine,but when I inserted from the view
already created in SQLSERVER as

:-

INSERT INTO ACCOUNT_TEST11( .....)
SELECT .............
FROM Account_anila_t est@dbl_getgc1;

This gave a following error:-

"WEB_30_SUM ", "WEB_360_COUNT" , "WEB_360_SU M", "WEB_90_COU NT",
"WEB_90_SUM "
*
ERROR at line 48:
ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Transparent gateway for MSSQL]
ORA-02063: preceding 2 lines from DBL_GETGC1
Elapsed: 00:01:01.04

after this I set The paramater "HS_FDS_TRACE_L EVEL=ON" in INIt file of
tg4msql Folder then in the

trace File of tg4msql folder following error comes:-

(0)
(0) [Microsoft][ODBC SQL Server Driver]Timeout expired (SQL State:
S1T00; SQL
(0) Code: 0)
(0)

If any one has Faced the similar kind of problem and Can help me,Please
let me Know where I am

doing Wrong and How this error can be ractified.

Waiting For Reply ASAP.

Regards
Lovkesh

Dec 13 '05 #1
1 6270
(lo**********@g mail.com) writes:
Now,I made a table in oracle adjacent to sqlserver View and Inserted
data as:
...

This insert Satement worked fine,but when I inserted from the view
already created in SQLSERVER as
Do I understand it correctly that the query for the first INSERT
was a simplified version of the view? The real view appears to use
more tables.
trace File of tg4msql folder following error comes:-

(0)
(0) [Microsoft][ODBC SQL Server Driver]Timeout expired (SQL State:
S1T00; SQL
(0) Code: 0)
(0)


The ODBC SQL Server Driver has a default timeout of 30 seconds, as have
several other client APIs. (Don't ask me why; I think it's stupid.) I
have no idea whether you can control it from Oracle.

If you run a SELECT * from the view, on SQL Server how long time does
it take? You may have to look into tuning the query.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
4131
by: New Devil | last post by:
can anyone send a code for the oracle connectivity wid C#.. would be really tahnkful .. Desert Desperado 8) Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com
1
1877
by: Chris Tremblay | last post by:
I am trying to create an image using GDI+ in VB.NET. I want to have the background be transparent, but when I do run the following: myGraphicsObject.clear(color.transparent) the resulting background color is black, not transparent. I am saving the image to the output stream as an "image/gif". Is there anything I should know about this, any reason that the result would be black? --
2
1588
by: Will | last post by:
We have several large Oracle databases that we are writing new front ends for in .Net. The applications will be Windows clients. We are looking for the best method for connecting with the Oracle database. The Microsoft data provider requires the Oracle client to be installed, a huge footprint at 250 meg. ODAC (from Oracle) is another 250 meg install. We aren't opposed to using ODBC (which requires Oracle Client as well) for whatever...
1
3660
by: kiran261 | last post by:
visual basic and oracle connectivity i want to know how can i access records from oracle in visual basic what is the diffrence between connect & connection
1
1705
by: swatishende | last post by:
How is the connectivity of VB with Oracle 8i can be done on windows 98 platform?.
2
2375
by: David Costello | last post by:
Hi all, I keep getting a bizarre login error, when trying to connect to a SQL Server 2005 database on a local domain to my machine using C#. The Exception returns: SQLException: Login failed for user 'OURDOMAIN\PC-DAVIDC$'. Where "OURDOMAIN" is the domain my computer is connected to, and "PC-DAVIDC" is the computer name. What's weird about this though, is this isn't in the connection string. Nor is it a valid NT account on the Active...
1
1252
by: bdpandit | last post by:
Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.
0
1710
by: karpalmera | last post by:
We are currently migrating from OS/390 to Z/OS and our DB2 from DB2 4 to DB2 UDB8. However, our Oracle Database and Oracle gateway will remain the same..Oracle database is 7.2.3 and Oracle gateway is 7.3 We have a hard time starting our Oracle gateway in Z/OS. Has anyone experienced this kind of migration? Is it possible for Oracle 7 to run in Z/OS? If so, can you please explain what parameters we need to change in order for our old Oracle...
0
1659
by: balagh | last post by:
To access the table in oracle from MySQL. is there any connectivity code r steps to be followed
0
8913
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9280
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9200
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9142
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8144
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6016
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4525
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3238
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2162
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.