• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Database painter very slow opening/modifying OLE Microsoft OLE DB profiles

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

Resolved Database painter very slow opening/modifying OLE Microsoft OLE DB profiles

  1. Advice
0
Votes
Undo
  1. Hugo Moors
    Hugo Moors
  2. PowerBuilder
  3. Monday, 24 October 2022 10:12 AM UTC

Does anyone else have this?

It takes more than 1 minute (timed it) to open a DB profile in OLE Microsoft OLE DB

Also creating a profile as soon as I choose SQLOLEDB as a Provider every stops for more than a minute.

I've tried changing the order of data entry, filling out all other fields (data source, database, user, pwd) before selecting SQLOLEDB as a Provider, it doesn't help, PB hangs for at least 1 minute.

 

With MSOLEDBSQL SQL Server profiles and other profiles I do not have this issue.

Once the profile is created there is no lag opening or using the database, just the profile creation/modification.

 

It's probably a setting somewhere that I'm missing but I have this on multiple machines and since at least PB version 2019

Mixing Pro and CloudPro licenses
PowerBuilder dealer in Brazil
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 24 October 2022 12:14 PM UTC
  2. PowerBuilder
  3. # 1

Hi Hugo;

  FWIW:  I have the same issue on my W10 & W11 test machines. This has been that way in PB2019, 2021 & now 2022.  However, all the other SS DB Client connection options are super fast. I never use OLEDB for SS, so I never think about why it's so slow.

Regards .... Chris 

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Monday, 24 October 2022 13:40 PM UTC
  2. PowerBuilder
  3. # 2

It seems to be related to the system being 'helpful' and finding all the servers for you.

I wish it would not do that. If you don't know the server name you should not connecting to it.

Comment
Hugo Moors
  1. Hugo Moors
  2. Monday, 24 October 2022 13:47 PM UTC
I was thinking it was something like that.

Should be an option because it's not finding any servers anyway as they are not on "normal" ports in my company
  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.