1. skfaksfj ksfajskfd
  2. PowerBuilder
  3. Wednesday, 30 May 2018

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

Ken Guo Accepted Answer Pending Moderation
0
Votes
Undo

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
Thank you very much
  1. skfaksfj ksfajskfd
  2. Wednesday, 30 May 2018
There are no comments made yet.
  1. Wednesday, 30 May 2018
  2. PowerBuilder
  3. # 1
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

Have you tried setting up a 64bit ODBC profile?

Comment
Yes, I have 

  1. skfaksfj ksfajskfd
  2. Wednesday, 30 May 2018
There are no comments made yet.
  1. Wednesday, 30 May 2018
  2. PowerBuilder
  3. # 2
  • 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. Learn More