Showing posts with label space. Show all posts
Showing posts with label space. Show all posts

Sunday, March 25, 2012

Connecting to SQL Express on a hosted site

Folks.

I just moved my domain to GoDaddy.com. When I run my website locally, everything works fine.

When I ftp it to my server space on GoDaddy.com, I get a "remote connection" error. Does anyone have an example of a connection string I should be using to connect while on the server?

Thanks!

From looking at their website, they do not appear to offer SQL Server2005 or SQL Server 2005 Express. That'd be why you're getting theerror you are. I'm getting the same dang thing on my hostingservice - 1PlanHost.com. They, for some reason, will not installSQL Express... even though ALL of these starter kits, etc. are using itby default. It's making things quite bothersome for us developers!

If anyone figures out a way to force SQL Express to run within a shared hosting enviroment, let me know!|||

Thanks for your response. GoDaddy does offer SQL Server. You can configure it once you have purchased a hosting package. What they don't offer is any incling of support for it. If I find anything out, I'll let you know.

sqlsql

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

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