| Author |
Connecting to Oracle 9i database
|
|
|
| Can someone provide me the DB connection parameters to
connect to an Oracle 9i database? I was using sybase and
have converted to Oracle. This is what I have:
t = Create transaction
t.DBMS = "O90 Oracle9i (9.0.1)"
t.DBParm = " UseContextObject='Ye
s',CacheName='dev2'"
connect using t ;
dev2 is set at Oracle 9i using oci.dll driver. I can ping
successfully thru Sybase Central
Thanks
Jay
| |
| Carson Hager 2005-04-13, 8:24 pm |
| That looks pretty good. Are you getting an error in t.sqlerrtext?
Carson
____________________
____________
Carson Hager
Cynergy Systems, Inc.
http://www.cynergysystems.com
Take PowerBuilder Applications to the Web Today with Cynergy EAF 4.0
http://www.cynergysystems.com/public/products/eaf
<Jay> wrote in message news:425db4b0.7b43.1681692777@sybase.com...
> Can someone provide me the DB connection parameters to
> connect to an Oracle 9i database? I was using sybase and
> have converted to Oracle. This is what I have:
>
> t = Create transaction
> t.DBMS = "O90 Oracle9i (9.0.1)"
> t.DBParm = " UseContextObject='Ye
s',CacheName='dev2'"
> connect using t ;
>
> dev2 is set at Oracle 9i using oci.dll driver. I can ping
> successfully thru Sybase Central
>
> Thanks
> Jay
| |
| Rob Martin 2005-04-14, 3:24 am |
|
<Jay> wrote in message news:425db4b0.7b43.1681692777@sybase.com...
> Can someone provide me the DB connection parameters to
> connect to an Oracle 9i database? I was using sybase and
> have converted to Oracle. This is what I have:
>
> t = Create transaction
> t.DBMS = "O90 Oracle9i (9.0.1)"
> t.DBParm = " UseContextObject='Ye
s',CacheName='dev2'"
> connect using t ;
>
> dev2 is set at Oracle 9i using oci.dll driver. I can ping
> successfully thru Sybase Central
>
> Thanks
> Jay
Just out of interest Jay, you could try it with just the "O90" in dbms,
without the rest of the text ( I assume it should work, being picked up as
space delimited, but I've never used it like that).
Cheers
Rob
| |
|
| I'm new to this so I'm flying by the seat of my pants. I
don't know how to find/see what error I'm getting.
Thanks tho
Jay
> That looks pretty good. Are you getting an error in
> t.sqlerrtext?
>
>
> Carson
>
> ____________________
____________
>
> Carson Hager
> Cynergy Systems, Inc.
> http://www.cynergysystems.com
>
> Take PowerBuilder Applications to the Web Today with
> Cynergy EAF 4.0
> http://www.cynergysystems.com/public/products/eaf
>
>
>
> <Jay> wrote in message
> converted to Oracle. This is what I have: >
>
>
| |
| Carson Hager 2005-04-14, 1:24 pm |
| No problem. Check the value of that property after the failed connect and
let us know.
Carson
____________________
____________
Carson Hager
Cynergy Systems, Inc.
http://www.cynergysystems.com
Take PowerBuilder Applications to the Web Today with Cynergy EAF 4.0
http://www.cynergysystems.com/public/products/eaf
<Jay> wrote in message news:425e9f4c.59ae.1681692777@sybase.com...[color=darkred]
> I'm new to this so I'm flying by the seat of my pants. I
> don't know how to find/see what error I'm getting.
>
> Thanks tho
>
> Jay
>
|
|
|
|