Search results matching tag 'Oracle'

Re: error: 26 - Error Locating Server/Instance Specified

shantanu.gupta — Sun, 13 Dec 2009 05:00:00 GMT

Here is the resolution to error 26. Check this video to configure your error. It was a real headache for me for a long time. But this worked.

http://techpint.com/programming/error-26-%E2%80%93-error-locating-serverinstance-specified-sql-server

Re: Migration from Sql Server 2000 to MYSQL

shumaker — Fri, 11 Dec 2009 05:00:00 GMT

I think u should use data migration tool called dbload for this purpose and it use to migrate database.

Find Here : http://www.dbload.com

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 - alternating values

davidl — Fri, 04 Dec 2009 05:00:00 GMT

This is more of a query question... how to I alternate values in a SELECT query, for example:

select * from fruit f where f.isripe = 'Y' and f.type in ('APPLE','ORANGE');

I want the output to be like:

APPLE
ORANGE
APPLE
ORANGE
APPLE
ORANGE
APPLE
APPLE
APPLE

This seems to do the trick (though I am not sure why, explain plan shows a sort happening), but I want to avoid using UNION if at all possible?

select rownum, f.*from fruit fwhere f.isripe = 'Y' and f.type = 'APPLE'
union
select rownum, f.*from fruit fwhere f.isripe = 'Y' and f.type = 'ORANGE';

Possible without using UNION, and using SQL alone?

Cheers,
DGL

Using Oracle Express Edition With Visual Studio 2008

byrontech — Sat, 28 Nov 2009 05:00:00 GMT

I am sorry if this is a basic question, but I can't seem to find a solution while browsing the web. I have Oracle Express Edition (OracleXE) Version 10g. I need to know how to create the connection to the OracleXE with Visual Studio 2008 where I have the tables that I need to add to a DataSet in my ASP.NET application with Crystal Reports. I wanted to use the Server Explorer to create the connection so that I can "Drag and Drop" the necessary tables onto the newely created Dataset Designer. I tried using the .NET Data Provider for Oracle and entered my login credentials and I received an error "TNS: Could not resolve the connnect identifer specifed" I am new to Oracle, but I am very familer with Microsoft SQL Server 2005/2008, so this is a bit akward for me.

Re: Moving data from MS Access to MySQL is easy

Expert11 — Mon, 02 Nov 2009 05:00:00 GMT

Several utilities or converting tools are there in google so search for a good tool available in the market, i use convert db for migrating my database from MS Access to MySQL databases and it works great.

Find Here : http://www.convert-db.com

Re: Migrating application from MS SQL to ORACLE

jean3167 — Sat, 31 Oct 2009 04:00:00 GMT

There are many converters available on google to migrate database, i use convert db for such aim, look at this converter.

Find Here : http://www.convert-db.com

Migrate from System.Data.OracleClient in two simple steps with Devart

corelab — Tue, 06 Oct 2009 04:00:00 GMT

Devart offers dotConnect for Oracle – fast and reliable ADO.NET provider for the wide range of users. Our ADO.NET provider is the most compatible with OracleClient. dotConnect allows you to migrate from MS OracleClient just in two simple steps.
As you might know from ADO.NET team blog Microsoft announced deprecation of OracleClient as a part of ADO.NET roadmap and strongly recommended to use third-party ADO.NET providers for Oracle instead of continuing to use Microsoft’s OracleClient for new application development.
We have researched problems, which users may encounter migrating from OracleClient to dotConnect for Oracle and found two major. They are Interface differences and Behavior differences. Devart reduces all them just by 2 simple actions. Almost all differences in the names of the classes, methods, and fields between OracleClient and dotConnect for Oracle were removed. Migration Wizard will solve the problems with the minor differences that still exist so you don't have to learn new interface. All behavior differences will be simply reduced just by inserting one string to your code. As simply as that.
What benefits you have using dotConnect for Oracle? We offer you to choose the best Edition to fit your needs. You need functionality similar to OracleClient — get it for FREE! Choose our FREE Express edition! If you want to develop and deploy database applications with ease or you need some advanced features and all functionality of Oracle — choose one of our Advanced Editions. Their prices start just from $149.95. To learn more, download trial and free editions, or order a license welcome to Devart site: www.devart.com/dotconnect/oracle/.
To read full size article with pictures and examples visit dotConnect's team blog: http://www.devart.com/blogs/dotconnect/?p=67 .
Enjoy simplicity of migration with us! About Devart Devart (formerly known as Core Lab) 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/.

Application trying to load Oracle.DataAccess version different than the one in web.config

Manotas — Thu, 01 Oct 2009 04:00:00 GMT

Hi,

I would appreciate any help on the following issue we're facing:

We're putting into production an appication which has been already tested on differents environements (supposed to be similars to the production one), but after configuration, we're getting an exception when loading the Oracle.DataAccess dll, but the thing is that's not the same version defined on the web.config.

Could not load file or assembly 'Oracle.DataAccess, Version=10.2.0.200....

The 10.2.0.200 it not indeed in the GAC, but anyway, the exception's details it's pointing to the folling line on the web.config:

<add assembly="Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89B483F429C47342"/></assemblies>

I really cannot see what's going on. On the GAC, I can find only the following versions of the Oracle.DataAccess:

9.2.0.401
1.102.2.20
2.111.7.20
2.102.2.20

What else could I check ? I suppose there is any manipulation I could do at the Oracle Client level to force the use of the DLL I wish but I don't want to break anything for other applications running under the same server.....

Does anyone know what are we doing wrong ???? Many thanks in advance

SSIS, preserving foreign key constraints.

Frederick — Thu, 24 Sep 2009 04:00:00 GMT

Hi, all.

For the past few days, I've been trying to use SSIS to migrate data in tables from a SQL Server database to an Oracle database. I need to retain foreign key constraints while doing it. I'm not in a position to remove foreign key constraints, then add them back.

The problem is that each of the foreign keys I'm using are newly generated GUIDs (created by SSIS).

Example:

I have two tables, "ShipClass" and "Ship". ShipClass contains a foreign Key pointing to Ship. That means the Ship table is loaded first, then ShipClass.
In the first dataflow, Ship is loaded appropriately in its' table - with a new Guid for its' foreign key field. ShipClass is loaded next, but the column containing the foreign key pointing to Ship always has a newly generated Guid.

The problem:
ShipClass has a FK relationship to Ship - both of their Guids absolutely have to be the same. I need a way to preserve foreign key constraints when I'm loading two different tables in SSIS.

I can't figure out how to do this. Can I get some help?