How to connect SQL Server to an Oracle database

I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
Server running in AD.
If anyone has done it, kindly let me know since this is new territory for me.
Thanks,
Neil
Install the Oracle client on the SQL Server box.
Configure the client side (SQL Server box) tnsnames, Oracle
alias as needed for your Oracle environment.
Configure a linked server, following the books online topic:
OLE DB Provider for Oracle
as well as the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Fri, 13 Jan 2006 09:31:39 -0800, N.Ordiers
<NOrdiers@.discussions.microsoft.com> wrote:

>I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
>Server running in AD.
>If anyone has done it, kindly let me know since this is new territory for me.
>Thanks,
>Neil

How to connect SQL Server to an Oracle database

I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
Server running in AD.
If anyone has done it, kindly let me know since this is new territory for me
.
Thanks,
NeilInstall the Oracle client on the SQL Server box.
Configure the client side (SQL Server box) tnsnames, Oracle
alias as needed for your Oracle environment.
Configure a linked server, following the books online topic:
OLE DB Provider for Oracle
as well as the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Fri, 13 Jan 2006 09:31:39 -0800, N.Ordiers
<NOrdiers@.discussions.microsoft.com> wrote:

>I need to connect to an Oracle database (8i) running in a UNIX box, with SQ
L
>Server running in AD.
>If anyone has done it, kindly let me know since this is new territory for m
e.
>Thanks,
>Neil

how to connect MySQL?

A naive question on how to connect MySQL DB from my C# application.
Kindly explain the steps to be taken to communicate with this DB.

Hi,

There're probably multiple ways of doing this, but one could be:

== Get an ODBC driver for MySQL, for instance here: http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32

== Use System.Data.Odbc namespace functions withC#

The latter is nicely explained in MSDN with samples, you shouldn't have any problems getting into it easily. Have you considered using SQL Express instead of MySQL? You might get richer functionality out of the SqlClient.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||hey!
Thanx for help. I successfully established connection through first method.
The second one I dont have an idea about what namespace is so didn't try to go that way.It would be helpful if you can shed some light on that method or provide some tutorial link.

Also, I have never heard of SQL express. MySQL is available free and being a student thats the best thing for me. Is SQL express free too? I guess it may be since other express editions are free for students. And is there any extra functionality that would entice me to use SQL express?

regarsd
Sumit Dagar.