By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,338 Members | 1,350 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,338 IT Pros & Developers. It's quick & easy.

TimesTen with C# or .NET Framework

P: n/a
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

Feb 5 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
zw wrote:
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.

--
Göran Andersson
_____
http://www.guffa.com
Feb 5 '07 #2

P: n/a
zw wrote:
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
Feb 10 '07 #3

P: n/a
zw
On Feb 5, 5:07 pm, Göran Andersson <g...@guffa.comwrote:
zw wrote:
Hi
I like to useC#within 2.0 .NET Framework to connect application to
TimesTenDB.
But it looks like there's no such support for this.
Questions
1- Is there a way to integrateC#application code to use with JDBC
forTimesTenDB connection ?
2 - I'm new to .NET, so is it possible to integrateC#application
code to use with ODBC
forTimesTenDB connection ?
Any help is appreciated.
Advance Thanks

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.

Feb 16 '07 #4

P: n/a
zw wrote:
On Feb 5, 5:07 pm, Göran Andersson <g...@guffa.comwrote:
>You can use the classes in System.Data.Odbc to connect using ODBC.

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
Feb 18 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.