DSN-Less connection in PB 7.0 w/SQL Server
Posted on 2004-09-17
The title says it all. I want to connect my Powerbuilder application to SQL Server 2000, DSN-less and using Windows authentication. Can this be done and if so, how is it done?
Here is what I have tried...
SQLCA.DBMS = 'MSS MS SQL Server 6.x'
SQLCA.AutoCommit = TRUE
SQLCA.DBParm = "ConnectOption='SQL_INTEGRATED_SECURITY,SQL_IS_ON'"
SQLCA.logid = <myusername>
SQLCA.Database = <mydatabase>
SQLCA.ServerName = <myservername>
When I debug through this, it gives me the error, "login incorrect". My username is in the SQL Server logins.