Conecting SQL server from PowerBuilder - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> Conecting SQL server from PowerBuilder

Reply

#1 (permalink)

Old

01-07-10, 02:31

gyanibaba

gyanibaba is offline

Registered User

Join Date: Oct 2008

Posts: 1

Conecting SQL server from PowerBuilder

Hi

My powerbuilder program is connecting SQL server through ODBC as shown below:

SQLCA.DBPARM = "ConnectString='DSN=" + ls_db_name + ";UID=dba;PWD=sql'"

CONNECT ;
Is it necessary to supply userid and password?
is there some alternative ?

Thanks and regards
Gyan

Reply With Quote

#2 (permalink)

Old

01-07-10, 04:28

myle

myle is offline

(Making Your Life Easy)

Join Date: Feb 2004

Location: New Zealand

Posts: 1,110

yes
What I do is setup a user that has only control over database function only add edit .....

__________________
hope this help

See clear as mud

StePhan McKillen
the aim is store once, not store multiple times
Progaming environment:
Access based on my own environment: DAO3.6/A97/A2000/A2003
VB based on my own environment: vb6 sp5
ASP based on my own environment: 5.6
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
MYLE

Reply With Quote

#3 (permalink)

Old

01-14-10, 05:20

Wim

Wim is offline

Registered User

Join Date: Nov 2004

Posts: 1,160

What version of PB and SQL server are you using?

I have problems getting the tables in the list with available tables. I can only see system tables.

__________________
With kind regards . . . . . SQL Server 2000/2005/2008/2008 R2 Earned beers: 13
Wim
Beware of bugs in the above code; I have only proved it correct, not tried it. -- Donald Knuth
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Reply With Quote

#4 (permalink)

Old

02-04-10, 06:11

Kishore_cp Kishore_cp is offline

Kishore_cp is offline

Registered User

Join Date: Dec 2003

Posts: 18

have u specified database to connect to in connecting string..

Database = 'master'

__________________
Kishore

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules