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

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

Connect Two Databases Together

I am interested in having two databases that are on the same server
connected together. I have the individual databases but I also want to have
a common database that keeps stored procedures to do things such as changing
password. I don't want to cut and paste them into each database each time
plus if I ever made a change I am creating a lot of work for myself.
Users would have the same login and password for the two databases. What is
the simpliest way to set this up?
Thanks
Can
There are several options, ranging from linking tables, to managing them
both with common scripts. It really depends on why you want them to be
separate databases instead of a single database, and then why you want
certain things in common -- ease of maintenance, security, or something
else?
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Can" <Can@.discussions.microsoft.com> wrote in message
news:74E21166-FD11-46E5-AF30-A7415D2D331D@.microsoft.com...
> I am interested in having two databases that are on the same server
> connected together. I have the individual databases but I also want to
> have
> a common database that keeps stored procedures to do things such as
> changing
> password. I don't want to cut and paste them into each database each time
> plus if I ever made a change I am creating a lot of work for myself.
> Users would have the same login and password for the two databases. What
> is
> the simpliest way to set this up?
> Thanks
> Can
>
|||I am looking to llink stored procedures, not tables, from one database to
another for ease of maintenance. What direction do you suggest?
"Jeff A. Stucker" wrote:

> There are several options, ranging from linking tables, to managing them
> both with common scripts. It really depends on why you want them to be
> separate databases instead of a single database, and then why you want
> certain things in common -- ease of maintenance, security, or something
> else?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "Can" <Can@.discussions.microsoft.com> wrote in message
> news:74E21166-FD11-46E5-AF30-A7415D2D331D@.microsoft.com...
>
>

Connect Two Databases Together

I am interested in having two databases that are on the same server
connected together. I have the individual databases but I also want to have
a common database that keeps stored procedures to do things such as changing
password. I don't want to cut and paste them into each database each time
plus if I ever made a change I am creating a lot of work for myself.
Users would have the same login and password for the two databases. What is
the simpliest way to set this up?
Thanks
CanThere are several options, ranging from linking tables, to managing them
both with common scripts. It really depends on why you want them to be
separate databases instead of a single database, and then why you want
certain things in common -- ease of maintenance, security, or something
else?
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Can" <Can@.discussions.microsoft.com> wrote in message
news:74E21166-FD11-46E5-AF30-A7415D2D331D@.microsoft.com...
> I am interested in having two databases that are on the same server
> connected together. I have the individual databases but I also want to
> have
> a common database that keeps stored procedures to do things such as
> changing
> password. I don't want to cut and paste them into each database each time
> plus if I ever made a change I am creating a lot of work for myself.
> Users would have the same login and password for the two databases. What
> is
> the simpliest way to set this up?
> Thanks
> Can
>|||I am looking to llink stored procedures, not tables, from one database to
another for ease of maintenance. What direction do you suggest?
"Jeff A. Stucker" wrote:

> There are several options, ranging from linking tables, to managing them
> both with common scripts. It really depends on why you want them to be
> separate databases instead of a single database, and then why you want
> certain things in common -- ease of maintenance, security, or something
> else?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Senior Consultant
> www.rapidigm.com
> "Can" <Can@.discussions.microsoft.com> wrote in message
> news:74E21166-FD11-46E5-AF30-A7415D2D331D@.microsoft.com...
>
>