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...Connect MS-SQL 7.0 in PowerBuilder 7.0
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 ?
Please post to the powersoft.public.powerbuilder newsgroups
This is dedicated to PB issues when used within Jaguar
> 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 7.0 and My SQL, MSDE database connection
Is it possible to connect My SQL database and Powerbuilder 7.0 Build 10312
application? If so what is the connection parameter?
Also, Is it possible to connect MSDE Database and Powerbuilder 7.0 Build
10312 Application? If so what is the connection parameter for MSDE database?
Is it any ODBC drivers need to be configured for the above said databases
(My SQL and MSDE). Where could I get the ODBC drivers for My SQL database
and MSDE database? also what is the installation procedure?
Is there any special steps need to be followed to configure the My SQL or
MSDE databases w...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...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...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...MS-SQL Server 7 With PowerBuilder 7
I write a SQL statement like this:
SELECT * FROM MATERIAL
Table Material have 120,000 records data.
Execute this Query in SQL Server Query Analyzer.
It's spends about 2 minutes
Execute this Query in PB 7.0 Database painter's ISQL Session
It's spends over 10 minutes.
I used Native drive not used ODBC to connect the MS-SQL 7.0.
My database server have:
Server's CPU x 4
Database Server : MS-SQL Server 7
How can I improve the performance in PowerBuilder?
Thanks for your help!
Depending on your requireme...Connecting to MS Sql server 2000 thru PowerBuilder 5.0
We'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,
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...Connecting to sql server 2000 via ole db in Powerbuilder 7
I'm trying to do a direct connect to sql server 2000 using ole db. I've
got one connectstring in my application (powerbuilder) that is accessing
the database via odbc. I want to access a different database (for security
purposes) using ole db. Is this possible?
Here are my parameters:
sqlca.dbms = ole db
sqlca.database = picard
sqlca.logid = picard
sqlca.logpass = picard
sqlca.servername = picardsqld1
Can someone please help with the syntax on connecting to this database.
It's possible, but oledb in PB7 doesn't work well at all. It's appa...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...Powerbuilder 7 nested SELECT parameter MS SQL Server 2000 error.
I was reviewing a little bit more my problem and I can redefine it as
Powerbuilder 7.0 executing SELECT with a parameter on its WHERE clause,
nested within other SELECT and executed against a MS SQL 2000 database,
gives an error.
data IN ( SELECT
generates an error where SQLCA.SQLCode= -1 AND SQLCA.SQLErrText='SQL...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
...PowerBuilder, connecting to MS SQL Server using MSS native driver: A field which is defined as a varchar (450) is truncated to 255 characters in PowerBuilder
PowerBuilder, connecting to MS SQL Server using MSS native
driver: A field which is defined as a varchar (450) is
truncated to 255 characters in PowerBuilder
I am using Power Builder 7.0 with SQL Server 2000
Database. I created a datawindow using a varchar(450)
field. It is allowing me enter and save 450 characters but
when I retrieved the data it is truncating it to 255
chars. I looked in the database all 450 characters are
there. Why it is truncating the data on retrieve? Please
help me out if anybody knows the solution
Thanks in advance
because the native interface (Micr...