PB 6.5 Connection To MS SQL Server 6.5
We have three servers running MS SQL Server 6.5. PB 5.0 applications (both
PB client apps and PB apps running on the servers at night as part of batch
jobs) have been running on them for a long time. Native drivers are used.
I'm starting to replace these apps with PB 6.5 versions of them.
With respect to two of the servers, I can connect to the databases from all
the new apps - both client PC apps and batch apps. On the third server, I
can connect to the databases using the client PC apps only. When the apps
in the night job run, the CONNECT statement gets the following error
...PB 6.5 AND MS SQL SERVER 6.5
I have recently converted an 16-bit PB5.0 application to PB6.5. This
application goes against a MS SQL SERVER 6.5 database. I have noticed now
that the new application won't release locks on tables when I do an insert
or update. This application has never had explicit commits coded and I
haven't seen soo many locks on tables before until the recent powerbuilder
upgrade. Does anyone have some insight on this situation?
331 W. Wisconsin Ave
Milwaukee, WI 53203
...PB 6.5 and MS SQL Server 6.5 SP5a
We are currently running apps in PB 5.0.04 and PB 6.5 with a MS SQL Server
database, ver 6.5 SP4.
Our DBA wants to apply SP5a to the database. I see many issues regarding a
required update for PB 5.0.04. Fine, we'll deal with that.
Is there any documentation in existence that verifies that PB 6.5 is
compliant with MS SQL Server 6.5 SP5a? Also, does anyone have test results
using the new MS SQL Server ODBC driver ver 3.7?
If its of any help, I couldn't find any hits in the infobase on service pack
5 or ODBC driver 3.7. Either nobody is having problems wit...connect pb10.5 to ms sql server 6.5
I'm getting 'dbms not supported...." trying to connect. Is it
possible to connect pb10 to sql server 6.5?
PB 10 and later dropped support for MSS Native driver. It is still
possible to connect but you will need alternate connectivity options
such as ODBC or OLEDB.
> I'm getting 'dbms not supported...." trying to connect. Is it
> possible to connect pb10 to sql server 6.5?
On Dec 8, 2:01=A0pm, "Chris Keating (Sybase iAnywhere)"
> PB 10 and later dropped support for MSS Nat...PB 6.5 connection to SQL 6.5 problem when 2000 is installed
We have several PB 6.5 applications that connect (native) to Microsoft SQL
Server 6.5. They have been running fine for me until I installed the MS SQL
Server 2000 client tools on my computer. I still have the SQL 6.5 tools
loaded. At some point I had also installed the SQL 7.0 client. I did not
have any problems with my apps after that install, only after the 2000
installation. We uninstalled the SQL 2000 client and reinstalled the 6.5
client, but I am still having problems running the applications. I am
getting an error message that states..."DDE Server Window: myapp.exe -...Connecting to MS SQL 6.5 through PB 5.0.02
I 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 ...BUG!!!! ?? Using Stored Procedure with PB 6.5 and MS SQL Server 6.5.
I have some stored procedures on my DBMS, MS SQL Server 6.5. After upgrading
to PB 6.5 I cannot assign any of my stored procedures to a datawindow. What
the .... is wrong. Is it my installation? Is it PB 6.5? In fact it is
serious as my reports are not running.
Any comments are appreciated.
Maersk Data AS
What is the error you are getting, maybe we could help you then.
Thomas D��r <firstname.lastname@example.org> wrote in article
> I have some stored procedures on my DBMS, MS SQL Server 6.5. After
...Executing a MS SQL server 6.5 procedure with no result sets from PB 6.5...
I have a stored procedure created in MS SQL Server 6.5. The procedure has
4 arguments. The procedure will do some calculations & then finally will
insert some data into a table. That's it. It won't return any resultset (no
select statement). Now I need to execute the procedure from within a PB
application(verion 6.5). Which is te best method for this. Dynamic SQL
Thanks in advance.
In your PB script, declare the procedure :
DECLARE sp_procedure PROCEDURE F...MS SQL 6.5 and PowerBuilder 6.5
I have an application in PB6.5 that interfaces with MSSQL 6.5 database.
I can run this app WITHIN PB to make a connection the database and
retrieve data without a problem, but after I built the EXE file and
trying to run from that EXE file, I get a "-1" as the return code from
the SetTransObject statement. Sample code is like :
lds_datastore = CREATE datastore
lds_datastore.DataObject = "d_test"
li_return = lds_datastore.SetTransObject(SQLCA)
The d_test datawindow object consists of a simple SQL SELECT statement.
Has anyone seen this ...PB 6.5 to MS SQL server 7.0 connectivity
Seem to much discussion on this topic...I desperately need the answer at the
end of the book. We are upgrading to SQL 7 and MUST be live with our PB
6.5 app in 3 weeks.
PowerSoft/Sybase preferred or recommended configuration??
Please respond with any recommendations on:
PB versions / builds
SQL Server client software
Native drivers VS OLEDB VS ODBC etc...
PB support of 7.0 new features: specifically the 8K varchar DataType
...How connect PB 6.5 to MS SQL Server 2000 with ODBC
I need to connect PB 6.5 with MS SQL Server 2000 with a ODBC connection, but
they return this message:
SQLSTATE = S1003
[Microsoft][ODBC Driver Manager] Program type out of range
How i can do it?
Departamento de desarrollo
PB 6.5 is too old as it's ODBC driver handshake is out-of-date compared
to the one provided by Microsoft.
"Keyhelp" <keyhelpNOSPAM@keyhelp(dot)net> wrote in message
> I need to connect PB 6.5 with MS SQL Server 2000 with...PB 6.5 and MS SQL Server 7.0 connectivity
I have a PB 6.5 application running with SQL-Anywhere. I have recently
tried to re-establish the database on Microsoft SQL-SERVER 7.0. I have
loaded the native client-side software to connect to MS 7.0 and was
successful with the connection.
However, when I tried to establish a connection via the PB 6.5 development
environment (DB painter and etc.), I received a "S1003 - Program type out of
range" message from within the PB 6.5 database painter. I didn't receive
the error message when I connected to the database... but only when I tried
to actually do something thru ...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
...Error Connection To MS SQL Server 7.0 From PB 6.5.1
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...