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

Resolved PB 2022 R3 SQL connection string

  1. How-to
0
Votes
Undo
  1. D Aggelis
    D Aggelis
  2. PowerBuilder
  3. Friday, 2 August 2024 05:59 AM UTC

Hi,

we use PB 2022 to connect to MS SQL. We use the following connection info

DBMS=ADO.NET
ServerName=atlas
DBParm=Namespace='System.Data.OleDb',DataSource='atlas',DisableBind=1,DelimitIdentifier='NO',NCharBind=1,trimspaces=1,CommandTimeout=3600,TrustedConnection=0,Provider='SQLOLEDB'"
Prompt=0

Now we are trying to evaluate PB 2022 R3 and the above parm is unable to connect.

Any suggestions;

 

 

ADO.NET vs. MSOLEDBSQL
How To Manually Create the PB Extended Attribute S...
Responses (3)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 2 August 2024 09:32 AM UTC
  2. PowerBuilder
  3. # 1

See https://community.appeon.com/index.php/qna/q-a/ado-net-vs-msoledbsql

Maybe it has some useful information for you.

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 2 August 2024 07:48 AM UTC
  2. PowerBuilder
  3. # 2

Have you tried setting "TrustedConnection" to 1 instead of 0 ?

Also, why use ADO .Net, there's more recommended drivers for later PB versions.

Try creating a DB profile in the IDE. If that works, go to the Preview tab and copy the values.

regards.

Comment
There are no comments made yet.
D Aggelis
D Aggelis Accepted Answer Pending Moderation
  1. Friday, 2 August 2024 08:39 AM UTC
  2. PowerBuilder
  3. # 3

I have the following options in IDE. What is the recommended alternative to ADO.NET; (SQL server is 2022)

 

Comment
Andreas Mykonios
  1. Andreas Mykonios
  2. Friday, 2 August 2024 08:56 AM UTC
Hi.

Try using MSOLEDBSQL for SQL Server.

Andreas.
  1. Helpful 1
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 2 August 2024 09:18 AM UTC
if your "atlas_2024" connection works, then as I've said before: Select that profile, click on "Edit" and go to the "Preview" tab. Then compare it with what you do in your code.

Preferably use the driver suggested by Andreas though.
  1. Helpful 2
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.