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