devxlogo

Connecting to SQL Server 7 via MS-DOS 6.2

Connecting to SQL Server 7 via MS-DOS 6.2

Question:
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?

Answer:
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.

See also  How College Students Can Shape the Future of Tech Responsibility
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist