Discussions tagged SQL Server
Comparison of methods accessing SQL Server from PowerBuilder
- Advice
- Last updated 1 month ago
- Roland Mühlberger replied 1 month ago
Dear PowerBuider Programmers,
this might emerge as a philosophical question, but I still hope to get some answers:
PowerBuilder allows many different ways to access Microsoft SQL Server databases from classic (client/server) PB windows applications...
Powebuilder ans SQl server compatibility
- Advice
- Last updated 2 months ago
- Armeen Mazda @Appeon replied 2 months ago
Hello , we have applications written in PB 12.5 with SQl 2008R2 Databases. We want to udgrade to SQl 2012 and then to 2016 or 2017. Which version of PB is compatible with this version of Sql ?...
SNC (SQL Native Client), db compatibility level and datetime field in PK
- Issue
- Last updated 3 months ago
- John Fauss replied 3 months ago
Hello,
We have discovered the following: using SNC (SQL Native Client, provider SQLNCLI11 of course), so when a table has datetime column in primary key and database compatibility level is set to, for example, 130 (SQL Server 2016), datawindow based...
We have a PB 2019 R2 application connecting to a SQL Server 2016 database using the old SQL Server driver (sqlsrv32.dll). The OS is Windows 10 Enterprise. The connection is scripted as follows:
SQLCA.DBMS = lsODBCTrace + "ODBC"SQLCA.LogId = ls_...
Alternate Characters in dynamic menu
- Issue
- Last updated 4 months ago
- Miguel Leeuwe replied 4 months ago
We have an intermittent issue where an alternate character set displays in a menu that is built dynamically. The application is using PB 2019 R2 build 2353 and we connecting to a SQL Server 2016 database using SQL Server Native Client. When the ap...
SQL server connection and SQLCA.DBMS / SQLCA.DBParm
- How-to
- Last updated 5 months ago
- John Fauss replied 3 months ago
Hi.
I have struggled with getting the SQLCA properties set up correct to be able to have my users connect to data base with single sign-on/trusted connection. I'm on MS SQL Server.
The problem boiled down to using correct value for SQLCA.DBMS. Than...
Tracing Powerbuilder at runtime
- Resolved
- How-to
- Last updated 5 months ago
- Jonathan Meltzer replied 5 months ago
It used to be that you could put "TRACE SNC" into the DBMS field in an ini file, and that would work to start a trace going when the application was launched. However, when I do that in PB 2019, I get "DBMS TRACE SNC is not supported in your install...
How to install the "Microsoft OLE DB Driver for SQL Server"
- How-to
- Last updated 6 months ago
- Ken Guo @Appeon replied 6 months ago
Hi,
How do I the easiest way install the new "Microsoft OLE DB Driver for SQL Server"
Would it be enough to simply copy the single dll (msoledbsql.dll) into ../system32 (or the 32bit version into SysWOW64 for 32 bit pb apps) ?
This link explains t...
PB 2019 R2 - recommended database interface to connect to SQL Server 2016
- How-to
- Last updated 7 months ago
- Armeen Mazda @Appeon replied 7 months ago
Hi all my fellow PB entusiasts :-)
What PowerBuilder database interface (oledb,odbc, etc..) do you recommend to use to connect realiably to SQL Server from a classic windows PowerBuilder application.
I'm running up to 50 instances of the same ...
Infomaker Error Connecting to SQL Server
- Resolved
- Advice
- Last updated 8 months ago
- Keeley Stalnaker replied 8 months ago
Hi,
I have a couple Infomaker reports that I've converted from Oracle to SQL Server. I am using SNC SQL Native Client as the connection type for both and have deployed the EXEs to my users' machines. The EXEs both work fine for me on my computer and...
My application currently uses the following to set a variable for use by a MS SQL Sever 2014 database trigger. This does not work in PowerServer. Is there a workaround of some variety?
ls_SQL = "Declare @TheUser VARCHAR(128) SET @TheUser='" + ...
SELECTBLOB with ODBC SQL driver and application roles
- Issue
- Last updated 9 months ago
- Chris Pollach @Appeon replied 9 months ago
PB 2019 R2 Build 2279
We have a problem using application roles with ODBC driver for SQL Server and the SELECTBLOB function:
First we connect to the sql database using "ODBC Driver 17 for SQL Server" (or 13), then we activate application role by ex...
highest version of MS SQL Server officially supported by PB 2019
- Resolved
- Issue
- Last updated 11 months ago
- Michael Kramer replied 11 months ago
Which highest version of MS SQL Server is officially supported by PB 2019 / PB 2019 R2?
Anyone use PB 2019 with SQL 2019 ? (which driver do you use ~ OLE DB / Native driver ?)
Thanks
...
RPC error "Can not get parameters of procedure"
- Resolved
- Issue
- Last updated 1 year ago
- Ken Guo @Appeon replied 1 year ago
As a workaround for the problem with embedded SQL calling a stored procedure with an OUTPUT parameter (which I reported earlier this week), I used a remote procedure call. I am using PB19 on W10, SQLNCLI11 and SQL Server 2016.
The remote procedure c...
PB 2019 Execute SQL Server Stored Procedure with OUTPUT parameter
- Resolved
- Issue
- Last updated 1 year ago
- Linda Kelty (Dudzic) replied 1 year ago
I'm in the process of migrating our PB 12.5.2 applications to PB19. I'm using the SQLNCLI11 provider. Have just run into the following error upon executing a stored procedure.
SQLDBCode 179SQLErrText:SQLSTATE = 42000Microsoft SQL Server Native Clien...
SQLOLEDB to MSOLEDBSQL datetime parameter issue
- Issue
- Last updated 1 year ago
- Ken Guo @Appeon replied 1 year ago
PB 19 Build 2082
SQL SERVER 2017
Upgrading our driver from SQLOLEDB to MSOLEDBSQL and now get issues w/ SQL's DBPARAMBINDINFO.
PROBLEM:
MSOLEDBSQL conflicts w/ the Now() function in that the driver only wants 3 milliseconds instead of No...
MS SQL Server Row Changed Error on datetime column
- Issue
- Last updated 1 year ago
- FILIBERTO SOSA replied 6 months ago
We are updating a MS SQL Server Database using a datawindow with Modified Columns used as the Update Criteria. We are always getting a failure "Row changed between retrieve and Update" (PB 2017 R3)
A datetime column in the database seems to be the...
Hi Guys
I've a table "flusso_ccic" and a datastore in PB2019 R2 on it
No column identity, just the key from some columns
I converted to a Model on Snap Develop R2 and Retrieve works fine, but If I try to Run a Create from a rest Client the query f...
Slow query performance using ADO.NET and SQL Server 2016
- Issue
- Last updated 1 year ago
- Miguel Leeuwe replied 1 year ago
Issue: Extremely slow query performance using ADO.NET connection to a SQL Server 2016 database using Appeon PB v2019 b2082.
Querying ~700 rows from SQL Server 2016 DB into a grid datawindow which is taking approx 2-3 minutes to complete (from compil...
PB Migrating from DB2 v11.1.1.1 to SQL Server 2016
- How-to
- Last updated 1 year ago
- mike S replied 1 year ago
We are thinking of migrating our PB Classic application (2017 build 1769) from DB2 v11 to Microsoft SQL Server 2016. Currently we connect to DB2 via ODBC. Any suggestions on what to do? Are they any tools that can help? Will native connection be bet...
- Page :
- 1