Hi,

I am trying to connect to a non-unicode ElevateDB database, so I cannot use dotNet as that is unconditionally unicode

I don't want to buy expensive Delphi C++ IDE, so I am either able to use create a win32 app under Visual Studio
or go with an open source IDE such as Eclipse or dev-c++

The problem I am encountering is being able to utilize the libraries for TEDBEngine, TEDBSession, TEDBDatabase, etc as they only appear to be provided for users that work with Delphi products

I do not wish to use ODBC as the driver will have to be installed on the client PC requiring admin rights. Also I am not sure that I can use ODBC anyway because the database to which I wish to connect sits inside the parent DB and I have to list databases in order to connect to the child DB.

So, my question is - how can I connect to an ElevateDB using an IDE such as VS2008 with win32C++ or Eclipse or dev-c++ (ie. anything other than delphi stuff)?

Tony,

<< I am trying to connect to a non-unicode ElevateDB database, so I cannot
use dotNet as that is unconditionally unicode >>

Actually, you can get around this by using the ODBC driver and the ODBC.NET
data provider.

<< The problem I am encountering is being able to utilize the libraries for
TEDBEngine, TEDBSession, TEDBDatabase, etc as they only appear to be
provided for users that work with Delphi products >>

Yes, that is correct.

<< I do not wish to use ODBC as the driver will have to be installed on the
client PC requiring admin rights. Also I am not sure that I can use ODBC
anyway because the database to which I wish to connect sits inside the
parent DB and I have to list databases in order to connect to the child DB.
>>

I'm not quite sure what you mean about a parent/child DB setup, but as long
as the database is accessible via ElevateDB in another interface like the
Delphi VCL components, then it is accessible to the ElevateDB ODBC driver.

<< So, my question is - how can I connect to an ElevateDB using an IDE such
as VS2008 with win32C++ or Eclipse or dev-c++ (ie. anything other than
delphi stuff)? >>

Unfortunately, apart from the ODBC driver, we currently do not offer any
native DLL access that is accessible via C++.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim,

As you suggested, I have written my code in C#.Net in Visual Studio using ODBC.NET and connecting to the ElevateDB data files using a connection string for the ODBC driver defining all the config details that are not default and it is working perfectly.

I was hoping to have been able to create a bundled application without the need for my users to install an ODBC driver, but I suppose it only needs to be installed once.

On the other hand, I much rather code in C#.Net than C++ these days, so that is a bigger bonus anyway.

Kind regards
Tony Jennings

Tony,

<< As you suggested, I have written my code in C#.Net in Visual Studio using
ODBC.NET and connecting to the ElevateDB data files using a connection
string for the ODBC driver defining all the config details that are not
default and it is working perfectly. >>

Fantastic, I'm glad that things are working well.

<< I was hoping to have been able to create a bundled application without
the need for my users to install an ODBC driver, but I suppose it only needs
to be installed once.  >>

Yes, and you can install it into a private directory, so that there are zero
chances of a conflict.  Also, you can set up the registry entries for the
driver in your .NET application at startup, so that you don't need to use
the EDB installer, if you don't want to:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2dac&topic=Custom_Driver_Installation

That way you can have a complete copy-and-run solution that only requires
the .exe and the one .dll (besides the .NET assemblies), and is completely
self-contained.

<< On the other hand, I much rather code in C#.Net than C++ these days, so
that is a bigger bonus anyway. >>

Yes, C# is much easier to deal with.

--
Tim Young
Elevate Software
www.elevatesoft.com