Help: ADO with Unix and Oracle - Microsoft SQL Server

Jyrki H

We have done a complex software with VB using SQL Server through ADO. Now
our customer is planning to switch from SQL Server to Unix/Aix Oracle 8 DB.

I'm a newbie both in Oracle and Unix and wonder how this will affect our
software. Would changing the connection string be enough (I quess not).

Any help would be appreciated !

Jyrki Hamalainen
Laukaa, Finland
jyrki . hamalainen @ ids . fi

Jul 20 '05 #1

Subscribe Reply

2164

Trevor Best

On Thu, 04 Sep 2003 08:23:14 GMT in comp.databases. ms-sqlserver,
"Jyrki H" <jy***@nowhere. com> wrote:

We have done a complex software with VB using SQL Server through ADO. Now
our customer is planning to switch from SQL Server to Unix/Aix Oracle 8 DB.

I'm a newbie both in Oracle and Unix and wonder how this will affect our
software.
It will probably affect your income more, think of all the dosh you
can charge for that conversion :-)
Would changing the connection string be enough (I quess not).

I'm no oracle expert but at a guess and from experience of people in
CDMA connecting Access to Oracle the ODBC/OLEDB driver you get in
Windows won't do you any favors, IIRC Oracle has something called
SQL.NET and that's probably your best bet for the connection.

The rest will depend on how you wrote your app, if a lot of stored
procedures and triggers, etc then you're going to have fun making them
all work, I'm not sure if there's any conversion tools for converting
a database over, standard stuff should be able to be scripted (tables
and columns) but when you get to the nitty gritty, UDFs, etc. then you
may find things that are not supported or that Oracle will implement
some functionality you need in a different way.

Again I stress that I don't know Oracle and that a lot more may be
instantly convertable than I indicated... or a lot less. You have to
investigate this and come up with some time frame about how long it
will take and how much it will cost before your customer commits as
although there's a smiley on my first paragraph, it may be closer to
to the mark than you think.

Sorry I can't give you any specifics on Oracle but it's something to
start thinking about on the planning side.

I'd suggest if you haven't already done so, post a similar question in
an Oracle news group, normally when talking about conversions or
interactions between products I would recommend cross-posting to both
groups but in this case I wouldn't, IME it would likely start a flame
war, some of those Oracle guys are little, how shall I put it...
esoteric. :-)

--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)

Jul 20 '05 #2

Similar topics

3921

Help Needed Regarding Oracle Migration

by: Azhar Bilgrami | last post by:

Dear Hi: Hope to see u in good health. " I want to migrate a database which is currently running Unix as Operating System and Oracle ver 6 as Database, it is also using oracle froms version 3 (text base) as Front End" Now here is what I want to do " I want to migrate that database from Oracle for Unix to Oracle for Linux With retaining all the Forms, in other words all I want

Oracle Database

3608

Windows v Unix Performance on Oracle 9i

by: Rob | last post by:

Does anyone know if there are any good comparisons between Windows and Unix performance? Or does anyone have examples of Oracle databases running large numbers (200+) of concurrent users. I am trying to investigate what size implementations can be placed onto Windows 2000 / Windows 2003 as opposed to UNIX but cannot find much data. Any information would be much appreciated. Cheers.

Oracle Database

3544

XML Resume Help

by: Ian DeRock | last post by:

I'm fairly new to XML. As I can see it, XML is a way to organize data like in a table in a RDB, or the RDB itself. I have used XML in application data, but did not design the actual XML. I have a background in both hardware and software. I want to create an application that will regenerate a resume from the XML Resume that I have. I would like some people to look over my XML Resume data and give me suggestions on the XML. This...

.NET Framework

2004

Does .Net support non MS environment like Unix/Oracle?

by: Jonathan | last post by:

Hi there We are to make the decision on whether to choose .Net or J2EE. One of the questions my client asked is that, can we run the .Net application on Unix and Unix based database systems on server site? Can we develop client application on VS.Net and put database on Unix environment? Can Web Services be deployed onto Unix environment Any advice?

.NET Framework

2655

I want to get into software development and need HELP!

by: mr.iali | last post by:

Hi Everyone I would like to get into software developent using a programming language like c++, java or pl/sql for oracle. I have no idea where to start from. Which language is there more demand for. Looking at jobs there seems to be a better chance in getting a java job rather than a oracle or c++ job. Also is java and oracle a good combiantion?

C / C++

3536

Accessing data from an MS access db from an Oracle UNIX server

by: Andrea M. Segovia | last post by:

Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access databases who would like to share their data using this visualization tool but do not want to import their data into the Oracle server back-end.

Microsoft Access / VBA

1714

Has anybody succesfully used VB.NET on Oracle on UNIX ?

by: tristant | last post by:

Hi All, Our client has just decided to migrate from SQLServer2k to Oracle 9i on AIX. We are considering what development tool / language as the application/ front end platform. We almost decide to use VB.NET, because current skill is VB 6. Its just more like human resources application and reporting with distributed database. The question is : is there any problem if the UI platform is .NET and the

Visual Basic .NET

3649

PL/SQL function to invoke the UNIX command doesn't create file

by: truthbajaj | last post by:

Hi, I am using Oracle 9i and Unix on my system and trying to execute a UNIX shell command through external procedure in C. I created a shared lib (libextproc.so) for the following function. int sysrun(char *command) { return system(command); }

Oracle Database

13361

Calling Concurrent Program from UNIX

by: amitpatel66 | last post by:

There is always a requirement that in Oracle Applications, the Concurrent Program need to be execute programatically based on certain conditions/validations: Concurrent programs can be executed programatically either from UNIX or Oracle PLSQL. In this Section, I will be explaining about calling a Concurrent program from UNIX using the CONCSUB Command. Pre-requisite: 1. Concurrent Program should be registered in oracle Applications...

Oracle Database

9646

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9483

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10346

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10157

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10096

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9956

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5514

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3658

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2887

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General