problem when connecting MS SQL Server 7.0 with powerbuilder 6.5
I have some problem when connecting MS SQL Server 7.0 with powerbuilder 6.5
The error message is:
Database transaction information not availiable.
Call SetTrans or SetTransObject function.
I have a window with 1 button and 1 datawindow
The datawindow inside contain a SQL statement
in the click event of the botton, the script is:
Can anyone tell me what is the problem? And how to solve it???
Thank You Very Much!!!
It seems that the database connection is not available or not successfully
...How to set database profile to PowerBuilder 10.5 connect to MS-SQL Server 2000 sp4?
How to set database profile to PowerBuilder 10.5 connect to MS-SQL Server
It seems that the special connection inferface for "MSS Microsoft SQL
Server" is canceled in PowerBuilder 10.5.
I do not want to via ODBC.
No, MSS driver (actually Microsoft's NTDBLIB.dll) was cancelled by Bill
Gates in SQLServer v7. It was supported in 2000 - but ANSI only with limited
functionality and dropped for SS2000 and 2005 in the Unicode world.
So your choices are: ODBC, OLE-DB and ADO.net. There is new SNC driver for
PB 11 that is simil...How do i upgrade PowerBuilder 5.0's native driver for MS SQL Server 6.5?
If you have the 5.0.04 patches, you have the latest stuff that I know of.
Tech Support might have something as a private EBF, but you would have to
contact them directly to determine that. Are you having a particular
problem with the drivers you have now?
On Tue, 9 Feb 1999 11:38:18 +0800,
A-B-C <email@example.com> wrote:
Bruce Armstrong [TeamPS] | Romac/Source International
mailto:Bruce.Armstrong@eudoramail.com | mailto:firstname.lastname@example.org
| http://www.romac-sou...Powerbuilder 5.0.4 and MS SQL 2000?
I have tested our application developed in PB 5.04 with MS SQL 2000, it
works fine. Do I need to upgrad the application to PB 7 or up? Is there any
reason to do that?
> I have tested our application developed in PB 5.04 with MS SQL 2000, it
> works fine. Do I need to upgrad the application to PB 7 or up? Is there any
> reason to do that?
You are probably better off posting this question in the PowerBuilder newsgroup. However,
I do work with PowerBuilder and can offer the following opinion:
1. PB 5 is really...Powerbuilder 10.5
I am trying to connect to SQL Server 2000 from PB 10.5 and
it gives me error "DBMS MSS is not supported in your current
Can anyone help me with this ? I do not see any Native DLLs
from Powerbuilder 10.5 for SQL Server 2000. How do I use
OLEDB Drivers for this ?
try using this...
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
hope this help
<ADuvvuru> wrote in message news:46bb9f7b.1420.1681692777@sybase....Powerbuilder 6.0 and MS SQL Server 2000
I have searched far and wide on the internet for the following problem. I
have figured out a work around, but would like to know if anyone has solved
the issue (other than the you need to upgrade answer).
We have a PB 6.0 application with a MS SQL Server 2000 Database on an NT
box. The application works fine, we have no problems running the
application. The problem is in the development environment.
I can connect to the database with MSS SQL Server 6.x native driver, but it
has problems. It cannot create a datawindow without getting an error. It
says&qu...PowerBuilder 6.5 and MS SQL 7.0 Connection
I'm facing a problem in connecting powerbuilder 6.5 to MS SQL 7.0 on
when i try to connect to database it creates the connection without giving
any error but when i try to see the tables in database painter or anywhere
else it does'nt show me the tables and gives me error
"SQLSTATE = S1003
[ODBC][SQLSERVER]Program type out of range"
i've formatted my hard disk and again installed 'Windows ME' and other
required softwares but the problem is still there, any suggessition would
be worth for me.
What build of...Connecting Powerbuilder 5.0.04 to MS ACCESS 2000
I have a MS ACCESS 2000 - database for my application.
When i use my datawindows in PB (DW-Painter) i�m able to retrieve
But when i start the application, i�m not able to retrieve
CHARACTER-data (Columns with Type TEXT in Access).
It seems, that PB couldnt map the Access-Type TEXT to his own
Type CHAR. The DB-Painter says "VARCHAR 1000" for TEXT.
Why does it work in PB - I use the same PBODB050.INI ?????
Are you sure you're using the same PBODB50.INI? That INI file MUST
reside in the same directory as the PBODB50.DLL that is loaded, if the
fi...Connectivity of PowerBuilder 6.5 and SQL Server 7.0
I need help regarding connectivity with PB 6.5 and SQL Ser. 7.0. I am
getting an error message "DBMS MS Sql Server ... not supported in current
installation' or 'Unable to load the requested database interface".
I have required files for both the system and for PB i.e., NTWDBLIB.DLL
PBMSS60.DLL but still i am not able to connect to the database.
Check the sybase site, there is useful infor about the matter.
"mahesh" <email@example.com> wrote in message
new...Connecting to an SQL Server 2000 Database from Powerbuilder 6.5
I have a WINDOWS 2000 SERVER on which the SQL SERVER 2000 (Standard=20
is running.. From a WINDOWS NT Workstation Client (on the same Network)
I' trying from within Powerbuilder to connect to my SQL SERVER 2000
database via ODBC. I created and configured the ODBC driver for this=20
connection as well as the associated Powerbuilder DB-Profile.
When then I try to connect (from the Database Profiles popup window) to
my database, the sonnection is successfull but when the popup window
of Powerbuilder appears (in the Database Painter Window) for selecting
the tables of the d...MS SQL Server 7.0 and PowerBuilder 5.03
We have been battling a data transfer bug with SQL Server 7.0 where
Microsoft's transfer manager is failing to transfer all objects to a
data base. After completing one such transfer, we are having problems
getting the PowerBuilder development environment to recognize table
structures. My theory is that Microsoft has inadvertantly tossed some
stored procedures used by PowerBuilder. My on-line PB documentation
says that no scripts need to be run on SQL Server 6.5 because PB uses
the system catalogs for its information. How about SQL Server 7.0? Are
there any scripts I need to r...Powerbuilder 9
I am trying to get connected to Microsoft SQL server 2000 using SSL,
through the native driver (MSS (Msoft) SQL Server 6.0).
Unfortunately, the code I am supporting is such that I can't change to
ODBC or OLEDB easily. Is there a way to set the native driver to
communicate using SSL? I tried DBPARM=Encrypt=1 and many other
similar combinations, but no luck so far.
...Connection problem with PowerBuilder 5.0.02 to MS SQL 7
I am having a problem connecting PowerBuilder 5.0.02 to MS SQL 7. The
application connects fine. The problem is when I try to create a new
datawindow with a stored procedure on SQL 7. I can view all the names of
the stored procedures but I can't see any of the code. I am using the odbc
driver 3.07.08.20 . When I try to look at the stored procedures I get the
message 'The database does not currently support retrieval of procedure
text.' Everything worked fine in SQL 6.5.
any help appreciated,
---== Posted via the PFCGuide Web Newsreader ==---
ht...MS SQL Server 6.5 to MS SQL Server 2000
We are migrating from MS SQL Server 6.5 to MS SQL Server 2000. We are using
a Native connections and would like to know if there are any issues that we
should be aware to do this correctly.
Are you sure about that? I have not experienced (or heard of) that kind of
problem w/ 7.0. There are many other reasons why a table san is performed,
but I don't think a numeric data type would cause it... Or are you talking
about the PB problem of sending an Integer as 1.
Sisu Group, Inc.