• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to connect a SQL Anywhere database (using windows integrated login authentication) with PB17?

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

Resolved How to connect a SQL Anywhere database (using windows integrated login authentication) with PB17?

  1. How-to
0
Votes
Undo
  1. DIPANJAN DUTTA
    DIPANJAN DUTTA
  2. PowerBuilder
  3. Tuesday, 3 March 2020 11:19 AM UTC

Hi Experts,

I am using PB 17.3 and SQL Anywhere 17.

I can successfully connect my database using windows integrated login authentication from Interactive SQL.

Here is the screenshot,

 

Now my question is their any process to connect the same database using windows integrated login authentication from PB?

What is the syntax to connect database using windows integrated login from PB without any user ID and password?

 

Thanks and Regards,

Dipanjan

 

 

 

DLL accesed in runtime, not from PB IDE
How to detect possible Integer overflow
Accepted Answer
DIPANJAN DUTTA
DIPANJAN DUTTA Accepted Answer Pending Moderation
  1. Wednesday, 4 March 2020 05:49 AM UTC
  2. PowerBuilder
  3. # Permalink

Its resolved by the the following connection string 

SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='Driver={SQL Anywhere 17};server=localdbserver;db=testdb;'"

 

Comment
Chris Keating
  1. Chris Keating
  2. Wednesday, 4 March 2020 19:01 PM UTC
SQLCA.DBParm = "ConnectString='Driver={SQL Anywhere 17};server=localdbserver;dbn=testdb;int=yes;'"
  1. Helpful
There are no comments made yet.
Responses (4)
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Tuesday, 3 March 2020 11:25 AM UTC
  2. PowerBuilder
  3. # 1

If I remember correctly from long time ago you simply provide UID = "" and PWD = "" (both empty).

HTH /Michael

Comment
There are no comments made yet.
Chris Keating
Chris Keating Accepted Answer Pending Moderation
  1. Tuesday, 3 March 2020 12:14 PM UTC
  2. PowerBuilder
  3. # 2

You have to set the connection parameter INT=YES. If you are using a DSN, there is an equivalent Authentication dropdown on the Login tab that is used in DBISQL (which effectively adds INT=yes to the connection parameters).

Comment
There are no comments made yet.
DIPANJAN DUTTA
DIPANJAN DUTTA Accepted Answer Pending Moderation
  1. Tuesday, 3 March 2020 12:50 PM UTC
  2. PowerBuilder
  3. # 3

Thanks for your reply Chris...

I am not using any DSN, is it possible in that case? if yes..Please provide the connection parameter Syntax.

Comment
Chris Keating
  1. Chris Keating
  2. Tuesday, 3 March 2020 16:48 PM UTC
What interface are you using to connect to SQL Anywhere? In any event, INT=YES applies to SQL Anywhere based connections -- I am not sure how that would work with a jCONNECT based connection but will work the SQL Anywhere JDBC driver.
  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.