• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How do I connect to a SQL Server in Powerbuilder 2017 with ADO.NET?

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

Resolved How do I connect to a SQL Server in Powerbuilder 2017 with ADO.NET?

  1. Issue
0
Votes
Undo
  1. skfaksfj ksfajskfd
    skfaksfj ksfajskfd
  2. PowerBuilder
  3. Wednesday, 30 May 2018 01:47 AM UTC

Hi there,I used to use Powerbuilder 12.5 classic ,I'm trying to use PB 2017,I have 2 questions

 

#1 How do I connect to a SQL Server  with ADO.NET within Powerbuilder 2017,cuz 64 bits application is no more support OLE DB connection within PB 2017

#2 Does PB 2017 support SQL server 2000 with ADO.NET?

thanks

  1. ADO.NET
Orca Script command to get the latest files in PBL...
Command line for pbc170
Responses (2)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 30 May 2018 03:11 AM UTC
  2. PowerBuilder
  3. # 1

Have you tried setting up a 64bit ODBC profile?

Comment
skfaksfj ksfajskfd
  1. skfaksfj ksfajskfd
  2. Wednesday, 30 May 2018 11:08 AM UTC
Yes, I have 

  1. Helpful
There are no comments made yet.
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 30 May 2018 08:32 AM UTC
  2. PowerBuilder
  3. # 2

Hi,

#1. You can use the following ADO.Net sample code to connect to a SQL Server database.

// Profile sqlole_ado

SQLCA.DBMS = "ADO.Net"

SQLCA.LogPass = "sql"

SQLCA.LogId = "dba"

SQLCA.AutoCommit = False

SQLCA.DBParm = "Namespace='System.Data.OleDb',Provider='SQLOLEDB',DataSource='192.0.0.15',Database='dev2'"

Connect using SQLCA;

 

// Profile sqlclient_ado

SQLCA.DBMS = "ADO.Net"

SQLCA.LogPass = "sql"

SQLCA.LogId = "dba"

SQLCA.AutoCommit = False

SQLCA.DBParm = "Namespace='System.Data.SqlClient',DataSource='192.0.0.15',Database='dev2'"

Connect using SQLCA;

 

#2. PB 2017 support SQL server 2000 with ADO.NET. But we suggest that you use a higher version SQL Server in a business project, such as SQL Server 2005 or above.

 

Best Regards,

Ken

 

 

Comment
skfaksfj ksfajskfd
  1. skfaksfj ksfajskfd
  2. Wednesday, 30 May 2018 11:08 AM UTC
Thank you very much
  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.