"Transaction not connected" error trying to connect to an ODBC database via PB7 Com in MTS
Non-database com object in MTS works aok, but connecting to a MSSQL
Server database fails with "Transaction not connected" error.
Seems like a rudimentary issue.
Any tutorials or white papers re PB7/MSSqlServer 6.5/MTS?
Any help apprecicated.
DTS IS running on SQL Server.
"Robert A. Chauvin" wrote:
> Non-database com object in MTS works aok, but connecting to a MSSQL
> Server database fails with "Transaction not connected" error.
> Seems like a rudimentary issue.
> Any tutorials or white pap...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...ODBC error: external error, while testing an ODBC connection to an ASE server
"The connection failed because of invalid or missing external configuration data."
Does this have to do with the configuration of OCS-12_0 or the ocscfg.exe? Running ocscfg.exe, I've set the "SYBASE:" directory to "C:\sybase" but it doesn't seem to like it when I set the "Sybase_OCS:" to "C:\sybase\OCS-12_0". I don't know if this is related.
Another idea - on the install I chose "No" to updating the msvcrt.dll (the MS C Runtime) because I've seen that hose a system before. Is this file safe to overwrite and ca...ODBC error (Database error)
We are working with PB 5.04 on Windows 95.
When we use ODBC connectivity with Sybase SQL Anywhere databases we have
problems with datetime (timestamp in SQLAnywhere) fields.
The error that PB reports is :
SQLSTATE = 07006
[Sybase][ODBC Driver]: cannot convert 1990-07-14 00:00:00. -10742 to a
I have installed Windows95 (spanish version), Office97(spanish version),
Internet Explorer 4.01 (spanish version), Microsoft Outlook 98 (spanish
version), PB 4 and PB 5.04.
I have another PC with Windows 95 (spanish version), Office97(spanish
version), Inter...ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10
Hi, I am randomly getting the following error message in my application.
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP Address of the server'(10048) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'IP of the server' (10048)
I am using .Net 2.0 with VS2005 having ODBC 3.51.14 Driver.
Can any body point out the core reasons of the above error message?
I do have the same problem, help me out.
If the going seems easy, You are going DownHill...
When I was writing ...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 ...Error in connecting to a database via ODBC from a PB7 MTS Component
I've developed a simple MTS/COM component in PowerBuilder and I've deployed
it to my MTS server, i've added code to access a SQL Server database on my
machine via ODBC, I"ve also developed an ASP page as the client and
everytime it connects to the component and runs the 'dbsetup()' function I
wrote to connect to the database, the following error comes back to me:
SQLSTATE = S1110 [Microsoft][ODBC Driver Manager] Only SQL_DRIVER_NOPROMPT
is allowed when connection pooling is enabled
whats really odd, is that whether or not I specify a correct...check my way to connect database and give me some suggesstions to fix my error (ODBC)
I have a ASP.net (VB.net)
It has been on server for 4 months. But some time it have an error (once time in a day) about database connect, sometime is not.
If this error Occur, I always access to server/control Panel/IIS/…ApplicantionPools/default AppTool and stop then start it. After that, my web page display normaly again.
I can not find out why the error occur and slove, but i think the way to connect to database may be cause this error while have too many user access. Please check:
My database is SQLBase and used ODBC to connect.
1. When design a webcode I always...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, firstname.lastname@example.org 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...Communication error on ODBC connection to ASA 10 database on remote computer
I'm unsuccessfully trying to establish an ODBC connection
from a 32 bit Windows Vista computer to an ASA 10.0.1.3515
build on a 64 bit Windows 2003 server through tcpip.
I created a system dsn entry on the Vista computer with a 32
bit SQL Anywhere 10 driver and the tcpip entry
because according to the log of the db server (-z option)
instead of port 2638 port 49152 is used. If I test the
connection I'll get the following error:
Connection failed: Connection Error: Server found, but
The..."Alias is not currently opened. Database server rejected connection. Database server connection limited exceeded." error message
Hello Sybase User Experts,
I like to find out the cause of this error message "Alias is
not currently opened. Database server rejected connection.
Database server connection limited exceeded." Do you have
any idea about this? What is the cause and how to solve this
problem?! Your answer or idea to this error message will be
a great help to me. Thank you in advance.
First of all, what database server are you using? And how are you connecting
<Beverly> wrote in message news:3f7932b1.1356....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...ODBC Error 08001 Database Error -84
I am receiving this error on a Windows 98 pc.
I am new to Sybase SQL Database. I got roped up into this problem
One Computer has:
ODBC Error 08001 Database Error -84.
[Sybase][ODBC Driver][Adaptive serber anywhere]Unable to connect to database
server: specified database is invalid
Another Computer Has:
Windows 98 Computer Also.
Data source name not found and no default driver specified
Any help would be greatly appreciated.
Please copy my email address:
You might get more help on sybase.public.sqlanywhere.general news...I'm getting java.sql.SQLException and Database not found error while connecting SQL Anyware using ODBC driver.
I'm getting java.sql.SQLException and Database not found error while
connecting SQL Anyware using ODBC driver.
I've specified following points while creating the DSN
And I'm trying to access this database by writing a JAVA program.
I created URL like this
Now it is throwing above error can anyone please suggest me how to get rid
of this problem, any thing more has to be done, please specify
Thanks in advance,
...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