Hi, While I've been using Delphi 7 and DBISAM for many years, I'm new to both ElevateDB and Delphi.NET. I am working on the development of a
web interface for one of our apps. We've decided to develop in RAD Studio 2007 using Delphi.NET.

My issue is that I cannot find any way to connect to the ElevateDB database which I've migrated from DBISAM 4. I have both the ElevateDB and
Additional tools installed. There is nothing obvious that I can find and there seems to be little help. On the web site:

http://www.elevatesoft.com/prodinfo?action=view&product=edb&no=2

it states that the following are available:

Win32 VCL
ODBC driver (via ODBC API)
VCL.NET
ODBC.NET data provider (via ODBC driver)

However I don't know how to connect using any of these (I assume VCL.NET would be appropriate me my WebForms app?)

Thanks in advance.

Hi Rick,

Normally you would connect to a dta source for a web site using and ADO
or ODBC connection and use a Connection String.

Have you tried downloading the trial of the ElevateDB DAC components.
The help screens with these components will show you how to connect to
your database.

Chris Holland
[Team Elevate]

Rick Wheeler wrote:
> Hi, While I've been using Delphi 7 and DBISAM for many years, I'm new to both ElevateDB and Delphi.NET. I am working on the development of a
> web interface for one of our apps. We've decided to develop in RAD Studio 2007 using Delphi.NET.
>
> My issue is that I cannot find any way to connect to the ElevateDB database which I've migrated from DBISAM 4. I have both the ElevateDB and
> Additional tools installed. There is nothing obvious that I can find and there seems to be little help. On the web site:
>
> http://www.elevatesoft.com/prodinfo?action=view&product=edb&no=2
>
> it states that the following are available:
>
> Win32 VCL
> ODBC driver (via ODBC API)
> VCL.NET
> ODBC.NET data provider (via ODBC driver)
>
> However I don't know how to connect using any of these (I assume VCL.NET would be appropriate me my WebForms app?)
>
> Thanks in advance.
>

Hi Chris,

I really need some more help with this. I've now lost 3 days and I'm yet to successfully connect to ElevateDB and I've tried both RAD Studio,
VS2005. I have installed on my machine the latest ElevateDB VCL v2b7, ElevateDB Additional v2b7 and ElevateDB DAC Trial v2b7. So far I am
able to connect a datasource for a Win32 VCL app, however that's as far as my success has gone.

In RAD Studio, I really don't know where to start. I've dug around in all of the connection properties and screens and I can't find anything which
points to either the ElevateDB.NET provider or the ODBC driver (for which I have configured a test DSN), nor can I connect using ADO.NET (which
I think is not supported anyway) or any other method.

In VS2005 I can see the ElevateDB Database as a data source, but I cannot connect. I get error #1100 (existing connection forcibly closed by the
remote host) when trying to connect remotely and error #100 metadata problem (signature, password, character set...) when trying to connect
locally.

Any help would be greatly appreciated. I'm really under pressure for this project and need this resolved ASAP. I would prefer to do by phone but
any help at all would be great.

Thanks.
Rick.

My first guess would be that you are not using the Unicode server.
You need to use the Unicode server on .NET

It's working just fine for me. (VS 2008 ASP.NET)

--
Jan-Erik

Hi Rick,

This was the same error that I got when I used the non unicode version
of the DAC by mistake.

Chris Holland

Rick Wheeler wrote:
> Hi Chris,
>
> I really need some more help with this. I've now lost 3 days and I'm yet to successfully connect to ElevateDB and I've tried both RAD Studio,
> VS2005. I have installed on my machine the latest ElevateDB VCL v2b7, ElevateDB Additional v2b7 and ElevateDB DAC Trial v2b7. So far I am
> able to connect a datasource for a Win32 VCL app, however that's as far as my success has gone.
>
> In RAD Studio, I really don't know where to start. I've dug around in all of the connection properties and screens and I can't find anything which
> points to either the ElevateDB.NET provider or the ODBC driver (for which I have configured a test DSN), nor can I connect using ADO.NET (which
> I think is not supported anyway) or any other method.
>
> In VS2005 I can see the ElevateDB Database as a data source, but I cannot connect. I get error #1100 (existing connection forcibly closed by the
> remote host) when trying to connect remotely and error #100 metadata problem (signature, password, character set...) when trying to connect
> locally.
>
> Any help would be greatly appreciated. I'm really under pressure for this project and need this resolved ASAP. I would prefer to do by phone but
> any help at all would be great.
>
> Thanks.
> Rick.
>

Ok thanks for your help. Now in VS2005 i can connect using unicode version but I'm getting the error "ElevateDB Error #504 The maximum
number of concurrent sessions has been reached"

I'm still now wiser in Delphi.NET. Could you please point me in the right direction how to get started here as it is not clear from the help. I really
have no idea where to start (blush).

Thanks in advance. It is tough with the time difference as it is now in your afternoon. Anyway thanks for your help.
Rick

Ok ,this is getting ridiculous. I need to know how to connect with ElevateDB via RAD Studio ASAP. I have spent 3-4 days trying now and I'm getting
nowhere fast. Unless I can get this resolved we may have to drop ElevateDB and switch to MSSQL. I need clear instructions on how to perform this
because it just makes no sense to me??!! I cannot find anything under any type of project which allows me to connect to ElevateDB under any kind
of .NET project in RAD Studio. Could someone please tell me how to achieve this with basic instructions. eg:

1. create a new "ASP.NET" project in RAD Studio
2. click on "xyz" on the tool palette
3. click on "new connection"
4. select "abc" from the connections

or whatever is the correct procedure. At least I can then decide at which point it is not working or the option is not appearing. It seems ridiculous
difficult to me and there is absolutely no help on this anywhere in the known online world. I have searched everywhere for these basic instructions
and it still evades me. Perhaps post a sample project??

I have RAD Studio 2007 trial installed, along with all the ElevateDB stuff (including DAC trial).

It is working in VS2005, but I need RAD Studio. If i can't make this work we will switch to VS2005 and MSSQL once and for all.

Please help (please also excuse my rant but this has gone on long enough)

Answered via phone and email.

Issue was with mismatch between ANSI/Unicode versions of ElevateDB combined
with RS2007 not being able to access non-CodeGear-provided .NET data
providers via their SQLDataSource object for ASP applications.

--
Tim Young
Elevate Software
www.elevatesoft.com