Solved

DSN-Less connection in PB 7.0 w/SQL Server

Posted on 2004-09-17
2
552 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
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.

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now