Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ActiveX DW Component - how do you connect to Oracle DB

6 posts in General Discussion (old) Last posting was on 2000-03-08 21:28:03.0Z
Garnet Fehr Posted on 2000-03-08 00:00:42.0Z
Newsgroups: sybase.public.easerver
From: "Garnet Fehr" <gfehr@flexicoil.com>
Subject: ActiveX DW Component - how do you connect to Oracle DB
Date: Tue, 7 Mar 2000 18:00:42 -0600
Lines: 50
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 204.83.221.2
Message-ID: <347_HKao7GJi$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26924
Article PK: 154463

To whomever can help me

I have been attempting to get the ActiveX DW component working for some time
now. I have been able to figure out the DTC's and the HTML DataWindow but
the ActiveX component has me in the dark.

As a general starting point my first question would be, what is required in
getting an ActiveX DW component connected to an Oracle database and up and
running on a Web page.

1. Does the ActiveX DW component use Jaguar CTS to communicate to the DB?

2. Is the DSEDIT program a key player in setting up the DB connection?

a. I found that DSEDIT wouldn't execute until I customly built a
directory and file structure "c:\sql10", all subsequent files and
directories are a copy of the shared folder in the Sybase directory. What
is the reason for this?

b. When I run the DSEDIT program I am given one directory service to
choose from, "Interfaces Driver", immediately after I select it, DSEDIT
locks up??

c. Is PB INTERSOLV OEM 3.11 32-BIT Sybase driver an equivalent to
Sybase System 11?

d. Can Sybase System 11 be used to connect to an Oracle DB?

e. Is the Sybase System 11 driver needed for an ActiveX DW component to
connect to an Oracle DB?

3. Whenever I run the ISQL to test the SQL.INI file the machine locks up,
is there a logical reason for this?

a. What other resources or programs reference the SQL.INI file?

b. Where is the SQL.INI file actually supposed to exist? One does
exist in "Sybase\Shared\Open Client\INI" however documentation specifies to
create a INI directory under the Sybase directory and place it in there, and
again ISQL does not execute without the existance of "c:\sql10" and its
subdirectories, should it be placed in there?

I have many more questions but hopefully this will get the ball rolling. It
could just be that I am not doing something really simple, but being new to
this I am grasping at straws and would appreciate any help offered.


thanks


Jim O'Neil [Sybase] Posted on 2000-03-08 13:05:57.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 08 Mar 2000 08:05:57 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: ActiveX DW Component - how do you connect to Oracle DB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 82
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38C65035.7DD08C30@sybase.com>
References: <347_HKao7GJi$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26903
Article PK: 157862

See my responses below.

--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc

Garnet Fehr wrote:

> To whomever can help me
>
> I have been attempting to get the ActiveX DW component working for some time
> now. I have been able to figure out the DTC's and the HTML DataWindow but
> the ActiveX component has me in the dark.
>
> As a general starting point my first question would be, what is required in
> getting an ActiveX DW component connected to an Oracle database and up and
> running on a Web page.

The ActiveX DW connects via JDBC, which renders most of your other questions
moot....

>
>
> 1. Does the ActiveX DW component use Jaguar CTS to communicate to the DB?

No.

2. Is the DSEDIT program a key player in setting up the DB connection?

No.

a. I found that DSEDIT wouldn't execute until I customly built a
directory and file structure "c:\sql10", all subsequent files and

> directories are a copy of the shared folder in the Sybase directory. What
> is the reason for this?

Not certain. Do you have Sybase environment variable set that points to the
Shared/Open Client folder?

>
>
> b. When I run the DSEDIT program I am given one directory service to
> choose from, "Interfaces Driver", immediately after I select it, DSEDIT
> locks up??
>

Check you SQL.INI fie in the Shared/Open Client/ini directory and make sure it
has a carriage return after the last line. Without it, it can cause CPU usage
to get to 100% and appear to lock up you machine. Given what you did (or had to
do in step a), I would tend to question the integrity of your Open Client
installation.

>
> c. Is PB INTERSOLV OEM 3.11 32-BIT Sybase driver an equivalent to
> Sybase System 11?

Yes.

>
>
> d. Can Sybase System 11 be used to connect to an Oracle DB?

Well, sort of, but that would be jumping through major hoops. You can use CIS
functionality in Sybase ASE to make heterogeneous database joins. If Oracle is
all you need to get to though, forget Sybase drivers, SQL.INI, etc.

