TimesTen with C# or .NET Framework

[zw]

Hi

I like to use C# within 2.0 .NET Framework to connect application to
TimesTen DB.
But it looks like there's no such support for this.
Questions

1- Is there a way to integrate C# application code to use with JDBC
for TimesTen DB connection ?
2 - I'm new to .NET, so is it possible to integrate C# application
code to use with ODBC
for TimesTen DB connection ?

Any help is appreciated.

Advance Thanks

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

Hi

I like to use C# within 2.0 .NET Framework to connect application to
TimesTen DB.
But it looks like there's no such support for this.
Questions

1- Is there a way to integrate C# application code to use with JDBC
for TimesTen DB connection ?
2 - I'm new to .NET, so is it possible to integrate C# application
code to use with ODBC
for TimesTen DB connection ?

Any help is appreciated.

Advance Thanks

You can use the classes in System.Data.Odbc to connect using ODBC.

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

I like to use C# within 2.0 .NET Framework to connect application to
TimesTen DB.
But it looks like there's no such support for this.
Questions

1- Is there a way to integrate C# application code to use with JDBC
for TimesTen DB connection ?
2 - I'm new to .NET, so is it possible to integrate C# application
code to use with ODBC
for TimesTen DB connection ?

If it does not have to be free, then look at:

http://www.tankardsoft.com/

Arne

 

[zw]

You can use the classes in System.Data.Odbc to connect using ODBC.

--
Göran Andersson
_____http://www.guffa.com- Hide quoted text -

- Show quoted text -

Can someone include a sample code using System.Data.Odbc with TimesTen
DB ?
Oracle told me that TimesTen doesn't have support for this.
What's the workaround if C# has to be used. Any advice ?
No $ to purchase 3rd party data provider.

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Can someone include a sample code using System.Data.Odbc with TimesTen
DB ?
Oracle told me that TimesTen doesn't have support for this.
What's the workaround if C# has to be used. Any advice ?

..NET supports ODBC.

TimesTen supports ODBC.

The obvious conlcusion is that .NET can use TimesTen via ODBC.

There are no tricks necessary !

Code example:

using System;
using System.Data.Odbc;

public class MainClass
{
public static void Main(string[] args)
{
OdbcConnection con = new OdbcConnection("Dsn=TestTimesTen;");
con.Open();
OdbcCommand cmd = new OdbcCommand("SELECT * FROM t1", con);
OdbcDataReader rdr = cmd.ExecuteReader();
while(rdr.Read()) {
int f1 = (int)rdr[0];
string f2 = (string)rdr[1];
Console.WriteLine(f1 + " " + f2);
}
con.Close();
}
}

Speak about straightforward code !

Arne