Search results matching tags 'Oracle' and 'odbc'

Get Access to Many Database Servers with One ADO.NET Data Provider

Devart Software — Wed, 09 Dec 2009 05:00:00 GMT

Devart presents the new version of dotConnect Universal (formerly known as UniDirect.NET), data provider that offers universal access to data of Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird databases for the Microsoft .NET Framework.

dotConnect Universal 3.00 offers support for new Devart dotConnect data providers, that is especially important for the users who upgraded their data providers earlier and want to use dotConnect Universal with them as well. The new version also offers bundled providers with advanced connectivity options, such as http tunneling, ssl and more.

dotConnect Universal introduces SQLite provider for working with SQLite - a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

dotConnect Universal compatibility was extended by adding support for Visual Studio 2008 and Visual Studio 2010 Beta.

Mobile edition of dotConnect Universal no longer needs dotConnect providers installed.

Among other improvements, dotConnect Universal Server Explorer integration was enhanced.

Pricing and Availability

The Single license starts from as little as $99.95, and you can always choose the edition that matches your needs best. To learn more, download trial edition, or order a license please visit Devart site:
www.devart.com/dotconnect/universal/.

Please, feel free to download, try and write any comments and suggestions about our products!

About Devart

Devart is a software development company with 11 years of experience on the software market and over 20 thousands of devoted users.

We specialize in providing native connectivity solutions as well as comprehensive development and management tools for the most popular databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite.

For additional information about Devart, visit www.devart.com/company/.

Oracle RDB ODBC newbie question

rwilson_ie — Wed, 19 Sep 2007 04:00:00 GMT

I am trying to extract data from an Oracle RDB database on an Alpha (seems not many / no-one is doing this - or if they are, they aren't putting samples etc up on the Net). I also come from a COBOL/VMS background (no laughing !) with 12 years experience of this and 4 days experience of ASP .NET.

Anyway, I have figured out how to connect to the database and execute a query - I know I should really use a stored procedure but haven't figured that pout yet.

How do I get the data from my query into a DataGrid etc ? I can do it if I set the query in the SQLDataSource and then Bind this to the DataGrid - but how to I do it via code and not use the SqlDataSource ? My code so far is below :

Dim myConnection As String
If myConnection = "" Then

myConnection = "Dsn=dsnName;server=servername;uid=username;pwd=password;tlo=0;dba=W;svr=svrName;cls=generic;database=attach 'filename l$iv_testdb';xpt=2=tcp/ip;cso=1"

End If
Dim myConn As New Data.Odbc.OdbcConnection(myConnection)
Dim mySelectQuery As String = "SELECT stock, shortname from iv_stocks limit to 10 rows"
Dim myOdbcCommand As New Data.Odbc.OdbcCommand(mySelectQuery)
myOdbcCommand.Connection = myConn

myConn.Open()

myOdbcCommand.ExecuteNonQuery()

myOdbcCommand.Connection.Close()

TIA

Rob

Oracle RDB ODBC newbie query

rwilson_ie — Wed, 19 Sep 2007 04:00:00 GMT

Anyway, I have figured out how to connect to the database and execute a query - I know I should really use a stored procedure but haven't figured that pout yet.

Dim myConnection As String

If myConnection = "" Then

myConnection = "Dsn=dsnName;server=servername;uid=username;pwd=password;tlo=0;dba=W;svr=svrName;cls=generic;database=attach 'filename l$iv_testdb';xpt=2=tcp/ip;cso=1"

End If
Dim myConn As New Data.Odbc.OdbcConnection(myConnection)
Dim mySelectQuery As String = "SELECT stock, shortname from iv_stocks limit to 10 rows"
Dim myOdbcCommand As New Data.Odbc.OdbcCommand(mySelectQuery)
myOdbcCommand.Connection = myConn

myConn.Open()

myOdbcCommand.ExecuteNonQuery()

myOdbcCommand.Connection.Close()

TIA

Rob