I am fairly new to Linux and MSSQL,
can we use shell script to connect to and access MSSQL databse.
If we can is it better to use shell script or is it better to use a programming language PERL/JAVA/PHP to do the same.
Any help is much appreciated
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I would guess it depends on what you want to do. There is the JTDS
open-source JDBC driver on SourceForge that will at least let you make
the connection but it’s just a driver and what you do with it depends on
your experience, at least at some level, with Java. There are also
products like DB Visualizer which can use these (and other) JDBC drivers
to connect to a wide range of databases including Oracle, MySQL,
PostgreSQL, etc. I believe DB Visuzlizer is entirely GUI-based so that
doesn’t help with your scripting. I’m not sure how you would interface
at the command line without going through Java, to be honest, but I
haven’t tried.
Good luck.
runnshine wrote:
| I am fairly new to Linux and MSSQL,
| 1. can we use shell script to connect to and access MSSQL databse.
|
| 2. If we can is it better to use shell script or is it better to use a
| programming language PERL/JAVA/PHP to do the same.
|
| Any help is much appreciated
|
|
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFIfLfA3s42bA80+9kRAgPZAJ9K6GL5833fzhAE8QswX2XKi50HUACeNmsL
iE0Tzv6z+t8wWmui7DjxoRA=
=8TYw
-----END PGP SIGNATURE-----
Thread moved to Applications