Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

DSN-Less connection in PB 7.0 w/SQL Server

Posted on 2004-09-17
2
Medium Priority
?
590 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 700 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
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 column That will then direct you to their download page. From that p…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

885 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