I'm trying to make a connection with a remote sql database from prompt... I have some tools who can make a connection but only to your localhost. Would it be possible to make a connection to a remote one.

Or attleast send a qeury remote.

try myslqfront

http://www.mysqlfront.de/download.html

i tried the program but couldn't figure out how you can do that from prompt doing it from explorer is a cewl feature but down side is that the gui is still needed

OSQL

u can find a lot of info on the board/google
/edit
btw..I was referring to MS-SQL

you'd forgottten to tell us what kind of SQL you are try'n to connect to ..
mssql? mysql ? oracle? ??
but however each one has its own "commandlined" application

it doesn't matter which one i will use anyone i know about bthe command line interfaces but the ones i try didn't have a option to connect to a server remote.


thnx whiskah will try it


thnx for ur help guys

Steal osql.exe from any MSSQL Version and you have a Client to connect to hosts and can run querys!

Mysql has their own client at their site. There is a -h option for the host to connect to. Often the problem is not with the client, but many databases only allow local connections.

for MSSQL:
(for help: osql -?)


for MySQL:
(for help: mysql -?)