>
>
> e. Is the Sybase System 11 driver needed for an ActiveX DW component to
> connect to an Oracle DB?

No.

>
>
> 3. Whenever I run the ISQL to test the SQL.INI file the machine locks up,
> is there a logical reason for this?
>

See 2b.

>
> a. What other resources or programs reference the SQL.INI file?

Ct-library client programs would access the SQL.INI file, but only via the Open
Client layer

>
>
> b. Where is the SQL.INI file actually supposed to exist? One does
> exist in "Sybase\Shared\Open Client\INI" however documentation specifies to
> create a INI directory under the Sybase directory and place it in there, and
> again ISQL does not execute without the existance of "c:\sql10" and its
> subdirectories, should it be placed in there?

In the directory %SYBASE%/ini where SYBASE is an environment variable defined on
your machine under Control Panel->System

>
>
> I have many more questions but hopefully this will get the ball rolling. It
> could just be that I am not doing something really simple, but being new to
> this I am grasping at straws and would appreciate any help offered.
>
> thanks


Garnet Fehr Posted on 2000-03-08 15:25:38.0Z
Newsgroups: sybase.public.easerver
From: "Garnet Fehr" <gfehr@flexicoil.com>
Subject: Re: ActiveX DW Component - how do you connect to Oracle DB
Date: Wed, 8 Mar 2000 09:25:38 -0600
Lines: 27
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 204.83.221.2
Message-ID: <347_2DVgyLRi$GA.285@forums.sybase.com>
References: <347_HKao7GJi$GA.202@forums.sybase.com> <347_38C65035.7DD08C30@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26893
Article PK: 157852

Question:

A common example in Sybase documentation whether it is connecting a Trans or
DW ActiveX object is the following:

<PARAM VALUE="Driver='com.sybase.jdbc.SybDriver',
URL='jdbc:sybase:Tds:localhost:7373'" Name=dbParm></PARAM>

1. If one is to use PARAM values to set up the connection for an ActiveX DW
component is there additional code needed to execute or initialize the
connection?

2. In the above parameter the driver is 'com.sybase.jdbc.SybDriver', is
this the same jdbc driver one would use to connect to an Oracle DB?

3. In the URL does the section 'jdbc:sybase' refer to the driver type
again, or is this referencing a defined DSN, or something all together
different?

4. Would the following parameter be a viable connection for Oracle?

<PARAM VALUE="Driver='com.sybase.jdbc.SybDriver',
URL='jdbc:sybase:Tds:Beta:1525"></PARAM>

thanks


Jim O'Neil [Sybase] Posted on 2000-03-08 20:27:25.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 08 Mar 2000 15:27:25 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: ActiveX DW Component - how do you connect to Oracle DB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 42
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38C6B7AD.C4E1BA5@sybase.com>
References: <347_HKao7GJi$GA.202@forums.sybase.com> <347_38C65035.7DD08C30@sybase.com> <347_2DVgyLRi$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26865
Article PK: 157828


Garnet Fehr wrote:

> Question:
>
> A common example in Sybase documentation whether it is connecting a Trans or
> DW ActiveX object is the following:
>
> <PARAM VALUE="Driver='com.sybase.jdbc.SybDriver',
> URL='jdbc:sybase:Tds:localhost:7373'" Name=dbParm></PARAM>
>
> 1. If one is to use PARAM values to set up the connection for an ActiveX DW
> component is there additional code needed to execute or initialize the
> connection?
>

This is probably a minimum, since the connection is being made by PowerBuilder's
JDM driver under the covers, you could presumably add whatever DBParms that
driver understands.

>
> 2. In the above parameter the driver is 'com.sybase.jdbc.SybDriver', is
> this the same jdbc driver one would use to connect to an Oracle DB?
>

No. Oracle has it's own version(s) of JDBC drivers that you can download from
the Oracle website. For instance, OracleThin has
oracle.jdbc.driver.OracleDriver as the driver class.

>
> 3. In the URL does the section 'jdbc:sybase' refer to the driver type
> again, or is this referencing a defined DSN, or something all together
> different?

Think of the URL as the DSN and the format of the URL will depend on the JDBC
driver used. With Oracle it is different; for the OracleThin driver it's of the
following format jdbc:oracle:thin:@<server>:<port>:<SID>


>
> 4. Would the following parameter be a viable connection for Oracle?
>
> <PARAM VALUE="Driver='com.sybase.jdbc.SybDriver',
> URL='jdbc:sybase:Tds:Beta:1525"></PARAM>
>
> thanks

