Solved

isql?

Posted on 1998-07-07
10
743 Views
Last Modified: 2008-02-07
Im using isql to access the sybase server.
Im using this syntax,
isql -w 130 -i in.txt -o out.txt
However, isql says it cant open in.txt. I assume this is because it cant find it. What path should this file be put at so that the isql can locate it?
0
Comment
Question by:Coates
  • 5
  • 5
10 Comments
 
LVL 7

Accepted Solution

by:
spiridonov earned 20 total points
ID: 1098160
It should be in the directory you runnning isql from , but I would still suggest to put full path, just to make sure you are using the file you intended to use. You can also use '<' filename instead of -i filename
0
 

Author Comment

by:Coates
ID: 1098161
Ive tried using the full path. Ive also triied the following code.
isql -w 132 -i c:\in.txt -o c\:out.txt
This gives me an error
Cant find input file c:in.txt
Ive also tried -i /in.txt
-i c:/in.txt
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1098162
Have you tried using '<' redirector ?
0
 

Author Comment

by:Coates
ID: 1098163
I get another error using this syuntax:
ksh: c:\in.txt:cannot open
Am i using the correct path format?
Do i use a '\' or a '/'??
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1098164
What operatin system do you use?
May be obvious, but happens: is the file realy exists? Do you have permission to read it?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:Coates
ID: 1098165
Im using windows 95
The file is a standard .txt file located on my c:\ directory
I am using telnet to access the Unix sybase server
isql < c:\in.txt >c:|out.txt
this is what ive just tried and got the same error!
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1098166
If I correctly understood, you are trying to type this in telnet window. When you use a telnet, your computer emulates terminal, telnet doesn't know anything about your c: drive. and if you are using just in.txt this in.txt should be present not in your PC, but in the  UNIX server directory you are executing isql from.
0
 

Author Comment

by:Coates
ID: 1098167
Is there any way to use a local input file??
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1098168
No , unless there  is a Windows version  of isql, that you can install and run from you PC, not from telnet session.
0
 

Author Comment

by:Coates
ID: 1098169
OK thanks!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now