Thursday, March 8, 2012

Connecting to an Oracle Databse Server using SQL Express

Hello everyone,

I am working on a project for a professor. The project entails

designing and creating a database.We

were given individual space on the schools database server and we were given

SSH secure shell to connect and manage our respective databases.I took it upon myself to try out SQL Server

Express.Using the management studio I

am trying to connect to my school database and can’t seem to figure it

out.Can someone please give a noob some

simple and quick instructions on how to achieve this?

Thank you,

Your Friendly Neighborhood Programmer,

This is the SSH product in case any one was interested, ftp://ftp.ssh.com/pub/ssh/SSHSecureShellClient-3.2.9.exe

The title of your post is a little confusing. SQL Server Express Management tools don't connect to Oracle directly, unless you use an OPENQUERY statement or create a linked server. You can read more about those topics in Books Online. For more basic information on connecting to a database, check here:

http://msdn2.microsoft.com/en-us/library/ms345332.aspx

Microsoft also puts out a complete training series for free on Express:

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

Buck Woody

No comments:

Post a Comment