all groups > sql server (alternate) > october 2005 >
You're in the

sql server (alternate)

group:

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


Re: have sql file and want to run it on an ftp connection John Bell
10/29/2005 12:00:00 AM
sql server (alternate):
Hi

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

John

[quoted text, click to view]

have sql file and want to run it on an ftp connection strawberry
10/29/2005 12:02:18 PM
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

Re: have sql file and want to run it on an ftp connection Erland Sommarskog
10/29/2005 12:25:38 PM
strawberry (1@2.com) writes:
[quoted text, click to view]

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/techinfo/productdoc/2000/books.asp
Re: have sql file and want to run it on an ftp connection strawberry
10/29/2005 10:13:08 PM
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.

[quoted text, click to view]

Re: have sql file and want to run it on an ftp connection strawberry
10/29/2005 10:14:29 PM
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

[quoted text, click to view]

Re: have sql file and want to run it on an ftp connection Erland Sommarskog
10/29/2005 10:41:12 PM
strawberry (1@2.com) writes:
[quoted text, click to view]

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/techinfo/productdoc/2000/books.asp
Re: have sql file and want to run it on an ftp connection strawberry
10/30/2005 7:38:42 AM
ahh, oppsy! . hadn't thought of that!

many thanks.

[quoted text, click to view]

AddThis Social Bookmark Button