PB 6.5.1, Connect to Oracle 8.1.6.3 with PBO7360.DLL (v6.5.1.620)Hey,
I've got a developer that I can't get to connect to Oracle from within the
PB dev environment (PB 6.5.1). tnsping is fine, all the other Oracle
utilities as well, as non-Oracle programs can connect just fine, but just
not PB. If you try to configure the database connection under Oracle7,
@tns:sun3500 the returned error code is ORA-01019, and then ORA-12514 (if
you try again). He has the Oracle 9.2.0.1.0 SQL-net client installed. I
have the same SQL-Net on my machine, and it works fine. We've tried SQL-Net
8... as well no difference, and we've re-installed PB...
PB 6.5.1, Connect to Oracle 8.1.6.3 with PBO7360.DLL (v6.5.1.620)Hey,
I've got a developer that I can't get to connect to Oracle from within the
PB dev environment (PB 6.5.1). tnsping is fine, all the other Oracle
utilities as well, as non-Oracle programs can connect just fine, but just
not PB. If you try to configure the database connection under Oracle7,
@tns:sun3500 the returned error code is ORA-01019, and then ORA-12514 (if
you try again). He has the Oracle 9.2.0.1.0 SQL-net client installed. I
have the same SQL-Net on my machine, and it works fine. We've tried SQL-Net
8... as well no difference, and we've re-installed PB...
Memory error on connect after disonnect NT4 / ORACLE 8.1.6 /PB 6.5.1Hi,
With this code, I have a memroy error on the line connect. It's not
doing it on debug.
I am very concerned...
COMMIT ;
Disconnect ;
IF SQLCA.SQLCode = -1 THEN
.... END IF
Destroy(SQLCA)
SQLCA = Create u_transaction
ls_database = ProfileString (App.is_fichierIni, "Environnement",
"Database", "")
SQLCA.DBMS = ProfileString (App.is_fichierIni, ls_database , "DBMS",
"")
SQLCA.ServerName = ProfileString (App.is_fichierIni, ls_database,
"ServerName", "")
SQLCA.AutoCommit = False
SQLCA.D...
PB 6.5.1 against Oracle 8.1.6We are planning to upgrade our Powerbuilder 6.5.1 app running against
Oracle 7.3.4.4 to run against Oracle 8.1.6. It seems that a lot of people
are doing the same thing. However, people keep referring to obtaining a
later build number of Powerbuilder. Am I understanding
this correctly that that versions of Powerbuilder have multiple
builds. For instance, Powerbuilder 6.5.1 has multiple builds ? How do you
determine the current build number you are running ? Help..About does not
work. Where can I get the latest build ? I do not plan to use the new
features of Oracle 8.1.6 so...
PB 6.5.1 on Oracle 8.1.6 :Any Issues
Hi,
We have a highly stable production environment running a PB application (Pb
Enterprise/32 6.5.1) on Oracle 8.0.6.
Oracle is being migrated to Oracle 8.1.6 and I would like to know any known
issues to staying with Pb 6.5 on Oracle 8i. Do we have to migrate to Pb
7.0. Are there any connectivity issues ?
Any info or pointers to info sources would be greatly welcome ...
Thanks in advance
We have been unable to get our pb6.5 app to work
reliably against 8.1.6. The Oracle ODBC drivers
supplied with 8.1.6 seem to be the problem source.
Our 8.1.6 clients use MS Oracle OD...
Connecting Metaworks 6.1.5 to Oracle 8.1.6I am setting up the ODBC connection from a Windows NT client
running PowerDesigner DataArchitect and Metaworks 6.1.5,
and Oracle 8.1.6 Net8, to Windows NT server running Oracle 8.1.6
Server Enterprise Edition.
I have installed the following ODBC drivers in C:\Winnt\System32:
Intersolv DataDirect pbor712.dll 3.01.0002
Intersolv DataDirect pdor712.dll 3.01.0000
Microsoft ODBC for Oracle msorcl32.dll 2.573.4202.00
Oracle ODBC Driver sqora32.dll 8.01.06.00
My Oracle Net8 8.1.6 service identification for the database where the
Metaworks schema is located has the following properties:
S...
PB 6.5.1 & Oracle 8.1.6We have upgraded to 8.1.6 Oracle database with PB 6.5.1 Build 1206. Our
latest problem with the 8.1.6 database is an ORA 6502 on some stored
procedures we are calling from a datawindow. It is intermittent, but when
the users get it, I can re-produce it but then it will disappear with no
changes on our part. Just wondered if it had been noted before and if there
is a known problem. It appears to be happening ONLY when we are using the
O84 dll, it never happens if we use the O73 dll. I re-compiled with the
latest release EBF for 6.5.1 and we seem to have the same errors. We have...
SOS: Sync with Oracle 8.1.6.1.0 using 8.1.6.1.0 ODBC DriverHelp!
If any customer has successfully replicated bi-directionally from ASA7 to
Oracle 8i (8.1.6) using the Oracle 8.1.6 Oracle ODBC Driver, we would
appreciate any insight you may have concerning the small number of steps
involved in implementing replication. I may be contacted directly at (206)
933-4956.
Martin Douglas
Senior Data Architect
e-Commerce Group
Food Services of America
Please always specify the version and MORE importantly the BUILD number of
ASA you are using with each post.
If you are having problems with this Oracle driver, some of our customers
hav...
CLOBs, PB 6.5 app and Oracle 7.2.3->8.1.6 or 8.1.7Hi All,
I tested my PB 6.5 app with an Oracle 8.1.6 database where LONG fields have
been converted into CLOBs, and the app refused to deal with CLOBs. For
now, I'm okay, because (for other reasons) the CLOB conversion has been
delayed. But have other people found good results accessing these new
Oracle types from PB applications? What have your experiences been?
Thanks,
Linda
...
PB 6.5.1 and Oracle 8.1.6 Would appreciate any advice on this.
Getting error: PB60 caused an invalid page fault in module <unknown> at
0000:0200524f on datawindow Retrieve() with PB 6.5.1 & EBF 1216
installed when using O84 database interface. All objects regenerated
after installing EBF 1216. The datawindow retrieves rows from just one
table.
Same result if using the base PB 6.5.1 Maintenance Release and just the
PBO8460.dll (build 1173).
Database is Oracle 8.1.6, Oracle8i client installed on the PC running
Windows 95 B.
I can retrieve rows with no problem from same table in data manipu...
UrgentWe are attempting to migrate a PB application running on Oracle 8.0.5 to
Oracle 8.1.6 for a client. This is a new install of Oracle8i on a WIN/NT
4.0 SP6 server. We are attempting to use a Win98 w/s connected thru TCP/IP.
We've loaded the 8i client on the workstation and sqlplus works fine. We've
regenerated the application using PB6.5.1 bld 1173 and are using the correct
runtime dlls (pbvm60.dll bld 1173, pbo8460.dll bld 1173, etc. ). When the
application is ran, it seems to connect to the database for ID validation
but then gets a invalid page fault in <unknown> at...
PB 6.5.1 Win 98 and Personal Oracle 8.1.6I am having trouble trying to connect my PB to Personal Oracle 8i. Here is
what I have:
PB 6.5 installed.
Downloaded the PB 6.5 EBF Build 1264
Included the "O84 Oracle8.4" in my PB.INI file
Running Personal Oracle 8i ver. 8.1.5
It lets me set up the connection, but when I try to connect (with either
O84 driver or the O73 driver I get this error:
Hmm.. now that I am connected to the internet it didn't crash but I recieved
this instead: ORA-12154: TNS: could not resolve service name.
What do I need to do?
Thanks,
Mike
Leave the servername blank.
...
Latest Oracle 8 driver for PB 6.5 (NOT 6.5.1)What is the latest Oracle 8 driver I can use with 6.5?
6.5.1 is not an option for me, it constantly GPFs when I try to regenerate
my app, so I have to stay with 6.5, which is very stable.
Thanks,
Jacek
What build of 6.5 are you on?
--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn
Jacek Furmankiewicz <jfurmankiewicz@stssystems.com> wrote in message
news:S6#U0REZ$GA.303@forums.sybase.com...
> What is the latest Oracle 8 driver I can use with 6.5?
>
> 6.5.1 is not an option for me...
PowerBuilder 6.5 and Oracle 8.1.6I'm a little out of the loop. We have PowerBuilder applications in 6.5
currently running with Oracle 7.3.4. We will be upgrading all Oracle to
8.1.6. We have heard that PowerBuilder 6.5 isn't supported with Oracle
8.1.6, but I haven't been able to confirm on Sybase website. I have seen a
lot of problems listed in the newsgroups. 1. Is this true and 2. Do any
of the releases support Oracle 8.1.6... like PowerBuilder 8.0?
Katie
For information on supported version , please look at : TechDoc # 1011566
Notice from Sybase to Customers: Support for Using PowerBuil...