Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chedderslam
Posting Yak Master
223 Posts |
 Posted - 2009-06-17 : 10:38:51
|
| When opening a powerbuilder application, I am receiving the following error:------------------------------------------------Select Error: SQLSTATE = 42502Microsoft OLE DB Provider for SQL ServerInvalid object name 'a_reports'------------------------------------------------I can open the table 'a_reports' in management studio without issue.I found this information about the error:Authorization ID not permitted to perform operation as specified. The current user does not have an authenticated connection. When an application (which does not have the encryption library or the CryptoPlugin.dll) executes an encryption related SQL commands (GRANT, REVOKE and CREATE TABLE) an error of "42502" will be returned. This is to prevent applications from crashing.How would I fix this? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-18 : 16:28:19
|
Change your connection string from your Powerbuilder application for connecting to SQL Server.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
fixing sqlstate 42502