Solved

DSN-Less connection in PB 7.0 w/SQL Server

Posted on 2004-09-17
2
555 Views
Last Modified: 2013-12-26
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
Comment
Question by:colettim
2 Comments
 
LVL 8

Expert Comment

by:Vikas_Dixit
ID: 12091851
Please refer this post :

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

May be of some help..
regards
Vikas
0
 
LVL 4

Accepted Solution

by:
falvaro3 earned 175 total points
ID: 12098791
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand columnThat will then direct you to their download page.From that page s…
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question