• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PowerBuilder application connectivity to MS SQL Server through ODBC without DNS

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PowerBuilder application connectivity to MS SQL Server through ODBC without DNS

  1. How-to
0
Votes
Undo
  1. Andrew John
    Andrew John
  2. PowerBuilder
  3. Wednesday, 9 October 2024 18:28 PM UTC

1) My PowerBuilderapplication crashing whenever user leaves it idle for sometime, this started happening after SQL Transaction object DBMS changed from MSS to MS Native Client, what could be the reason?
2) Which is the preferred connecivity for PowerBuilder2022 R3 app connecting to MS SQL Server 2016/2022, is it ODBC or OLEDB?

3) Can we use ODBC DBMS in PowerBuilder transaction object to connect to MS SQL server without creating an ODBC Datasource on each user's machine?

 

  1. ODBC
  2. OLEDB
  3. PowerBuilder
  4. SQL Server
Opensheet() fails with Frame ribbon present
Dynamically referencing menu items
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 9 October 2024 19:39 PM UTC
  2. PowerBuilder
  3. # 1

Hi Andrew;

1) This could be because your DB connection is now timing out. I would check with your DBA Team to see what related information might be in the SS logs around this issue.

2) MS's recommendation for SS 2019 & higher releases is the MSOLEDBSQL db client.

3) Yes you can. That is called a DSN-less connection.

The following is for PG but the technique for SS would be similar ...

FYI: https://community.appeon.com/index.php/qna/q-a/dsn-less-connection-postgresql-solved

HTH

Regards ... Chris

Comment
There are no comments made yet.
Arnd Schmidt
Arnd Schmidt Accepted Answer Pending Moderation
  1. Wednesday, 9 October 2024 19:31 PM UTC
  2. PowerBuilder
  3. # 2

Here you go.

https://www.connectionstrings.com/sql-server/

Afaik Appeon recommends MS OLEDB SQL Server.

hth

Arnd

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 9 October 2024 21:04 PM UTC
Correct, and not to be confused with the legacy OLE DB driver. It is the new one that Microsoft has created to replace SQL Server Native Client interface, and on Microsoft website (see #3) it is classified as "recommended": https://learn.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver16
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.