1. Raymond McCague
  2. InfoMaker
  3. Tuesday, 10 December 2024 22:20 PM UTC

We are using infomaker.

We use to connect to InfoMaker using SQL Server Native client or what also is called: SNC SQL Native Client.

 Like:

 

The Server field had: Server\Instance

The Database: had the name of the databases.

 

Now we want to connect using OLE Microsoft OLE DB

The Data Source has: Server\Instance

Not sure what to put on this screen.

We want to connect using Windows authentication.

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 10 December 2024 22:39 PM UTC
  2. InfoMaker
  3. # 1

Hi Raymond;

   FWIW: Microsoft deprecated the SNC DB Client in the SS 2016 time frame but then replaced it with the new MSOLEDBSQL SS DB client driver. Also going forward, MS has stated that the MSOLEDBSQL DB Client driver will be their path forward for all new SS releases (2019 & higher). Newer IM versions now support this MSOLEDBSQL native SS DB Client driver. I would recommend that you look at using MSOLEDBSQL instead of OLE DB (just my $0.02).  Food for thought.  HTH

Regards .. Chris

Comment
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 11 December 2024 15:16 PM UTC
  2. InfoMaker
  3. # 2

The old 'Microsoft OLE DB' driver was deprecated by Microsoft in 2012. Then in 2017 they brought it back as 'OLE DB Driver for SQL Server'.

 

You can get the Microsoft driver here:

https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16

As Chris said, use 'MSOLEDBSQL SQL Server' in PowerBuilder.

Comment
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.