12.5 ADO.Net DB Connection Problem

[Former Member]

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

[Former Member · Accepted solution]

Hi Greg;

  Have you ...

1) Installed the SS client?

2) Registered the Sybase.PowerBuilder.xxxxx.dll's in the GAC?

3) Is the ADO driver present (System.Data.SqlClient

) & registered in the GAC?

FYI: https://support.microsoft.com/en-ca/kb/307283

Regards ... Chris

[Former Member · Accepted solution]

Installing the SS client did not help.

Actually, in the time it took for my question to pass moderation, I shifted tacks and switched to OLE DB instead of ADO.Net and this solved my problems.

I wouldn't say my question has been answered, but I don't need the answer anymore.

Thanks.