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.

adox support

6 posts in Visual Basic Last posting was on 2004-12-17 20:03:33.0Z
techstool Posted on 2004-12-07 16:52:30.0Z
Reply-To: "techstool" <techstool@cox.net>
From: "techstool" <techstool@cox.net>
Newsgroups: advantage.visual_basic
Subject: adox support
Date: Tue, 7 Dec 2004 09:52:30 -0700
Lines: 23
Organization: techstool software labs
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 68.3.65.28
Message-ID: <41b5e019@solutions.advantagedatabase.com>
X-Trace: 7 Dec 2004 09:53:45 -0700, 68.3.65.28
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.3.65.28
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:902
Article PK: 1137697

currently have a vb app that uses ms/access via jet.

app performs db creation through adox implementation, i'd like to convert
database to advantage.

does advantage support the same or will i have to change db creation to sql?
any snippets of code for this?

also, app currently backs up db through simple copy since access db of
multiple tables is a single file. is there a preferred way to do this with
advantage db composed of multiple adt's?

and... app also performs repair/compress functions on access db, how is
this accomplished in advantage? if not same are there any snippets available
for this also?


thanks

bill graham
techstool


Lee Stigile Posted on 2004-12-13 22:43:59.0Z
Date: Mon, 13 Dec 2004 15:43:59 -0700
From: Lee Stigile <lees@extendsys.com>
User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: advantage.visual_basic
Subject: Re: adox support
References: <41b5e019@solutions.advantagedatabase.com>
In-Reply-To: <41b5e019@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 192.168.31.45
Message-ID: <41be1be7@solutions.advantagedatabase.com>
X-Trace: 13 Dec 2004 15:47:03 -0700, 192.168.31.45
Lines: 59
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!192.168.31.45
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:906
Article PK: 1137701


techstool wrote:

> currently have a vb app that uses ms/access via jet.
>
> app performs db creation through adox implementation, i'd like to convert
> database to advantage.
>
> does advantage support the same or will i have to change db creation to sql?
> any snippets of code for this?
>
> also, app currently backs up db through simple copy since access db of
> multiple tables is a single file. is there a preferred way to do this with
> advantage db composed of multiple adt's?
>
> and... app also performs repair/compress functions on access db, how is
> this accomplished in advantage? if not same are there any snippets available
> for this also?
>
>
> thanks
>
> bill graham
> techstool
>
>

Unfortunately, I don't have any experience with adox. There is an older
newsgroup post in the Advantage.OLEDB newsgroup (11/11/2001) regarding
adox. It appears that there may be some syntax/schema differences.
However, additional functionality as been added since '01, so it's
possible that some of these features may be available now.

If you decide to implement the db creation via SQL, the best samples are
provided by the Advantage Data Architect (ARC). I'd recommend going
into ARC and creating a data dictionary manually. Then, right-click on
the data dictionary node and select the option to generate SQL. It will
create all the SQL statement necessary to create the dictionary, users,
tables etc...

Regarding the backup, if no users are attached, you can simply copy the
data directory to another location -- similar to your existing backup
method. You could also use an AdsCopyTable or SELECT INTO statement,
but these copy record-by-record. You're probably better off just
copying the directory if you have exclusive access. ADS 8.0 will have
backup features included with the server.

With ADS, you won't need to repair/compress your tables. You won't see
the bloat and corruption issues that are prevalent with Access. There
is a built-in stored procedure to pack the table (EXECUTE procedure
sp_PackTable(tablename)). This will re-index the tables and compact
your memo files. However, this really shouldn't be necessary.

I hope this helps,

Regards,
Lee Stigile
Advantage Support


techstool Posted on 2004-12-14 22:03:12.0Z
Reply-To: "techstool" <techstool@cox.net>
From: "techstool" <techstool@cox.net>
Newsgroups: advantage.visual_basic
References: <41b5e019@solutions.advantagedatabase.com> <41be1be7@solutions.advantagedatabase.com>
Subject: Re: adox support
Date: Tue, 14 Dec 2004 15:03:12 -0700
Lines: 24
Organization: techstool software labs
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 68.3.65.28
Message-ID: <41bf6391@solutions.advantagedatabase.com>
X-Trace: 14 Dec 2004 15:05:05 -0700, 68.3.65.28
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.3.65.28
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:908
Article PK: 1137703

lee,

thanks for the information.

my app gives the user the ability to export a subset of the database to send
to other users for import. the database contains blobs, so to ease the
shipping of all relevant exported data my app zips the results of the
'select into' ( adt and adm files) into one file. the import process then
unzips and opens the table for merge.

