simple exe client for inserts to mssql

[wolfsheim]

Can someone suggest a simple exe that I could use on an xp workstation without any mssql dlls to perform an insert of a data row to a remote mssql db that has had a local DSN ODBC setup in the control panel ? I was thinking osql, but I am not sure what other DLLs I'd have to bring along with it.
Thanks

 

[hwkranger]

Can I ask why you need this?

And what manner it will be used?

Randall Vollen
National City Bank Corp.

 

[wolfsheim]

sure, my program polls for a certain VoIP (ip telephony) usage value every 5 minutes. The PC doing the polling has a vpn connection to the mssql server in question. Once I get the result, I need to write the result (insert the data) into a table on the mssql box. Is that clear ?? Thanks for repsonding.

 

[mrdenny]

osql should do the trick (or isql). I don't think they require any DLLs.

You could always write something in like VB4 or VB6, but those would need a couple of dlls to be installed.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[RAS56]

As was suggested earlier, you can use OSQL for things like this. The syntax is pretty simple. For instance, here is a command string to display a record:

osql -S(local) -E -d my_data -q "select top 1 name from users order by name"

Run osql -? to see the command line syntax. It is case sensitive. The biggest issue I have found is if you have clients that don't have the SQL Client Tools installed, they won't have osql. I think (not positive about this though) the only file required to run it however, is osql.exe.