Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL Server
Expertise: Beginner
Jun 22, 2000

Connecting to SQL Server 7 via MS-DOS 6.2

I have some complex engine control software that has to run under MS-DOS 6.2, but it needs to transfer data to SQL Server 7. What's the best way to connect to SQL Server from DOS?

You can use OSQL or ISQL to connect to SQL Server from the command line. Both of these utilities are Win32 command-line utilities that allow you to log in to a server and issue any SQL command. The OSQL utility supports the most functionality and uses ODBC to connect to SQL Server. The syntax "osql/?" provides a listing of all OSQL flags.

This syntax connects to a server and issues a query:

osql -S "servername" -U "sa" -d "pubs" -q "SELECT * FROM Authors"
To insert data into a database, you could put OSQL commands in a batch file or provide an input file of SQL INSERT commands. See the SQL Server BOL for details and syntax of OSQL.

If you have a straight DOS box, you need to install the 16-bit client that comes with SQL Server 6.5. Both the client and the 6.5 version of ISQL use DB-Lib, which doesn't support some SQL Server 7 features like unicode columns, varchar columns larger than 255, etc.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date