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.

Advantage 8.1 and ASP.NET 2.0

6 posts in DelphidotNet Last posting was on 2007-11-21 20:49:31.0Z
Bob Swart Posted on 2007-11-19 14:35:10.0Z
Date: Mon, 19 Nov 2007 15:35:10 +0100
From: Bob Swart <Bob@eBob42.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: advantage.DelphidotNet
Subject: Advantage 8.1 and ASP.NET 2.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 89.220.93.5
Message-ID: <47419de1@solutions.advantagedatabase.com>
X-Trace: 19 Nov 2007 07:29:53 -0700, 89.220.93.5
Lines: 46
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.220.93.5
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:117
Article PK: 1108551

Hi All,

I want to use the Advantage 8.1 drivers to work on an ASP.NET 2.0 web
application using the GridView and FormView for example.

There is no component like an SqlDataSource in the Advantage .NET
provider as far as I can see. I've search for a solution, and found a
recommendation to use OLE DB...

OK, I installed the Advantage OLE DB provider, and then tried to use the
Configure Data Source wizard to create a connection string to the
Advantage database using OLE DB (which worked), but right after that, I
got an error that it could not retrieve the database schema, so the
connection string wasn't even saved to the web.config file.

I have a few questions:

- will there be a component like SQlDataSource for the Advantage database?

- if not, can someone show me a connection string that will work. Right
now, I tried

<connectionStrings>
<add name="Advantage"
connectionString="Provider=Advantage OLE DB Provider;Data
Source=D:\auradb\AuraDB.add;Persist Security Info=False;User
ID=adssys;Advantage Character Data Type=ADS_ANSI;Advantage Locking
Mode=ADS_COMPATIBLE_LOCKING;Advantage Security
Mode=ADS_IGNORERIGHTS;Advantage Server Type=ADS_LOCAL_SERVER;Advantage
Table Type=ADS_CDX"
providerName="Microsoft.OleDB.Provider"/>
</connectionStrings>

But that gives me error message on the keyword Provider. Without it, it
doesn'r recognise it either. An example would help a lot here!

- has anyone been able to connect an Advantage data source to a GridView
using ASP.NET 2.0? A demo or sample code would be great, thanks!

Groetjes,
Bob Swart

--
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
CodeGear Technology Partner -- CodeGear RAD Studio Reseller (BeNeLux)
Blog: http://www.drbob42.com/blog - RSS: http://eBob42.com/weblog.xml


Mark Wilkins Posted on 2007-11-20 18:45:33.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.DelphidotNet
References: <47419de1@solutions.advantagedatabase.com>
Subject: Re: Advantage 8.1 and ASP.NET 2.0
Date: Tue, 20 Nov 2007 11:45:33 -0700
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 10.24.38.228
Message-ID: <47432a0e@solutions.advantagedatabase.com>
X-Trace: 20 Nov 2007 11:40:14 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:118
Article PK: 1108553

Hi Bob,

"Bob Swart" <Bob@eBob42.com> wrote in message
news:47419de1@solutions.advantagedatabase.com...
> Hi All,
>
> I want to use the Advantage 8.1 drivers to work on an ASP.NET 2.0 web
> application using the GridView and FormView for example.
>
> There is no component like an SqlDataSource in the Advantage .NET provider
> as far as I can see. I've search for a solution, and found a
> recommendation to use OLE DB...

The SQLDataSource is a generic control that can connect to any data
provider. So you should be able to use this control. You need to specify
the connection string to use the Advantage .NET Data Provider. If you drop
an SQLDataSource onto your project and choose "Configure Data Source" then
choose "New Connection", you should be able to see the Advantage provider as
an option.

Mark Wilkins
Advantage R&D


Bob Swart Posted on 2007-11-21 06:20:22.0Z
Message-ID: <4743CE26.3000101@eBob42.com>
Date: Wed, 21 Nov 2007 07:20:22 +0100
From: Bob Swart <Bob@eBob42.com>
Organization: Bob Swart Training & Consultancy
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: advantage.DelphidotNet
Subject: Re: Advantage 8.1 and ASP.NET 2.0
References: <47419de1@solutions.advantagedatabase.com> <47432a0e@solutions.advantagedatabase.com>
In-Reply-To: <47432a0e@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 89.220.93.5
X-Trace: 20 Nov 2007 23:15:04 -0700, 89.220.93.5
Lines: 28
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.220.93.5
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:119
Article PK: 1108554

Hi Mark,

> The SQLDataSource is a generic control that can connect to any data
> provider. So you should be able to use this control. You need to specify
> the connection string to use the Advantage .NET Data Provider. If you drop
> an SQLDataSource onto your project and choose "Configure Data Source" then
> choose "New Connection", you should be able to see the Advantage provider as
> an option.

