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
...
PB6.5 build 444 + MS SQL 7.0 + native drive connection(TCP/IP)PB6.5 build 444 + MS SQL 7.0 + native drive connection(TCP/IP)
Is it possible to run my EXE on a machine without MS SQL client install on
it? I install a MS SQL client, as my EXE runs well. Then I uninstall the MS
SQL client, it also runs well. But if I run my EXE on a machine which never
has MS SQL client on it, it comes ""unable to find SQL Server or SQL Server
unvaliable" error. I also got DLL files on it.
ntwdblib.dll pbdwe60.dll pbmss60.dll pbvm60.dll
TIA
Powerbuilder cannot go directly to the database. It must communicate to the
database through ...
PB6.5 build 444 + MS SQL 7.0 + native drive connection(TCP/IP)PB6.5 build 444 + MS SQL 7.0 + native drive connection(TCP/IP)
Is it possible to run my EXE on a machine without MS SQL client install on
it? I install a MS SQL client, as my EXE runs well. Then I uninstall the MS
SQL client, it also runs well. But if I run my EXE on a machine which never
has MS SQL client on it, it comes ""unable to find SQL Server or SQL Server
unvaliable" error. I also got DLL files on it.
ntwdblib.dll pbdwe60.dll pbmss60.dll pbvm60.dll
TIA
The PB native driver requires the MSS client. The MS ODBC driver,
however, does not require the c...
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 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...
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...
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...
Connection problem with PowerBuilder 5.0.02 to MS SQL 7Hello,
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,
Bruce
---== Posted via the PFCGuide Web Newsreader ==---
ht...
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.
...
Urgent!!Connecting to MS SQL Server7.0 with PB 5.0.04 on NT4.0Hi!
This is urgent!!
Does anyone know how to connect MS SQL Server 7.0 from PB 5.0.04. I have
connected to MSS 7.0 with ODBC 3.70 (come with MSS7.0) from PB5.0.04,
but the embedded SQL statements in my program retrieve all kinds of
gabbish to me. I believe there is something wrong with the ODBC drivers
setting, how should I config the ODBC drivers ?
I have tried to use MS SQL Server 6.5 native drivers to connect to 7.0 ,
but I 've got the error message, something like 'Datatype not supported'
? Why is that ?
Cherry
The problem, at least with ODBC 3.x, is that ...
Problems connecting the MS SQL 6.5 after migrating from PB6.5 to PB7.0After migrating my PFC based PB6.5 application to PB7.0 application, I
cannot connect the deployed EXE program to MS SQL 6.5. I can connect to the
database before the migration. If I run the application in PW7.0, I can
connect to the MS SQL 6.5 database without any problem. However it does not
work if I run the deployed program. By changing the INI file, I can connect
to Sybase SQL 11.5 database but not the MS SQL 6.5. Please advise if anyone
has faced the same problem and how to solve this problem.
I forgot to state that I am using native drive to connect the the MS SQL 6.5
...
Connection to MS SQL Server 7.0 with PB application built in 5.5.04FYI....
I am in the process of upgrade an application database from MS SQL
server 6.0 to 7.0 and I would like to know if there is a driver download
that I can get so that I don't have to also upgrade the application as
well.
Is a database driver download available? It there is, where do I get it
from?
Thanks for the help.
(My gut feeling is that the application will also have to be upgrade for the
new native driver... Please say I am wrong)
.......Shane
Hi Shane,
MS 7 does not have a native driver...
PB6.5 and MS SQL7.0 connection problemsI have PowerBuilder 6.5 build 444 and a MS SQL 7.0 server (with SP 3). I
have loaded the latest MDAC from Microsoft and am running on a Windows 2000
machine. I am receiving 2 error messages when I try to connect to my
database. The first message is: "Unknown token received from SQL server".
The second message is: "Invalid Descriptor Index". Do you know of a way to
help me fix this problem?
Thank You
...
PB6.5 connect MS SQL 2005 using native driver (DBMS=MSS (Msoft) SQL Server 6.0)Is it possible PB 6.5 using "DBMS=MSS (Msoft) SQL Server 6.0" to connect MS
SQL 2005?
The existing application is PB6.5 using "DBMS=MSS (Msoft) SQL Server 6.0" to
connect MS SQL 2000. It is work fine.
John
Hi John;
AFAIK .. it should work. The only restrictions would be
1) PB 6.5 will not understand SS2005 functionality. You will be restricted
to the SS 6.0 (as you are today with SS2000) feature set.
2) The MSS setting connects using the NTDBLIB.dll from MS. I do not believe
that this is supplied with SS2005. So you will need to install the SS20...