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.
...
Connect MS-SQL 7.0 in PowerBuilder 7.0In PowerBuilder 6.5, I can connect MS-SQL 6.5 directly not using ODBC, but
in PowerBuilder 7.0, how can I connect MS-SQL 7.0 directly ?
Please post to the powersoft.public.powerbuilder newsgroups
This is dedicated to PB issues when used within Jaguar
Masun wrote:
> In PowerBuilder 6.5, I can connect MS-SQL 6.5 directly not using ODBC, but
> in PowerBuilder 7.0, how can I connect MS-SQL 7.0 directly ?
...
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...
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...
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...
How to connect to Ms Sqlserver 7.0 with powerbuilder 6.5 I want to connect to Ms Sqlserver 7.0 with powerbuilder 6.5.
Would you please tell me where I can download the native database driver?
Thank you very much!
Sincerely,
Fang Jing
fangjing@telekbird.com.cn
I have not been able to find a native driver anywhere. We are having no
real problems using the SQL 6.5 drivers with PB 6.5.1. You have to upgrade
to PB 6.5.1 or there are some issues. (Like you can't paint a DW off of a
stored proc) Hope this helps....Paul
Fang Jing <fangjing@telekbird.com.cn> wrote in message
news:tmKLHsSR$GA.289@forums.sybase.com...
...
connection problem from PB 6.5 and MS SQL 7.0I experience this problem when trying to connect to MS SQL 7.0 from PB
development Environment from Database painter.
SQLState S1003
Microsoft ODBC Drive Manager PRogram Type out of Range.
Your help much appreciated.
Upgrade to 6.5.1
Syed <syedibrahim@hotmail.com> wrote in message
news:UNYhqTUR$GA.191@forums.sybase.com...
> I experience this problem when trying to connect to MS SQL 7.0 from PB
> development Environment from Database painter.
>
> SQLState S1003
> Microsoft ODBC Drive Manager PRogram Type out of Range.
>
> Your help much appr...
Connecting to MS Sql server 2000 thru PowerBuilder 5.0We're connecting to MS Sql server 6.5 from PowerBuilder 5.0 using a Native
driver. We want to upgrade to MS Sql server 2000.
Does the native driver in PB 5.0 for MS Sql Server 6.5 support MS Sql
server 2000 also ??
If not , whether Sybase provide a native driver to connect MS Sql server
2000 from PB 5.0 ??
Thanks & Regards,
Ravi.
No, neither SQL7 nor SQL2000 is supported from PB5. Some people have got
SQL7 to work (don't know about 2000), but mostly it won't, certainly for us
it wouldn't. The best thing to do is try it and see whether you get
problems w...
Problems to connect a PB 5.04 with MS SQL Server 7.0I possess PB 5.04 and I need to connect with MS SQL Server 7.0 he/she
saw ODBC.
I am using the connection file with the MS SQL server:
SQLSRV32.DLL 3.70.06.23 11/05/1999
ODBC 3.510.3513.0
When I execute the application for PB in Windows 95 it works, but when I
try to execute
by Windows 98 and I give retrieve in any datawindow he/she doesn't
appear the data.
Seemingly the I am supported it connected, mistake didn't come back.
To use sql embeded doesn't also work, coming back garbage.
Thank you,
Francisco Freitas
ODBC 3.x added some new datatypes that older v...
PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL filesPB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files. Compiled
program running on the Win98 without MS SQL 7.0 client application
installed.
I can not get the DB connection by using external ip address like
"202.199.12.12", but for internal ip address "10.4.32.2" which is one of our
intranet ip address, it works well. The error is "unable to find SQL Server
or SQL Server unvaliable". Both of the two ip adresses are associated with
the same DB Server.
Thanks
...
PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files #2PB6.5 Build 444 + MS SQL7.0 + MS SQL 7.0 DB connection DLL files. Compiled
program running on the Win98 without MS SQL 7.0 client application
installed.
I can not get the DB connection by using external ip address like
"202.199.12.12", but for internal ip address "10.4.32.2" which is one of our
intranet ip address, it works well. The error is "unable to find SQL Server
or SQL Server unvaliable".
Thanks
...
Connecting to MS SQL 7.0 in PB 5.0Hi
How do I connect to MS SQL server 7.0 giving the IP address of the server,
instead of the servername in the profile...... ???
Thanx in advance
- Hamsa
You need at least PB6.5.1 to connect to SQL7. Some things will sometimes
work in PB5, but some (including connecting by IP address IIRC) don't work.
S.
--
Simon Caldwell
Get Real Systems Ltd
Holtby Manor, Stamford Bridge Road, York, YO19 5LL
Tel 01904 481999 Fax 01904 481666
Visit us at www.getrealsystems.com
Specialists in e-Procurement and supply chain technology
"Hamsa" <hamsaraj@uiscpl...
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...
Connecting to MS SQL 6.5 through PB 5.0.02I have set up a MS SQL ODBC connection in ODBC Administrator that has
the server name and database name set, the rest is all default. In PB I
make a new database profile called 'MS SQL' and set DBMS to 'ODBC'. In
the 'Select Data Source' window that comes up I select the ODBC
connection I just made on the 'Machine Data Source' tabpage. When I
press OK to connect, PB crashes.
I am running Win NT Server 4.0 and it has the MS SQL database, client
software and PB installed on it. What am I doing wrong?
I've tried all sorts of things like setting ...