1. skfaksfj ksfajskfd
  2. PowerBuilder
  3. Wednesday, 30 May 2018 01:47 AM

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 @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 30 May 2018 08:32 AM
  2. PowerBuilder
  3. # 1
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 11:08 AM
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 30 May 2018 03:11 AM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

Have you tried setting up a 64bit ODBC profile?

Comment
Yes, I have 

  1. skfaksfj ksfajskfd
  2. Wednesday, 30 May 2018 11:08 AM
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.