Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
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

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap