| Author |
Topic |
|
mallikarjuna_
Starting Member
20 Posts |
 Posted - 2004-07-05 : 05:04:50
|
| Hi , Can some one tell me what the problem is when using an isql command , doesnt retrieve data, but there is no problem in retrieving data using query analyzer, on one particular SQL Server 2000 instnace? What settings on the server could be wrong?Thnks & Rgds |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-07-05 : 05:36:39
|
| post the isql statement....the abstract (short) description you have given is quite vague. an example of the problem code....will advance a solution to this a lot faster. |
 |
|
|
mallikarjuna_
Starting Member
20 Posts |
Posted - 2004-07-05 : 05:40:52
|
| Hi, the isql commad is isql -S svr_1 d db_1 U user_1 -P password -q "select * from table_1" |
|
|
|
pjn
Starting Member
27 Posts |
Posted - 2004-07-05 : 06:52:47
|
| Do you need to use the -d <database> switch to select the correct database?I notice that you've only got 'd' in your command, not '-d' |
|
|
|
mallikarjuna_
Starting Member
20 Posts |
Posted - 2004-07-05 : 06:55:45
|
| shoot ...typo error while posting the msg...-d was used |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-05 : 11:57:32
|
| Why don't you post the exact isql you are using instead of an example. We can all type examples correctly. Show us exactly what you are using. When you login to Query Anaylyzer, are you using the same user?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mallikarjuna_
Starting Member
20 Posts |
Posted - 2004-07-05 : 13:23:55
|
| not to be meanwell,, other than svr name, db name , user name and password.. the best i can say is "select * from discipline"are the other details.. relevant?? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-05 : 13:31:25
|
| And, have you tried to run it in Query Analyzer logging in as the same user. And, yes the other details are relevant because it's obviously failing, which means you've missed one of those other details.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-05 : 14:00:31
|
| Indeeie - there's no hyphen in front of the U parameter, for example. But I assumed that was a typo in the example too.Anyways, armed with the real database name, user id and password we'll be able to hack in and identify all future problems before-they-happen, and save a whole pile of future-grief, won't we?!!Kristen |
|
|
|
mallikarjuna_
Starting Member
20 Posts |
Posted - 2004-07-05 : 14:54:48
|
| no mood |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-06 : 05:43:57
|
| Sorry, don't understand your reply, but if you took offence I didn't mean any and appologise.Kristen |
|
|
|
|
ISQL Problem