Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OLEDB and ODP.NET and C# connection

936666Sep 11 2012 — edited Jun 28 2013

1) I am trying to code with OLEDB for TimesTen database
I have used OLEDB Connection to connect TimesTen database

using System.Data.Oledb;
connectionString = "Dsn=MYDatabase";

For OLEDB we need to specify the Provider, the Provider for MS SQL Server is like Provider=SQLNCLI10; and for Oracle Provider is Provider=OraOLEDB.Oracle; like wise what is the provider we need to specify for TimesTen database.

Whether OLEDB is supported by TimesTen or not.

2) What is code with ODP.NET for TimesTen database?

If i use ODP.NET then what is the connection string and what name space i need to specify can i specify the name as Oracle.DataAccess.Client
using Oracle.DataAccess.Client;
connectionString = "Dsn=MYDatabase";
since it is for Oracle can i specify this name for TimesTen also.

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 26 2013

Added on Sep 11 2012

#database-key-features, #timesten-in-memory-database

19 comments

3,814 views