Powerbuilder 10.5.1.6662 Connection to SQL Server 2005

Recently, an application has been migrated from Powerbuilder 9.0 to
Powerbuilder 10.5 Build 6662. This application uses an .INI file
located in the Windows folder. The connection to the database, which
has also been migrated from SQL 2000 to SQL 2005 is as follows:
[database]
DBMS=3DOLE DB
Database=3Ddb_lps_prd_01
ServerName=3DUSDANS402
dbParm=3DConnectstring=3DPROVIDER=3D'SQL
OLEDB',DATASOURCE=3D'USDANS402',INT=
EGRATEDS=AD
ECURITY=3D'SSPI',DATABASE=3Ddb_lps_prd_0
1
yet when a user tries to connect to this database, using an embedded
DECLARE and EXECUTE statement, and has access to other databases,
through Active Directory, the Powerbuilder application issues an
error: "you do not have the security credentials necessary to run the
application" Even if you fully qualify the procedure name SQL 2005
throw error 2812, which is equilavent to the application error. If
you remove the user from other databases, then the user can access
the
database in question. Now access to this database has 4 different
security levels in which users are assigned, and those security
levels
are Active Directory access accounts. The gist of it all seems to
be; between Powerbuilder 10.5.1 Build 6662 and SQL Server 2005, when
using the connectivity string defined in the .INI file, apparently
the
user is connecting to some other database trying to execute the
embedded procedure. Can anyone offer insight to this situation?PowerBuilder? Really? I had not heard that there were any of those systems
still around. Good luck with that...
I think you're on the right track... check if the SQL Server has any links
established. Make sure the registered credentials are correct.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"dmmcgrue" <Donna.McGrue@.amgreetings.com> wrote in message
news:1186146671.268576.31950@.z24g2000prh.googlegroups.com...
Recently, an application has been migrated from Powerbuilder 9.0 to
Powerbuilder 10.5 Build 6662. This application uses an .INI file
located in the Windows folder. The connection to the database, which
has also been migrated from SQL 2000 to SQL 2005 is as follows:
[database]
DBMS=OLE DB
Database=db_lps_prd_01
ServerName=USDANS402
dbParm=Connectstring=PROVIDER='SQLOLEDB'
,DATASOURCE='USDANS402',INTEGRATEDS_
ECURITY='SSPI',DATABASE=db_lps_prd_01
yet when a user tries to connect to this database, using an embedded
DECLARE and EXECUTE statement, and has access to other databases,
through Active Directory, the Powerbuilder application issues an
error: "you do not have the security credentials necessary to run the
application" Even if you fully qualify the procedure name SQL 2005
throw error 2812, which is equilavent to the application error. If
you remove the user from other databases, then the user can access
the
database in question. Now access to this database has 4 different
security levels in which users are assigned, and those security
levels
are Active Directory access accounts. The gist of it all seems to
be; between Powerbuilder 10.5.1 Build 6662 and SQL Server 2005, when
using the connectivity string defined in the .INI file, apparently
the
user is connecting to some other database trying to execute the
embedded procedure. Can anyone offer insight to this situation?