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

Resolved MSOLEDBSQL connection

  1. How-to
0
Votes
Undo
  1. Robert Holoubek
    Robert Holoubek
  2. PowerBuilder
  3. Thursday, 1 November 2018 10:00 AM UTC

Hello,

just a question. Is there any plan for PB to natively support MSOLEDBSQL announced

https://blogs.msdn.microsoft.com/sqlnativeclient/2017/10/06/announcing-the-new-release-of-ole-db-driver-for-sql-server/

and downloadable using this link?

https://www.microsoft.com/en-us/download/details.aspx?id=56730

 

I tried to set up a database profile in PB 2017 R3 and it's possible to connect successfully. However the connected database is always default 'master'. There is no way (or I maybe couldn't find it out) how to specify a database.

Specifying Database='xyz' or Initial Catalog='xyz' in Extended properties editbox of Database profile doesn't help.

 

I was finally able to connect using udl file specified in DataLink filename but I would rather connect directly if possible. 

 

Thank you

Robert

 

 

 

Attachments (1)
profile.png profile.png
Turn off Printing
Save JSON files with UTF8 or EncodingAnsi encoding
Accepted Answer
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 2 November 2018 00:22 AM UTC
  2. PowerBuilder
  3. # Permalink

I just tried it and it worked. I have SQL Server Express 2017 on my laptop and was able to connect to it from PowerBuilder 10.5 without any issues.

 

Attachments (1)
dbprofile.png dbprofile.png
Comment
There are no comments made yet.
Responses (2)
Robert Holoubek
Robert Holoubek Accepted Answer Pending Moderation
  1. Friday, 2 November 2018 16:44 PM UTC
  2. PowerBuilder
  3. # 1

Yes, you're right - it works fine with Database=xyz in Extended properties in Database profile.

I'm not sure what I had wrong when I tried that. Perhaps extra aposthrophes around database name..

Thank you

 

 

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.