Skip to Content
0
Former Member
Aug 17, 2016 at 07:28 PM

12.5 ADO.Net DB Connection Problem

505 Views

I am trying to get a PowerBuilder 12.5 application to connect to MS SQL Server 2014 using ADO.Net.

When running the app from inside PowerBuilder, all is well. When running the app using the exe, I get the following error:

Could not connect to the database.

SQL error code: 999

SQL error message: The driver's namespace is not set.

Sybase.PowerBuilder.DbExt.dll and Sybase.PowerBuilder.Db.dll have been copied into various file folders, so I don't think accessing them is the problem.

This is the DBParm I'm using:

sqlca.DBParm = "Namespace='System.Data.SqlClient', DataSource='" + sqlca.ServerName + "', Database='" + sqlca.Database + "', ProviderString = 'MultipleActiveResultSets=False', CommandTimeOut=900"

Thanks in advance,

Greg