Problem in connecting DataBase through ODBC
I am using DBase database throught Odbc in ASP.NET. But it gives following error &n...Powerbuilder and ODBC connection to Progress database
We are trying to connect an application to a Progress database. Our
application is written in PB 5.04.
We have version 8.3E of Progress and would like to establish an ODBC
connection to our application. We are able to connect to Progress but
not in Powerbuilder or through our application. Does anyone have any
DBC SMARTSoftware, Inc
When you cannot connect, what error do you get? Can you connect outside of
PowerBuilder via ODBC using MS Query or some other tool. The newer versions
of ODBC Administrat...Problem connecting PowerBuilder to Access Database
I try to connect Powerbuilder 8.0.3 to Access Database, but it can let me
edit data in tables.
// Profile access
SQLCA.DBMS = "OLE DB"
SQLCA.LogId = "admin"
SQLCA.AutoCommit = False
Why I can do this?
There have been problems with detemrining Access primary keys. When a PK
cannot be determined or is undefined, PB will, by default, assume that the
table is not updateable. You can override this in the update ...Powerbuilder 8 connectivity problem to legacy unix database
I hope that this forum may be able to help me or at least advise me.
I have been testing PB8 for an application currently written in PB6.5.
The backend of the application is a legacy Unix DBMS for which no
development has been done for a number of years.
The 32 bit ODBC driver is suitable for windows only.
Currently W95, W98, W2000 clients can connect to it using the PB6.5
compilation and run the applications quite successfully.
(XP does not produce the correct result whe functions are part of the Select
However, when using PB8 Enterprise edi...Problems with Powerbuilder accesing an Acces Database via ODBC
I've developed an application with PB60, under windows NT Wk. 4.0
I compiled it and tested it under WNT Wrokstation 4.0 and it worked fun.
Afetr it, I re-compiled and regenerated the application under W95, and when
I tried to execute the .exe file compiled, I couldn�t acces the database,
and I catched this error when trying to connect the SQLCA:
"DBMS ODBC is not supported in your current Instalation".
Moreover, if I run the application with the "RUN" painter, it works ok!
I get the parameters to connect from an .INI file, which is in the same
directory that t...PowerBuilder 6.5 issues with an ODBC connection to a Database
PowerBuilder 6.5 Build 444
********** ALSO SEE ATTACHMENTS ************
I am working on the project that we talked about in April.
We are hoping the client will be convinced to go to
PowerBuilder 10.5, but at this moment I am stuck in the 6.5
We are using a new database by HP in which it is a Non Stop
System. It is an ODBC connection (ver. 3) with the drivers
developed by HP. It is SQL '9x compliant ( ANSI SQL:99 ).
After connecting I get errors when trying to retrieve a
datawindow. The first time when opening the Pre- View I get
data because of the ...Problem Client 12.5.2 ODBC connecting to multiple databases
ASE Multi-server environment.
We connect to the catalog, call a stored procedure (sp_1)
determine which customer database the requested account
on, then this proc calls a stored procedure (another sp
on the target customer database to retrieve the required
In the catalog sp_1 after determining which server and
database the account resides on we build up a string such as
@cmd = server.database..sp_1 'account123'
Then call exec (@cmd)
Using client 12.0 this works.
After upgrading to 12.5.2 we now get an error when calling
exe...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...Avoiding ODBC Connections when setting up a UDB database in Powerbuilder 7.0
i am trying to get rid of the ODBC settings that are generally
required when one tries to connect PB with UDB. Is there a way to do
You would still need to have the driver registered. But you could use
a DNSless connection to avoid having to have entries for the database.
See the last half of the following:
On 29 Jan 2007 04:56:50 -0800, email@example.com wrote:
>i am trying to get rid of the ODBC settings that are generally
>required when one tries to connect PB with UDB. Is there a way to do...Problem with DBD::ODBC (via unixODBC) connection to remote ADABAS-11 database
I am experiencing a puzzling problem while trying to get an DBD::ODBC
connection (via unixODBC) working from a client machine A (Suse linux)
to a an ADABAS-D-11 database running on a remote machine (B, also Suse
-------------------------- Machine A (client)
Perl : 5.008005 (i586-linux-thread-multi)
OS : linux (188.8.131.52)
DBI : 1.43
DBD::Proxy : install_driver(Proxy) failed: Can't locate
RPC/PlClient.pm in @INC
DBD::ODBC : 1.06
----------------------------------------...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...Problem to connect to ASA database with WLAN connection
I develop a pocketbuilder application on a Windows CE mobile. I want to
connect the mobile directly to a ASA database on the network.
When I try the connection, I have nothing... I wait...
For the moment, the database is on my PC and ping to my PC works.
Perhaps I have problem with memory or with the definition of my DSN File.
Thanks for your help.
How have you started the database engine on your PC? Did you use...ODBC Connection parameter for ASA database for FireDac Connectivity
we are migrating our Delphi application from BDE to FireDac and during the database connectivity in BDE we have used below ODBC connection code parameter:
Connection definition parameters for BDE
DATABASE NAME = Globalware.db
ODBC DSN= Globalware32
SCHEMA CACHE SIZE=8
SCHEMA CACHE TIME=-1
SQLPASSTHRU MODE=SHARED AUTOCOMMIT
ENABLE SCHEMA CACHE=FALSE
...Database Connection???How to connect a Database in an other server?
How to connect a Database(.mdb) in an other server?
Can I use the connection string like below?
mycon.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=http://www.****.com/***/mydb.mdb"
You can not.
Access is file based. No a client/server architecture.Thomas TomiczekPowerNodes ApS(Microsoft MVP C#/.NET)---Building a Website? Try the PowerNodes CMS - http://www.powernodes.com/
Correction: you can. Just make sure you can reach the acces db file - through a file share that is bound as drive.
Not that you should. Performance will be horrib...Problem wit migrating Informix Firedac ODBC connection to Infx Connection
Now Firedac in XE6 supports Informix natively besides odbc, i decided to use the native way from now on.
However, i came up with some odd behaviour:
Take the following query:
select * from fys_punt_im where nummer = "1000";
Where column nummer is of type varchar(10).
When executing this query using Firedac Infx connection i get the error:
ERROR: SQL state: 42S22. Native error: -217. Error message:
[Informix][Informix ODBC Driver][Informix]Column (1000) not found in any table in the query (or SLV is undefined).
However when executing the same query using Firedac ODBC conn...