Yes, I should be able, shouldn't I? I even tried it (before I got your
message), but right at the end, when the wizard wants to save the
connectionstring to my web.config file, it gives an error that no meta
data can be retrieved from the database (although the connection itself
was a "success").
So I'm still stuck here... A DBX4 driver would also help, since
connecting through DBX4 to just about any database (except Advantage for
which no DBX4 driver exists) also works find in ASP.NET 2.0... :-(

> Mark Wilkins
> Advantage R&D

Groetjes,
Bob Swart

--
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
CodeGear Technology Partner -- CodeGear RAD Studio Reseller (BeNeLux)
Blog: http://www.drbob42.com/blog - RSS: http://eBob42.com/weblog.xml


Jeremy Mullin Posted on 2007-11-21 16:22:47.0Z
Date: Wed, 21 Nov 2007 16:22:47 +0000 (UTC)
Message-ID: <1b468bc82de7c8c9fa3736f6547f@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: Advantage 8.1 and ASP.NET 2.0
Newsgroups: Advantage.DelphidotNet
References: <4743CE26.3000101@eBob42.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.114
X-Trace: 21 Nov 2007 09:17:28 -0700, 10.24.38.114
Lines: 32
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.114
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:121
Article PK: 1108556

Hi Bob,

Are you using RAD Studio 2007 or Delphi 2006? I'll give it a try here.

J.D. Mullin
Advantage R&D

> Hi Mark,
>
>> The SQLDataSource is a generic control that can connect to any data
>> provider. So you should be able to use this control. You need to
>> specify the connection string to use the Advantage .NET Data
>> Provider. If you drop an SQLDataSource onto your project and choose
>> "Configure Data Source" then choose "New Connection", you should be
>> able to see the Advantage provider as an option.
>>
> Yes, I should be able, shouldn't I? I even tried it (before I got your
> message), but right at the end, when the wizard wants to save the
> connectionstring to my web.config file, it gives an error that no meta
> data can be retrieved from the database (although the connection
> itself
> was a "success").
> So I'm still stuck here... A DBX4 driver would also help, since
> connecting through DBX4 to just about any database (except Advantage
> for
> which no DBX4 driver exists) also works find in ASP.NET 2.0... :-(
>> Mark Wilkins
>> Advantage R&D
> Groetjes,
> Bob Swart


Bob Swart Posted on 2007-11-21 19:44:47.0Z
Message-ID: <47448AAF.5000703@eBob42.com>
Date: Wed, 21 Nov 2007 20:44:47 +0100
From: Bob Swart <Bob@eBob42.com>
Organization: Bob Swart Training & Consultancy
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: Advantage.DelphidotNet
Subject: Re: Advantage 8.1 and ASP.NET 2.0
References: <4743CE26.3000101@eBob42.com> <1b468bc82de7c8c9fa3736f6547f@devzone.advantagedatabase.com>
In-Reply-To: <1b468bc82de7c8c9fa3736f6547f@devzone.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 89.220.93.5
X-Trace: 21 Nov 2007 12:39:29 -0700, 89.220.93.5
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!89.220.93.5
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:122
Article PK: 1108557

Hi Jeremy,

> Are you using RAD Studio 2007 or Delphi 2006? I'll give it a try here.

CodeGear RAD Studio 2007 is the only one supporting ASP.NET 2.0, so I'm
using that one with the new ASP.NET SQLDataSource (declarative data
binding) control...
I would really appreciate if you could tell me what I'm doing wrong, or
if you could send me a web.config file with a saved connection string
example for the SQLDataSource.

> J.D. Mullin
> Advantage R&D

Groetjes,
Bob Swart

--
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
CodeGear Technology Partner -- CodeGear RAD Studio Reseller (BeNeLux)
Blog: http://www.drbob42.com/blog - RSS: http://eBob42.com/weblog.xml


Jeremy Mullin Posted on 2007-11-21 20:49:31.0Z
Date: Wed, 21 Nov 2007 20:49:31 +0000 (UTC)
Message-ID: <1b468bc82dff28c9fa5c7a506a73@devzone.advantagedatabase.com>
From: Jeremy Mullin <no@email.com>
Subject: Re: Advantage 8.1 and ASP.NET 2.0
Newsgroups: Advantage.DelphidotNet
References: <47448AAF.5000703@eBob42.com>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 1098.1
NNTP-Posting-Host: 10.24.38.114
X-Trace: 21 Nov 2007 13:44:13 -0700, 10.24.38.114
Lines: 19
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.114
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:123
Article PK: 1108558

Hi Bob,

Your connection string looks fine.

I tried this and got the same error. I did some searching on Google and this
seems to be a CodeGear issue that affects all drivers, not just Advantage.
I'm currently trying some of the suggested fixes to see if I can make it
work. Perhaps you can try the same.

A google groups search for:

"rad studio" "schema could not be retrieved"

brings up quite a few relevant topics.

J.D. Mullin
Advantage R&D