Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Help Needed - SQLConfigDataSource with PB

2 posts in Objects Last posting was on 2005-02-28 13:20:41.0Z
Sriram Posted on 2005-02-26 06:10:52.0Z
Sender: c88.422012a9.1804289383@sybase.com
From: Sriram
Newsgroups: sybase.public.powerbuilder.objects
Subject: Help Needed - SQLConfigDataSource with PB
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <422012e6.c8a.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 25 Feb 2005 22:10:46 -0800, 10.22.241.42
Lines: 16
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Feb 2005 22:10:49 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Feb 2005 22:10:52 -0800
X-Trace: forums-1-dub 1109398252 10.22.108.75 (25 Feb 2005 22:10:52 -0800)
X-Original-Trace: 25 Feb 2005 22:10:52 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8237
Article PK: 735499

Hi all,

I am using PB 9.0 and Ms-Access as my backend. I have
created mdb file and DSN on the fly using the API
"SQLConfigDataSource".

I want to Repair and Compact the Access Database.
Please help me how to accomplish the task with the same API.
I tried with the parameters, REPAIR_DB, COMPACT_DB in place
of
lpszAttributes, but of no use..

Please help me in this regard..

Regards
Sriram


Chris Keating (iAnywhere Solutions) Posted on 2005-02-28 13:20:41.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: sybase.public.powerbuilder.objects
References: <422012e6.c8a.1681692777@sybase.com>
Subject: Re: Help Needed - SQLConfigDataSource with PB
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <42231aa5$1@forums-2-dub>
X-Original-Trace: 28 Feb 2005 05:20:37 -0800, keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Feb 2005 05:20:38 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Feb 2005 05:20:41 -0800
X-Trace: forums-1-dub 1109596841 10.22.108.75 (28 Feb 2005 05:20:41 -0800)
X-Original-Trace: 28 Feb 2005 05:20:41 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:8238
Article PK: 735500

Please refrain from crossposting. It results in unnessary work for both you
and the person asking that you refrain from crossposting.

Thanks

<Sriram> wrote in message news:422012e6.c8a.1681692777@sybase.com...
> Hi all,
>
> I am using PB 9.0 and Ms-Access as my backend. I have
> created mdb file and DSN on the fly using the API
> "SQLConfigDataSource".
>
> I want to Repair and Compact the Access Database.
> Please help me how to accomplish the task with the same API.
> I tried with the parameters, REPAIR_DB, COMPACT_DB in place
> of
> lpszAttributes, but of no use..
>
> Please help me in this regard..
>
> Regards
> Sriram