Nope, see the above.

--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


bobby Posted on 2000-03-08 20:32:49.0Z
Newsgroups: sybase.public.easerver
From: "bobby" <brosenberger@genam.com>
Subject: Re: ActiveX DW Component - how do you connect to Oracle DB
Date: Wed, 8 Mar 2000 14:32:49 -0600
Lines: 80
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: general.american.genam.com 208.209.229.251
Message-ID: <347_0Kg3o5Ti$GA.285@forums.sybase.com>
References: <347_HKao7GJi$GA.202@forums.sybase.com> <347_38C65035.7DD08C30@sybase.com> <347_2DVgyLRi$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26863
Article PK: 157829

Garnet... I feel your pain.

Here's what we had to do to get the ActiveX DW component working with Oracle
7.3. It ain't pretty. And it's been a while since we had to mess with it,
but here goes...

First of all, we had to unpack the oradwc70.cab file and repack it with some
of the files found in the jconnect directory. Specifically, everything below
the 'com' sub-directory. (we also digitally signed this file). Then we
deployed the file to powerdynamo.

Next we added an ActiveX transaction object on the HTML page (TRANSOBJECT).
On its properties page we set the "Code Base (.cab file)" to the new
oradwc70.cab file. Also on the properties page is a 'Control Properties'
button, clicking on that brings up a window that allows you to enter your DB
parameters. Ours looks similar to the following:

Driver='oracle.jdbc.driver.OracleDriver',URL='jdbc:oracle:thin:@10.4.110.48:
1526:finware'

This corresponds with the PARAM tag you were referring to. I believe the
'Driver' portion refers to the path within the .cab file where the oracle
drivers can be found, and the URL... eh... I believe there is a setup file
that defines your database addresses, etc., but I can't think of the name of
it off the top of my head (and our database guy is out sick).

Anyway, then add your userid, password to the 'Trans User' tab.

Next add your ActiveX DW (OBJECT1). Again, on its properties page we set
the "Code Base (.cab file)" to the new oradwc70.cab file. On the control
properties we pointed to the appropriate pbl and dw and left all of the
transaction information blank.

Finally, we added the following script to the onload event of the HTML page:

TRANSOBJECT.Connect( );
OBJECT1.SetTransObject( TRANSOBJECT );
OBJECT1.Retrieve(arg1, arg2, etc... );

I hope that helps. I'm certain I've left something off, but maybe that will
get you going again. If you have any specific questions I might be able to
answer them. Feel free to email me.

Good Luck,

Bobby R

Garnet Fehr <gfehr@flexicoil.com> wrote in message
news:2DVgyLRi$GA.285@forums.sybase.com...
> Question:
>
> A common example in Sybase documentation whether it is connecting a Trans
or
> DW ActiveX object is the following:
>
> <PARAM VALUE="Driver='com.sybase.jdbc.SybDriver',
> URL='jdbc:sybase:Tds:localhost:7373'" Name=dbParm></PARAM>
>
> 1. If one is to use PARAM values to set up the connection for an ActiveX
DW
> component is there additional code needed to execute or initialize the
> connection?
>
> 2. In the above parameter the driver is 'com.sybase.jdbc.SybDriver', is
> this the same jdbc driver one would use to connect to an Oracle DB?
>
> 3. In the URL does the section 'jdbc:sybase' refer to the driver type
> again, or is this referencing a defined DSN, or something all together
> different?
>
> 4. Would the following parameter be a viable connection for Oracle?
>
> <PARAM VALUE="Driver='com.sybase.jdbc.SybDriver',
> URL='jdbc:sybase:Tds:Beta:1525"></PARAM>
>
> thanks
>
>


Garnet Fehr Posted on 2000-03-08 21:28:03.0Z
Newsgroups: sybase.public.easerver
From: "Garnet Fehr" <gfehr@flexicoil.com>
Subject: Re: ActiveX DW Component - how do you connect to Oracle DB
Date: Wed, 8 Mar 2000 15:28:03 -0600
Lines: 4
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 204.83.221.2
Message-ID: <347_XXkPUWUi$GA.111@forums.sybase.com>
References: <347_HKao7GJi$GA.202@forums.sybase.com> <347_38C65035.7DD08C30@sybase.com> <347_2DVgyLRi$GA.285@forums.sybase.com> <347_0Kg3o5Ti$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26860
Article PK: 157825

Thanks for the advice I'll post again when I have had a chance to work
through this stuff and have more questions.