VODBC docs

[Ruslan Zasukhin]

On 7/29/08 1:36 AM, "alfonsofung" <alfonso at alfonsofung.com> wrote:

Hi Alfonso,

This letter have interesting info, so I will CC it to Valentina list.
May happens that developers on list will help better then we.

> I am using VB.NET 9; I would like to use Valentina to feed data to FarPoint
> Spread as its datasource.

Okay, now task is clear. You are first who try with FarPoint.

What is not clear to me yet.
    * Excell can connect to any ODBC data source self. FarPoint cannot do
this self? So you need to use VB.NET to connect and extract data from
Valentina ODBC source?  Right?

    * when you have data on hands in VB where you move them next?
        i.e. How data will go to FarPoint?


> I have used the ODBC administrator to create DSN

good

> and I understand I can use ODBCConnect, ODBCAdapter and ODBCCommand etc to
> do so.  

Right. ODBC on default is set of C functions described in standard.
A lots of functions. If you want do things programmatically you need to use
them.

> I also know it is possible to do a DSN-less connection.

I have no info about this. You need this todo?
Or you just mention it ?

> I would appreciate if you could provide code samples to:
> 
> 1. Register VODBC;

You mean here normal installation via ODBC admin?
Kirill should try build step by step manual today with snapshots.

> 2. Create DSN for VODBC at runtime with VB.NET; and

Problem here is:

    ODBC can be accessed from MANY languages I believe:
            C,  C++, VB, C#, Java, ...

Do you think we must provide examples for each such language??

I think in docs of that VB.NET must be already examples how todo this.
Right? It should not matter if you connect to Valentina or MS SQL.

> 3. Create connection, fill dataset, fill datatable, insert, update, delete,
> query a Valentina database both with DSN and without DSN.

Again, you ask about VB CODE here. Right?

 
> I would also want to alert you that there is a configure button when
> creating DSN, which leads to a message inviting user to input the serial
> number; when the provided serial number is entered the program says the
> serial number is wrong. This may not be the intended response, and I suggest
> you do change that behavior because it is very confusing.

Kirill will check this today.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]