PowerBuilder 9.0.1: Connect to Oracle Using the PowerBuilder Native Driver
Could anyone please email me this Solved Cases? It may be
related to our production issue.
Thanks in advance,
The first one only affects the development environment, and the second
one is only applicable to datawindows build with the old PBDBMS
What problems are you having?
On 12 Oct 2004 08:56:32 -0700, John Shi wrote:
>Could anyone please email me this Solved Cases? It may be
>related to our production i...Problem connecting to oracle database in powerbuilder 9.0 desktop version
I am not able to connect to oracle database using odbc in
powerbuilder 9.0 desktop version.I am getting error message
which says 'Inavlid or unsupported datasource'
Have you verified that you have the required Oracle ODBC drivers? The latest
set of drivers is available at:
Could you also please post the attributes of the transaction object (except
the password) that you use to try and connect to the oracle db?
<Ershad Ali Mohammad> wrote in message
news:41aea458.51d5...Oracle 10g Database connectivity in PowerBuilder 11.5 Desktop Version using ODBC
This is a multi-part message in MIME format.
Content-Type: text/plain; charset="ISO-8859-1"
I have installed PB 11.5 Desktop version with all the EBF`s.
I created a DSN for the Oracle 10g default ('Orcl') database
through ODBC Administrator. I was successfully able to
to the database through the DSN.
Now I created a Database Profile in PowerBuilder 11.5
version for the DSN created above. When I tried testing the
database connection I got the errors present in attached in
document...Powerbuilder 10 oracle connect error: ORA-01950: no priveledges on tablespace 'USERS'
I get this error trying to connect to an Oracle 9i database in PB10 using
the Oracle 8 client software: ORA-01950: no priveledges on tablespace
'USERS'. The connection works fine using PB7, but not with PB10. Below is
the profile I am using (I replaced sensitive stuff w/ <> tags):
DBMS=O84 ORACLE 8.0.4
...Connecting PowerBuilder 6.5 with an Oracle 7.3 Database in a Novell Netware 3.12 Server
Ladies and Gentlemen:
I didn't know if some of you have these problem, but I solve this one in a
We have two servers in our company, one is a Windows NT Server and other is
our Novell Netware 3.12 Server. Right know, our clients are accesing the
data from the Netware 3.12 to the NT Server, but our clients are using in
line the systems developed in PowerBuilder 4.0
Also we are migrating from PB 4.0 to PB 6.5 (How a jump), but we need the
connection with the 3.12 server to recompile all our functions and so on....
I just update the Netware Client from Windows wi...connecting to database from powerbuilder
Is there any way to connect to database from powerbuilder
other than transaction objects..
Thanks in advance
a powerbuilder application needs transaction objects to interact with any
what functionality are you trying to build?
<Suby> wrote in message news:email@example.com...
> Is there any way to connect to database from powerbuilder
> other than transaction objects..
> Thanks in advance
The transaction object is the object to be used to connect to any database?
What do you...connect Oracle in PowerBuilder
When I connect to Oracle in PowerBuilder it give me error
SQLSTATE = S1000
(Oracle) ODBC Oracle Driver)(Oracle OCT) ORA-12154: TNS could not
resolve service name.
Above error I never hed problem to connect but today I have error to
If you are using:
then the service name must appear in your tns services file: tnsnames.ora
search for that file and be sure your service name appears there.
John Olson [TeamPS] firstname.lastname@example.org
Developower, Inc. developower@bigf...powerbuilder database connections
I receive this error message when I try to connect the dbclient. "unable to
start, server not found"
When I try to connect to any type of database in Powerbuilder, I receive
unable to load Powersoft ODBC DLL
could not load interface for specified database
In article <TcVR68XL9GA.email@example.com>, firstname.lastname@example.org says...
>> When I try to connect to any type of database in Powerbuilder, I receive
>> these errors:
>> unable to load Powersoft ODBC DLL
>> could not load interface for specified ...test DBD::Oracle DBI connect('','user/password@database',...) failed: ORA-12154
Content-Type: text/plain; charset=us-ascii
I can connect to the database using sqlplus as user oracle, but not as root.
I can compile DBD::Oracle but not complete the test.
I tried to set variables properly:
TNS_ADMIN=/u/or...Cannot connect my database to Powerbuilder
I am new to Powerbuilder. I am unable to run a Powerbuilder program
with the database that I have specified in the 'Database Painter'.
Could you please help me? I am able to see the tables in the painter
but when I try and run the exe after building it, it does not seem to
be pointing to that database.
You have to populate those same attributes on the SQLCA connection
object and then issue a CONNECT statement within your application
On Mon, 30 Nov 2009 18:33:22 -0800 (PST), anand_icomm
&g...powerbuilder database connections
When I connect to any database using Powerbuilder 4.0 I get the following
unable to start, server not found
Could not load interface for specified database
unable to load Powersoft ODBC DLL
The system can't find PBODB040.DLL.
Carson Hager Dynamic Data Solutions
Team Powersoft http://www.dyn-data.com
******** Are You Ready for the Web ********
...Version of PowerBuilder (ref: Creating database for PowerBuilder)
I'm using PowerBuilder v8.0 and would like to create a
notification system for my practiculum project. I'd like to
use Access to create the database. Please enlighten me on
what should I create (e.g. tables, queries) for the usage of
Don't double post, it's bad etiquette.
Unless you have a very good reason to do so, we recommend you don't use
Access. Use SQL Anywhere instead - it's more stable - and a far better
database in my opinion. PowerBuilder (enterprise) supports just about every
database out there, so if you...How to connect PowerBuilder to Oracle 11g and which PB version suppports oracle 11g?
Please tell me how to connect PowerBuilder to Oracle 11g and which PB
version suppports oracle 11g? Currently i am using Power Builder
FYI: PB version 11.5 and higher has support for the new native O11g
driver. You can still use older versions of PB that use the O10g driver over
to 11g - but, you will be restricted to 10g functionality.
Regards ... Chris
ISUG - NA RUG Director
"mukul" <email@example.com> wrote in message
news:3f291629-08c6-446a-8c81...PowerBuilder 9.0.2 native Oracle driver for Oracle 10g database
We are migrating from Oracle 8i to 10g. The PowerBuilder
9.0.2 application is extremely slow using PowerBuilder
Oracle 8.4 or 9.0 native driver to connect to Oracle 10g
database, We had to use 7.3 driver. After using trace we
found that the SQL scripts with index hint cause slow down,
but they are working ok using Oracle 8.4 driver with Oracle
8i database. Any suggestion which is best way to connect
from PowerBuilder 9.0.2 to Oracle 10g database? We have
tried the Oracle 8.1.7 client and Oracle 9.0 client.
I found a solved case on Sybase support web site, but we do
not have support...