Microsoft SQL Server forum - have sql file and want to run it on an ftp connection

Author

have sql file and want to run it on an ftp connection

strawberry

2005-10-29, 7:23 am

i have a db set up that i access using an ftp connection, and an sql script
file that i wish to run, how do i go about doing so?

tia

Erland Sommarskog

2005-10-29, 9:23 am

strawberry (1@2.com) writes:
> i have a db set up that i access using an ftp connection, and an sql
> script file that i wish to run, how do i go about doing so?

You have an SQL Server database that you access through FTP? Maybe I'm
dense, but I don't understand how you could do that?

Of course, if your FTP client permits you to run remote scripts, you
could upload your script, and then run it with OSQL.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

John Bell

2005-10-29, 11:23 am

Hi

Why can you not get access to connect to the remote server, possibly through
a VPN?

John

"strawberry" <1@2.com> wrote in message
news:exJ8f.19119$6i4.3749@newsfe7-gui.ntli.net...
>i have a db set up that i access using an ftp connection, and an sql script
>file that i wish to run, how do i go about doing so?
>
> tia
>

strawberry

2005-10-30, 3:25 am

this is half the problem, I'm not sure how or where to execute the file I've
tried all sorts but suspect i don't have the correct privileges ( its a
university server)

thanks for your reply.

"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:436396ac$0$361$
da0feed9@news.zen.co.uk...
> Hi
>
> Why can you not get access to connect to the remote server, possibly
> through a VPN?
>
> John
>
> "strawberry" <1@2.com> wrote in message
> news:exJ8f.19119$6i4.3749@newsfe7-gui.ntli.net...
>
>

strawberry

2005-10-30, 3:25 am

its hosted on a linux server which has ftp access to it. what is osql?, and
where is the best place to upload it too ?

thanks for your reply

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns96FE92704E4B
5Yazorman@127.0.0.1...
> strawberry (1@2.com) writes:
>
> You have an SQL Server database that you access through FTP? Maybe I'm
> dense, but I don't understand how you could do that?
>
> Of course, if your FTP client permits you to run remote scripts, you
> could upload your script, and then run it with OSQL.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>

Erland Sommarskog

2005-10-30, 3:25 am

strawberry (1@2.com) writes:
> its hosted on a linux server which has ftp access to it. what is osql?,
> and where is the best place to upload it too ?

The database is on a Linux server? OK, then you are in the wrong newsgroup.
This newsgroup is about MS SQL Server, which runs only on Windows. (And
OSQL is a command-line tool to access MS SQL Server. On Windows.)

I recommend that you find out which DB engine you are using, and then
find the a forum that engine. Or even better ask the staff at the
university where the DB engine is.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

strawberry

2005-10-30, 3:25 am

ahh, oppsy! . hadn't thought of that!

many thanks.

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns96FF6A8A99F2
Yazorman@127.0.0.1...
> strawberry (1@2.com) writes:
>
> The database is on a Linux server? OK, then you are in the wrong
> newsgroup.
> This newsgroup is about MS SQL Server, which runs only on Windows. (And
> OSQL is a command-line tool to access MS SQL Server. On Windows.)
>
> I recommend that you find out which DB engine you are using, and then
> find the a forum that engine. Or even better ask the staff at the
> university where the DB engine is.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>

Sponsored Links