Hi, Billy -

First, can you connect to your SQL Server database from the Server Management Studio (SMSS)? I assume you can since you included a partial screen shot of the SQL Server properties window. Version 15 of SQL Server is commonly referred to as SQL Server 2019.

If you don't have SMSS working already, I suggest you start there and get that operational first. I'm sure there are several helpful web sites and tips on the internet. Once that is working, then concentrate on getting a Database Profile set up in PowerBuilder.

Here are the settings I use to connect to the AdventureWorksLT2019 database that runs on a local instance of SQL Server Express 2019 on my home PC from PowerBuilder:

SQLCA.DBMS = "MSO"
SQLCA.ServerName = "*WorkStationNameHere*\SQLEXPRESS2019"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='AdventureWorksLT2019',TrustedConnection=1,TrimSpaces=1,DateFormat='mm/dd/yyyy',DateTimeFormat='mm/dd/yyyy hh:mm:ss',TimeFormat='hh:mm:ss'"

Depending on which version of PowerBuilder you are using (you neglected to state this important piece of information in your question), you may not be able to use the MSO (MSOLEDBSQL) database driver.

Substitute the name of the server where SQL Server is running for "WorkStationNameHere". The instance name of "\SQLEXPRESS2019" may be different for you, also.

Substitute the database name for 'AdventureWorksLT2019 in the DBParm property with your database's name.

On my home system (and at work), I use Windows Authentication (my Windows login credentials) to connect to SQL Server instead of setting up a SQL Server login and user... That is what TrustedConnection=1 specifies. That simplifies the connection steps, but that setting may not be workable for your situation.

The other DBParm settings (TrimSpace, DateFormat, DateTimeFormat, and TimeFormat) are what I typically use in PB apps, but you can use other values based on your needs. There are a myriad of other possible DBParm settings that are valid for the MSO driver for SQL Server.

The following URL takes you to the online documentation for all of the DBParm settings (for all databases, not just SQL Server):

    https://docs.appeon.com/pb2022r2/connection_reference/Database_Parameters.html

The next URL is the online documentation for using SQL Server Native Database Interfaces, such as MSO.

    https://docs.appeon.com/pb2022r2/connecting_to_your_database/Using_Microsoft_SQL_Server.html

Best regards, John

What version of SQL Server are you trying to connect to?

Regards,
Francisco

"...get errors connecting .."

Which errors when trying to connect how, with what parameters?

You have to be more specific if you want any answers, there's no magic here.

Hi.  Yes, I have been using SSMS for the conversion no problem.  It was PB I was having an issue with.  I finally got it to work using the below.

Thanks for your help