• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 592
  • Last Modified:

DSN-Less connection in PB 7.0 w/SQL Server

All,

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.  

Please advise!

Thanks!
0
colettim
Asked:
colettim
1 Solution
 
Vikas_DixitCommented:
Please refer this post :

http://www.experts-exchange.com/Programming/Programming_Languages/PowerBuilder/Q_21006549.html

May be of some help..
regards
Vikas
0
 
falvaro3Commented:
My comes across liike this (note the DBParm option) in PB7:

// Profile local_auth
SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = "local_dev"
SQLCA.LogPass = <*********>
SQLCA.ServerName = "DevServer"
SQLCA.LogId = "MYDOMAIN\My_Logon"
SQLCA.AutoCommit = True
SQLCA.DBParm = "Secure=1"

Also note, I'm using a domain logon for this SQL Server.
And also make sure that your username has been given access to the db [sorry, had to ;)  ]
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now