problem i'm running into is that even though i'm setting adodb.command to
nothing and closing connection and setting to nothing it still seems that
the adt and adm files are allocated and can't be deleted until my app has
ended.

i've looked thru documentation and i don't see a command to force the
freeing of the files, what am i missing?

thanks for the assist

bill graham
techstool


Lee Stigile Posted on 2004-12-15 14:45:52.0Z
Date: Wed, 15 Dec 2004 07:45:52 -0700
From: Lee Stigile <lees@extendsys.com>
User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: advantage.visual_basic
Subject: Re: adox support
References: <41b5e019@solutions.advantagedatabase.com> <41be1be7@solutions.advantagedatabase.com> <41bf6391@solutions.advantagedatabase.com>
In-Reply-To: <41bf6391@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 192.168.31.45
Message-ID: <41c04edc@solutions.advantagedatabase.com>
X-Trace: 15 Dec 2004 07:49:00 -0700, 192.168.31.45
Lines: 34
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!192.168.31.45
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:909
Article PK: 1137702


techstool wrote:
> lee,
>
> thanks for the information.
>
> my app gives the user the ability to export a subset of the database to send
> to other users for import. the database contains blobs, so to ease the
> shipping of all relevant exported data my app zips the results of the
> 'select into' ( adt and adm files) into one file. the import process then
> unzips and opens the table for merge.
>
> problem i'm running into is that even though i'm setting adodb.command to
> nothing and closing connection and setting to nothing it still seems that
> the adt and adm files are allocated and can't be deleted until my app has
> ended.
>
> i've looked thru documentation and i don't see a command to force the
> freeing of the files, what am i missing?
>
> thanks for the assist
>
> bill graham
> techstool
>
>

Try disabling connection pooling by including the following in your
connection string:

OLE DB Services=-4

I think that this should take care of it. I've seen the same behavior
before.

Lee


techstool Posted on 2004-12-16 13:02:33.0Z
Reply-To: "techstool" <techstool@cox.net>
From: "techstool" <techstool@cox.net>
Newsgroups: advantage.visual_basic
References: <41b5e019@solutions.advantagedatabase.com> <41be1be7@solutions.advantagedatabase.com> <41bf6391@solutions.advantagedatabase.com> <41c04edc@solutions.advantagedatabase.com>
Subject: Re: adox support
Date: Thu, 16 Dec 2004 06:02:33 -0700
Lines: 19
Organization: techstool software labs
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 68.3.65.28
Message-ID: <41c187a8@solutions.advantagedatabase.com>
X-Trace: 16 Dec 2004 06:03:36 -0700, 68.3.65.28
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.3.65.28
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:912
Article PK: 1137706


> Try disabling connection pooling by including the following in your
> connection string:
>
> OLE DB Services=-4
>
> I think that this should take care of it. I've seen the same behavior
> before.
>
> Lee

seems that did the trick, i can't find a reference to that in help at all.

thanks again for the help

bill graham


Brad Schmidt Posted on 2004-12-17 20:03:33.0Z
From: Brad Schmidt <brad.schmidt.nospam@extendedsystems.com>
Newsgroups: advantage.visual_basic
Subject: Re: adox support
Date: Fri, 17 Dec 2004 13:03:33 -0700
Message-ID: <MPG.1c2ce98387f9552d9897b7@solutions.AdvantageDatabase.com>
References: <41b5e019@solutions.advantagedatabase.com> <41be1be7@solutions.advantagedatabase.com> <41bf6391@solutions.advantagedatabase.com> <41c04edc@solutions.advantagedatabase.com> <41c187a8@solutions.advantagedatabase.com>
Organization: ESI
X-Newsreader: MicroPlanet Gravity v2.50
NNTP-Posting-Host: 198.102.102.88
X-Trace: 17 Dec 2004 13:06:42 -0700, 198.102.102.88
Lines: 28
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.88
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:913
Article PK: 1137707

That's an ADO setting (applicable to all OLE DB providers), not an
Advantage-specific setting. Thus, you won't find it in the Advantage
help file

In article <41c187a8@solutions.advantagedatabase.com>, techstool@cox.net
says...

>
> > Try disabling connection pooling by including the following in your
> > connection string:
> >
> > OLE DB Services=-4
> >
> > I think that this should take care of it. I've seen the same behavior
> > before.
> >
> > Lee
>
>
> seems that did the trick, i can't find a reference to that in help at all.
>
> thanks again for the help
>
> bill graham

Brad
--
* Brad Schmidt
* Extended Systems, Inc