problem when connecting MS SQL Server 7.0 with powerbuilder 6.5Dear All,
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:
parent.dw_1.SettransObject(SQLCA)
parent.dw_1.retrieve()
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
connected.
...
Problems with db-library and ODBC using with MS SQL Server ver 7.0 PowerBuilder ver 6.5. And OLE-DB for Microsoft OLAP ServicesThere are many problems when running the aplication using the new ODBC
driver for SQL ver 7. Simple, does not work.
It�s any patch to this problem ?
Using DB Library makes poor query plans in some case using SQL Server 7.0.
It�s any path ?
It�s any patch or utility to use OLE-DB for connecting Microsoft OLAP
Services ?
Carlos Lara
darsa@solnet.com.mx
...
PowerBuilder 6.5 and MS SQL 7.0 ConnectionI'm facing a problem in connecting powerbuilder 6.5 to MS SQL 7.0 on
'Windows ME'
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.
Thanks
Saqib Sardar
What build of...
Connectivity of PowerBuilder 6.5 and SQL Server 7.0Hi Guys,
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.
Please help.
Regards,
MS
Check the sybase site, there is useful infor about the matter.
Good Luck,
Alessandro Barbieri
"mahesh" <mahesh.shah@codecindia.com> wrote in message
new...
Powerbuilder 6.5 & SQL-server 6.5 <> 7.0Hi everyone,
I'm using PB 6.5 with SQS 6.5
Everything is normal until I port the program build in this environment to
a similar environment with the only difference that the database is SQS 7.0
This database is slightly different - in some tables, the fields are larger
than in the SQS 6.5 database (but the same type - char).
When the program retrieves rows in that environment I get the error message
'Data conversion resulted in overflow ...'
I have several other environments with sqs 6.5 with the same difference
(larger fields) where the program doesn't rep...
Error Connection To MS SQL Server 7.0 From PB 6.5.1Dear everyone:
I have Microsoft Backoffice SmallBusiness 4.5 Chinese Edition. The software
suite includes MS SQL Server 7.0. But I can not find Client ODBC Driver For
MS SQL Server 7.0 in it. My workstation OS is Windows 98 Chinese Edition.
In PB 6.5.1, when I use MSS MS SQL Server 6.x interface, I can connect to
the database in the backend server. But when I use SQL Server driver in
ODBC, I got error message. The error message is chinese. But I think the
english error message maybe like "Program Type Beyond".
I want to know how to solve it or how to get ODBC driver for M...
Powerbuilder 6.5.1 connecting to SQL Server 2000 using ODBC Dsn
Can anyone help in connecting by Powerbuilder 6.5.1
application talking to sql 2000 database.
Our applications has a ini file which includes the following
details
[Database]
DBMS=MSS Microsoft SQL Server 6.x
ServerName=TestServer
AutoCommit=true
Database=pubs
Lock=RL
In case of ODBC dsn, what should go in ini other than these.
Please suggest
[Database]
DBMS=ODBC
AutoCommit=true
Database=pubs
Lock=RL
In powerbuilder the profile is created using odbc dsn as
the datasource
The connection is successful in Powerbuilder IDE. But when
I launch the application, I ge...
Powerbuilder 6.5.1 connecting to SQL Server 2000 using ODBC DsnCan anyone help in connecting by Powerbuilder 6.5.1
application talking to sql 2000 database.
Our applications has a ini file which includes the following
details
[Database]
DBMS=MSS Microsoft SQL Server 6.x
ServerName=TestServer
AutoCommit=true
Database=pubs
Lock=RL
In case of ODBC dsn, what should go in ini other than these.
Please suggest
[Database]
DBMS=ODBC
AutoCommit=true
Database=pubs
Lock=RL
In powerbuilder the profile is created using odbc dsn as
the datasource
The connection is successful in Powerbuilder IDE. But when
I launch the application, I get ...
Error Connection To MS SQL Server 7.0 From PB 6.5.1Dear everyone:
I have Microsoft Backoffice SmallBusiness 4.5 Chinese Edition. The software
suite includes MS SQL Server 7.0. But I can not find Client ODBC Driver For
MS SQL Server 7.0 in it. My workstation OS is Windows 98 Chinese Edition.
In PB 6.5.1, when I use MSS MS SQL Server 6.x interface, I can connect to
the database in the backend server. But when I use SQL Server driver in
ODBC, I got error message. The error message is chinese. But I think the
english error message maybe like "Program Type Beyond".
I want to know how to solve it or how to get ODBC driver for M...
PB 7.0.1
Hi,
I just found a solution for correcting the memory leak in 7.0.1, when
connecting to MS SQL Server 6.5. May be this is already fixed in the latest
releases. I just want to share this in case it's useful to any of you guys.
When you connect to the MS SQL Server 6.5 database, be sure to have
atleast something in your DBParm attribute of the DBProfile (or SQLCA
transaction object at runtime). For example (SQLCA.DBParm =
"AppName='IRIS',Host='ZNF9'"). In development time in the DBProfile dialog
under "Network" tabpage Enter something i...
Porting Ms Sql Server 6.5 Database to Ms Sql Server 7.0Hi,
We have developed a product using PowerBuilder7.0, Ms Sql Server 6.5 and
connecting them using powerbuilder native driver. Now we are thinking of
porting Ms Sql Server 6.5 database to Ms Sql Server 7.0.As we feel, we could
achive new features of Sql server 7.0.e.g row level locking.
Actually i want to know, what things i have to do.e.g what sort of
connection i have to use? what new features i will able to use?.will Stored
procedures work properly.
Is there anyting i have to chang in my application(at front end)e.g
datawindows or any embeded sql, external functions.
Should i po...
Porting Ms Sql Server 6.5 database to Ms Sql Server 7.0Hi,
We have developed a product using PowerBuilder7.0, Ms Sql Server 6.5 and
connecting them using powerbuilder native driver. Now we are thinking of
porting Ms Sql Server 6.5 database to Ms Sql Server 7.0.As we feel, we could
achive new features of Sql server 7.0.e.g row level locking.
Actually i want to know, what things i have to do.e.g what sort of
connection i have to use? what new features i will able to use?.will Stored
procedures work properly.
Is there anyting i have to chang in my application(at front end)e.g
datawindows or any embeded sql, external functions.
Should i po...
Calling a MS-SQL-Server 6.5 StoredProcedure from PowerBuilder 6.0Does anyone know if there is a difference from PB 5.0 to PB 6.0 in the
native MSS SQL-Server driver by calling StoredProcedures with OUTPUT
arguments.
I do have the following problem:
- I've got a StoredProcedures with a char, varchar(50) or even with a
datetime OUTPUT argument.
- In PowerBuilder I do:
DECLARE sp_test PROCEDURE FOR schsp_test_char
@psReturn = :sReturn OUTPUT
USING SQLCA;
EXECUTE sp_test;
FETCH sp_test into :sReturn;
CLOSE sp_test;
- If I execute this statement I get the following error:
Implicit conversion from datatype 'varch...
Powerbuilder 5.0/7.0 and MS SQL 7.0 Performance issuesWe recently converted our app from Powerbuilder 5.0 to PB 7.0 -- the app in
PB 7.0 definitely runs slower on the client PC's than it did in PB 5.0.
Now we are migrating the database from MS SQL 6.5 to 7.0 SP2. We
successfully converted the databases in a testing environment, but now the
app runs terribly slow! I don't think it's a hardware issue -- the test box
is a Compaq 8500 quad Xeon 500 w/1GB Ram. We experimented running the app
as a PB 5.0 app against MS SQL 7.0 and the problem is the same. When we
execute SQL directly against the DB outside of PB, we see no perf...