Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

drive mapping nt sybase server

19 posts in Windows NT Last posting was on 1998-01-07 15:55:21.0Z
Kathryn Dempsey Posted on 1997-11-25 23:22:42.0Z
Message-ID: <347B5DC2.2261@med.unc.edu>
Date: Tue, 25 Nov 1997 15:22:42 -0800
From: Kathryn Dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
Subject: drive mapping nt sybase server
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 22
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5392
Article PK: 1081471

hi,
my network knowledge is minimal, so here goes...
we have sybase running on 3.52 nt. the server was once in my office and
all was well. now the box resides in a 'server room'. i am mapped to
the server and can access files. i cannot, however, run bcps or any isql
via a batch file, or command line. i have tried explicitly putting the
mapped drive in the batch file or command line and i receive this error:
Operating-system error:
[] (sqiggles)
DB-LIBRARY error:
Netlib state error - Netllib initialization may have failed
does anyone have a clue, i do not, and besides, the 'server room' is
LOCKED. it is increasingly difficult to do my job - help please.
thanks,
kathryn
--
it is good to be alive,
to be able to live in the south,
and to eat sweettarts@.

opinions by:
Kathryn Dempsey
Family Practice
UNC - Chapel Hill
go ecu!


Chris Steains Posted on 1997-11-28 11:50:51.0Z
Subject: Re: drive mapping nt sybase server
From: cls@intravel.com.au (Chris Steains)
Organization: Internet Travel
X-Newsreader: WinVN 0.99.9 (Beta 3) (x86 32bit)
References: <347B5DC2.2261@med.unc.edu>
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Message-ID: <IW#UgP$#8GA.132@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Fri, 28 Nov 1997 06:50:51 -0500
Lines: 33
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5385
Article PK: 1081465

In article <347B5DC2.2261@med.unc.edu>, katdemp@med.unc.edu says...

>
>hi,
>my network knowledge is minimal, so here goes...
>we have sybase running on 3.52 nt. the server was once in my office and
>all was well. now the box resides in a 'server room'. i am mapped to
>the server and can access files. i cannot, however, run bcps or any isql
>via a batch file, or command line. i have tried explicitly putting the
>mapped drive in the batch file or command line and i receive this error:
>Operating-system error:
> [] (sqiggles)
>DB-LIBRARY error:
> Netlib state error - Netllib initialization may have failed
>does anyone have a clue, i do not, and besides, the 'server room' is
>LOCKED. it is increasingly difficult to do my job - help please.
>thanks,
>kathryn
>--
>it is good to be alive,
>to be able to live in the south,
>and to eat sweettarts@.
>
>opinions by:
>Kathryn Dempsey
>Family Practice
>UNC - Chapel Hill
>go ecu!

Kathryn

If you're running these DOS-level utilities then you need to set the DSQUERY
DOS environment variable to be the name of the server you are connecting to.
This is one of those interesting, rarely documented requirements.

Chris Steains
Internet Travel
cls@intravel.com.au


kat dempsey Posted on 1997-12-17 22:30:59.0Z
Message-ID: <349852A3.1268@med.unc.edu>
Date: Wed, 17 Dec 1997 14:30:59 -0800
From: kat dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
To: Chris Steains <cls@intravel.com.au>
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 25
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5346
Article PK: 1081425

hi chris,
you were correct. i was using the 16-bit, instead of the 32 bit for
dsquery. thanks
now, i have a problem with bcp from my pc. if the table ends with a
char, i get attempt to bulk-copy an oversized row to the sql server. if
the table ends in a integer, i get a conversion error. it sounds like
some kind of length error, i guess. i can run the same bat file from my
server without problems. anyone have this prob before?

Chris Steains wrote:
>
> If you're running these DOS-level utilities then you need to set the DSQUERY
> DOS environment variable to be the name of the server you are connecting to.
> This is one of those interesting, rarely documented requirements.
>
> Chris Steains
> Internet Travel
> cls@intravel.com.au

it is good to be alive,
to be able to live in the south,
and to eat sweettarts@.

opinions by:
Kathryn Dempsey
who happens to work at:
Family Practice
UNC - Chapel Hill
go ecu!


kat dempsey Posted on 1997-12-17 21:58:18.0Z
Message-ID: <34984AFA.6783@med.unc.edu>
Date: Wed, 17 Dec 1997 13:58:18 -0800
From: kat dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
To: Chris Steains <cls@intravel.com.au>
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 25
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5347
Article PK: 1081426

hi chris,
you were correct. i was using the 16-bit, instead of the 32 bit for
dsquery. thanks
now, i have a problem with bcp from my pc. if the table ends with a
char, i get attempt to bulk-copy an oversized row to the sql server. if
the table ends in a integer, i get a conversion error. it sounds like
some kind of length error, i guess. i can run the same bat file from my
server without problems. anyone have this prob before?

Chris Steains wrote:
>
> If you're running these DOS-level utilities then you need to set the DSQUERY
> DOS environment variable to be the name of the server you are connecting to.
> This is one of those interesting, rarely documented requirements.
>
> Chris Steains
> Internet Travel
> cls@intravel.com.au

it is good to be alive,
to be able to live in the south,
and to eat sweettarts@.

opinions by:
Kathryn Dempsey
who happens to work at:
Family Practice
UNC - Chapel Hill
go ecu!


Mark A. Parsons Posted on 1997-12-18 23:57:24.0Z
Message-ID: <3499B864.481F@compuserve.com>
Date: Thu, 18 Dec 1997 18:57:24 -0500
From: "Mark A. Parsons" <Iron_Horse@compuserve.com>
Reply-To: Iron_Horse@compuserve.com
Organization: Iron Horse, Inc.
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 48
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5344
Article PK: 1081423

Concerning your error ....

Are you sure your data file has data in a format that will actually fit
your table?

Where did you get your data file from? Did it come from a 'bcp out'
from the same table into which you're now trying to 'bcp in'?

Are you using a format file? the -c option? or the -n option?

You mention 2 errors ... are these generated by the same bcp? The same
data file? the same target table? Both of your errors are explainable
but it would require more info to figure out, e.g., what are your bcp
commands, what do the data file(s) look like, what does your table(s)
look like, etc.

To anwer your question ... "anyone have this prob before?" ... yep ...
been there, done that.

How to fix it? <insert standard response here> ... "It depends."

Can you provide more info?

Thanks,
Mark Parsons
Iron Horse, Inc.

kat dempsey wrote:
>
> hi chris,
> you were correct. i was using the 16-bit, instead of the 32 bit for
> dsquery. thanks
> now, i have a problem with bcp from my pc. if the table ends with a
> char, i get attempt to bulk-copy an oversized row to the sql server. if
> the table ends in a integer, i get a conversion error. it sounds like
> some kind of length error, i guess. i can run the same bat file from my
> server without problems. anyone have this prob before?
>
> Chris Steains wrote:
> >
> > If you're running these DOS-level utilities then you need to set the DSQUERY
> > DOS environment variable to be the name of the server you are connecting to.
> > This is one of those interesting, rarely documented requirements.
> >
> > Chris Steains
> > Internet Travel
> > cls@intravel.com.au
>
> it is good to be alive,
> to be able to live in the south,
> and to eat sweettarts@.
>
> opinions by:
> Kathryn Dempsey
> who happens to work at:
> Family Practice
> UNC - Chapel Hill
> go ecu!


kat dempsey Posted on 1997-12-22 18:01:17.0Z
Message-ID: <349EAAED.1DCA@med.unc.edu>
Date: Mon, 22 Dec 1997 10:01:17 -0800
From: kat dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 47
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5342
Article PK: 1081420


Mark A. Parsons wrote:
>
> Concerning your error ....
>
> Are you sure your data file has data in a format that will actually fit
> your table?

yes, i can run this same bat file from the server, and it runs with no
problem.

>
> Where did you get your data file from? Did it come from a 'bcp out'
> from the same table into which you're now trying to 'bcp in'?no, i did not create the input file with a bcp out, although,
interestingly enough, i am able to to a 'bcp out' from the client.
>
> Are you using a format file? the -c option? or the -n option?-c option
>
> You mention 2 errors ... are these generated by the same bcp? The same
> data file? the same target table? Both of your errors are explainable
> but it would require more info to figure out, e.g., what are your bcp
> commands, what do the data file(s) look like, what does your table(s)
> look like, etc.

the bcp commmands:
bcp d48visit..Tdmvst49 in vis48spx.inp -e vs48err.log -c -U id
-P secretpswrd
the table structure:
fld1 char 12
fld2 char 27
fld3 char 1
fld4 small datetime
fld5 small datetime
fld6 char 15
fld7 char 32
fld8 small datetime
fld8 char 1
the input file is formatted from a c program, delimited by tabs, and new
line at end of row. i added a char at the end, and i get the message,
Attempt to bulk-copy and oversized row to the SQL Server.
before i added the field, i was getting the message,
Attempt to convert data stopped by syntax error in source field.
the wacky part is, that this will execute cleanly on the server, which
leads me to believe, i have missed something on the client end.
thanks,
kathryn
>
> How to fix it? <insert standard response here> ... "It depends."
>
> Can you provide more info?
>
> Thanks,
> Mark Parsons
> Iron Horse, Inc.
>


Kent Friberg Posted on 1998-01-06 21:41:00.0Z
From: "Kent Friberg" <kefriber@NoSpam.online.no>
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu>
Subject: Re: drive mapping nt sybase server and now bcp probs
Date: Tue, 6 Jan 1998 22:41:00 +0100
Lines: 36
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <QLCmwOuG9GA.138@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5312
Article PK: 1081387


kat dempsey wrote in message <349EAAED.1DCA@med.unc.edu>...
>yes, i can run this same bat file from the server, and it runs with no
>problem.

<.....lotsa info snipped.....>

Hello Kathryn,

I had an encounter with the msg:
"Attempt to bulk-copy and oversized row to the SQL Server"
today, and allthough the bcp program did manage to get the data in to the
table and the msg seemed like more of an informational msg, I did a dejanews
search and found this thread.

I did not find very much of interest for my problem here but decided to
try out the tip: 'try compare a newly bcp-out file with the one your are
trying to bcp in'

The difference I found in the two files was the layout of the
datetime-fields. In the bcp-file we created the datetime-field was something
like "01/01/1998" (I'm not sure cus' I am now at home and do not have access
to this bcp-file) while the file generated from the bcp-out operation was
more like "1 january 1997 12:00:00 lotsa stuff AM or something" To get these
ones more exact you'll have to try it I guess.

Another thing I found was that using and older version of the bcp
executables eliminated the errormsg, but as I said earlier - the bcp program
*did* manage to get the data into the table with both bcp-versions. Maybe
you are running different versions of the bcp-prg on the client/server ??
(bcp -v)

-K


kat dempsey Posted on 1998-01-07 15:38:31.0Z
Message-ID: <34B3A177.559@med.unc.edu>
Date: Wed, 07 Jan 1998 07:38:31 -0800
From: kat dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu> <QLCmwOuG9GA.138@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 44
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5311
Article PK: 1081389

hi kent,
mark parsons suggested these things and i have moved the bcp executable
from the server to the client and still had the same results. note: the
bcp executable on the server actually had an older date. i did receive
the same message you did when the last row of the table was a char, and
it did load successfully, however when the last row of the table is a
datetime, it produces a fatal message and will not load.
thanks and i'll keep plugging.
kathryn

> Hello Kathryn,
>
> I had an encounter with the msg:
> "Attempt to bulk-copy and oversized row to the SQL Server"
> today, and allthough the bcp program did manage to get the data in to the
> table and the msg seemed like more of an informational msg, I did a dejanews
> search and found this thread.
>
> I did not find very much of interest for my problem here but decided to
> try out the tip: 'try compare a newly bcp-out file with the one your are
> trying to bcp in'
>
> The difference I found in the two files was the layout of the
> datetime-fields. In the bcp-file we created the datetime-field was something
> like "01/01/1998" (I'm not sure cus' I am now at home and do not have access
> to this bcp-file) while the file generated from the bcp-out operation was
> more like "1 january 1997 12:00:00 lotsa stuff AM or something" To get these
> ones more exact you'll have to try it I guess.
>
> Another thing I found was that using and older version of the bcp
> executables eliminated the errormsg, but as I said earlier - the bcp program
> *did* manage to get the data into the table with both bcp-versions. Maybe
> you are running different versions of the bcp-prg on the client/server ??
> (bcp -v)
>
> -K

--


kat dempsey Posted on 1998-01-07 15:55:21.0Z
Message-ID: <34B3A569.4EE6@med.unc.edu>
Date: Wed, 07 Jan 1998 07:55:21 -0800
From: kat dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu> <QLCmwOuG9GA.138@forums.powersoft.com> <34B3A177.559@med.unc.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5310
Article PK: 1081388

ok, my face is red. thanks mark,kent, cuz that was the problem in the
first place. actually i was using the bcp from the server - which was an
older version. i had the path hardcoded. the new version was on the
client, but i was not using it. i moved the bcp executable from the
client to the server and it works fine on this end. i'll test it from
the server now.
again thanks to all for their help and let's end this sticky thread.
thanks,
kathryn


Mark A. Parsons Posted on 1997-12-25 15:17:54.0Z
Message-ID: <34A27922.6BB1@compuserve.com>
Date: Thu, 25 Dec 1997 10:17:54 -0500
From: "Mark A. Parsons" <Iron_Horse@compuserve.com>
Reply-To: Iron_Horse@compuserve.com
Organization: Iron Horse, Inc.
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 38
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5334
Article PK: 1081411

What do you mean by you can run the bcp 'from the server'? Are you
saying that the bcp command works just fine form the command line on the
actual server?

Are you using the same bcp binary on both boxes? I'm wondering if you
may have an old, or buggie, version on your client machine?

One other thing I'd do ... make sure your table has a couple rows in
it. Then, bcp this data out to a file (do this on both the client and
server machines). Now, for each machine ... 1) delete data from table
and 2) turn right around and bcp your bcp-out file back into the table.
Any failures from the client or server?

If you're still getting a failure when doing a bcp-in of your bcp-out
file (from the client) then it sounds like you have a problem with your
version of bcp ... see if you can re-install or replace it.

If you're not getting any errors when you bcp-in your bcp-out file ...
then compare the format of your bcp-out file with what's being generated
by your C program. (Make sure your C program is generating the same set
of data as what's in the table/bcp-out file .. this'll make the
comparison easier).

Ohhhhh ... one other question ... what OS platforms are your 'client'
and 'server'? I have seen many cases where the same bcp file will not
work on a PC but will on a UNIX box .. or vice versa. Has to do with
slight differences in how character sets are interpreted/processed.

--

Mark Parsons
Iron Horse, Inc.
[Team Sybase]


kat dempsey Posted on 1997-12-29 21:30:35.0Z
Message-ID: <34A8167B.7F14@med.unc.edu>
Date: Mon, 29 Dec 1997 13:30:35 -0800
From: kat dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu> <34A27922.6BB1@compuserve.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 36
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5332
Article PK: 1081410

hi mark,

>
> What do you mean by you can run the bcp 'from the server'? Are you
> saying that the bcp command works just fine form the command line on the
> actual server?yep, actually i have the bcp set up in a bat file. it has been working

correctly on the server for some time now - it's in the nt schedule.

> Are you using the same bcp binary on both boxes? I'm wondering if you
> may have an old, or buggie, version on your client machine? these appear to be the same

> One other thing I'd do ... make sure your table has a couple rows in
> it. Then, bcp this data out to a file (do this on both the client and
> server machines). Now, for each machine ... 1) delete data from table
> and 2) turn right around and bcp your bcp-out file back into the table.
> Any failures from the client or server?this works! the file looks identical to what my c pgm produces.

>
> Ohhhhh ... one other question ... what OS platforms are your 'client'
> and 'server'? I have seen many cases where the same bcp file will not
> work on a PC but will on a UNIX box .. or vice versa. Has to do with
> slight differences in how character sets are interpreted/processed. yeah, this is what i've been leaning toward. my client is a
win95,server nt, so, you'd think that would work. i have been playing
around with the char set options for bcp, but no luck so far.
thanks again,
kathryn


Mark A. Parsons Posted on 1997-12-29 23:49:40.0Z
Message-ID: <34A83714.2F9A@compuserve.com>
Date: Mon, 29 Dec 1997 18:49:40 -0500
From: "Mark A. Parsons" <Iron_Horse@compuserve.com>
Reply-To: Iron_Horse@compuserve.com
Organization: Iron Horse, Inc.
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu> <34A27922.6BB1@compuserve.com> <34A8167B.7F14@med.unc.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 25
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5331
Article PK: 1081409

Since the bcp out and back in works ... no offense ... I'd say your C
program isn't kicking out *exactly* the same thing. Possibly an extra
non-printing character in there somewhere? null terminator character on
your character columns? using a mix of <LF> and <CR> which isn't the
same mix that bcp is generating when it creates the output file?

Can you do a comparison of the bcp and C program files ... get character
counts? are the files the same exact size in terms of bytes?

kat dempsey wrote:
>
> > One other thing I'd do ... make sure your table has a couple rows in
> > it. Then, bcp this data out to a file (do this on both the client and
> > server machines). Now, for each machine ... 1) delete data from table
> > and 2) turn right around and bcp your bcp-out file back into the table.
> > Any failures from the client or server?this works! the file looks identical to what my c pgm produces.

--

Mark Parsons
Iron Horse, Inc.
[Team Sybase]


kat dempsey Posted on 1997-12-30 22:48:04.0Z
Message-ID: <34A97A24.6E8D@med.unc.edu>
Date: Tue, 30 Dec 1997 14:48:04 -0800
From: kat dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu> <34A27922.6BB1@compuserve.com> <34A8167B.7F14@med.unc.edu> <34A83714.2F9A@compuserve.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 27
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5328
Article PK: 1081406


Mark A. Parsons wrote:
>
> Since the bcp out and back in works ... no offense ... I'd say your C
> program isn't kicking out *exactly* the same thing. Possibly an extra
> non-printing character in there somewhere? null terminator character on
> your character columns? using a mix of <LF> and <CR> which isn't the
> same mix that bcp is generating when it creates the output file?
>
> Can you do a comparison of the bcp and C program files ... get character
> counts? are the files the same exact size in terms of bytes?

i went through the input file a number of times, and cannot detect any
differences. the main thing that bothers me, is that the bcp works when
run from the server directly. what you say is logical, but i should be
able to run the same bat file from the server and pc without further file
manipulation. i tend to agree with you other statment about char sets
and recognition from server vs client. wouldn't that be logical, if i
bcp - out on the client, and it did accept that file?
thanks for your help,
kathryn


John McVicker Posted on 1998-01-03 04:24:57.0Z
Message-ID: <34ADBD99.ED6C6E7C@sybase.com>
Date: Fri, 02 Jan 1998 23:24:57 -0500
From: John McVicker <mcvicker@sybase.com>
Reply-To: mcvicker@sybase.com
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.04 [en] (Win95; U)
MIME-Version: 1.0
To: kat dempsey <katdemp@med.unc.edu>
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu> <34A27922.6BB1@compuserve.com> <34A8167B.7F14@med.unc.edu> <34A83714.2F9A@compuserve.com> <34A97A24.6E8D@med.unc.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 59
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5319
Article PK: 1081397

Kat,
I don't know if this will help, but I noticed mention of the "Server" and
"Client"
here. NT Server uses a character set of cp850 (including BCP, ISQL, etc).
However, "Clients" tend to use iso_1 as their default. Such as Win95 or
Win3.x
Look in your Client's file: %SYBASE%\LOCALES\LOCALES.DAT under
the section relating to the client ([win95] for Windows 95, for instance).
You'll
probably see the line with "default" setup with iso_1. You may want to set
that
to cp850 to keep the character sets the same on client and server. And,
this is a simple way to try to keep all client/server character set conversion

processing to a minimum or none at all (it does have to convert from cp850
to iso_1 while sending results back if not changed). If I had a fully NT and
Win95 environment, I'd make sure all clients were using the same charset
as the server - that being cp850.

kat dempsey wrote:

> Mark A. Parsons wrote:
> >
> > Since the bcp out and back in works ... no offense ... I'd say your C
> > program isn't kicking out *exactly* the same thing. Possibly an extra
> > non-printing character in there somewhere? null terminator character on
> > your character columns? using a mix of <LF> and <CR> which isn't the
> > same mix that bcp is generating when it creates the output file?
> >
> > Can you do a comparison of the bcp and C program files ... get character
> > counts? are the files the same exact size in terms of bytes?
>
> i went through the input file a number of times, and cannot detect any
> differences. the main thing that bothers me, is that the bcp works when
> run from the server directly. what you say is logical, but i should be
> able to run the same bat file from the server and pc without further file
> manipulation. i tend to agree with you other statment about char sets
> and recognition from server vs client. wouldn't that be logical, if i
> bcp - out on the client, and it did accept that file?
> thanks for your help,
> kathryn

--
John McVicker
Principal Consultant, District Lead Architect
Sybase Professional Services
Pennsylvania/New Jersey District
301-896-1765
mcvicker@sybase.com, mcvicker@bellatlantic.net, JohnMcVicker@compuserve.com

http://www.sybase.com
http://www.powersoft.com
http://www.isug.com


kat dempsey Posted on 1998-01-06 22:19:55.0Z
Message-ID: <34B2AE0B.D28@med.unc.edu>
Date: Tue, 06 Jan 1998 14:19:55 -0800
From: kat dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu> <34A27922.6BB1@compuserve.com> <34A8167B.7F14@med.unc.edu> <34A83714.2F9A@compuserve.com> <34A97A24.6E8D@med.unc.edu> <34ADBD99.ED6C6E7C@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 73
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5313
Article PK: 1081390

hi john, chris,
ok, i've tried a number of scenarios, changing to cp850 and iso_1. the
one interesting thing i have discovered, in the locales.dat on the
client, the default for the nt is iso_1. when i change that to cp850, i
get the os connection error when running the bcp, also i get a connection
error when using wisql.
i also included -J cp850 and -J iso_1 in the bcp file.
thanks for your help with this.
kathryn

John McVicker wrote:
>
> Kat,
> I don't know if this will help, but I noticed mention of the "Server" and
> "Client"
> here. NT Server uses a character set of cp850 (including BCP, ISQL, etc).
> However, "Clients" tend to use iso_1 as their default. Such as Win95 or
> Win3.x
> Look in your Client's file: %SYBASE%\LOCALES\LOCALES.DAT under
> the section relating to the client ([win95] for Windows 95, for instance).
> You'll
> probably see the line with "default" setup with iso_1. You may want to set
> that
> to cp850 to keep the character sets the same on client and server. And,
> this is a simple way to try to keep all client/server character set conversion
>
> processing to a minimum or none at all (it does have to convert from cp850
> to iso_1 while sending results back if not changed). If I had a fully NT and
> Win95 environment, I'd make sure all clients were using the same charset
> as the server - that being cp850.
>
> kat dempsey wrote:
>
> > Mark A. Parsons wrote:
> > >
> > > Since the bcp out and back in works ... no offense ... I'd say your C
> > > program isn't kicking out *exactly* the same thing. Possibly an extra
> > > non-printing character in there somewhere? null terminator character on
> > > your character columns? using a mix of <LF> and <CR> which isn't the
> > > same mix that bcp is generating when it creates the output file?
> > >
> > > Can you do a comparison of the bcp and C program files ... get character
> > > counts? are the files the same exact size in terms of bytes?
> >
> > i went through the input file a number of times, and cannot detect any
> > differences. the main thing that bothers me, is that the bcp works when
> > run from the server directly. what you say is logical, but i should be
> > able to run the same bat file from the server and pc without further file
> > manipulation. i tend to agree with you other statment about char sets
> > and recognition from server vs client. wouldn't that be logical, if i
> > bcp - out on the client, and it did accept that file?
> > thanks for your help,
> > kathryn
>
> --
> John McVicker
> Principal Consultant, District Lead Architect
> Sybase Professional Services
> Pennsylvania/New Jersey District
> 301-896-1765
> mcvicker@sybase.com, mcvicker@bellatlantic.net, JohnMcVicker@compuserve.com
>
> http://www.sybase.com
> http://www.powersoft.com
> http://www.isug.com


Mark A. Parsons Posted on 1997-12-31 00:03:21.0Z
Message-ID: <34A98BC9.3267@compuserve.com>
Date: Tue, 30 Dec 1997 19:03:21 -0500
From: "Mark A. Parsons" <Iron_Horse@compuserve.com>
Reply-To: Iron_Horse@compuserve.com
Organization: Iron Horse, Inc.
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: drive mapping nt sybase server and now bcp probs
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu> <34A27922.6BB1@compuserve.com> <34A8167B.7F14@med.unc.edu> <34A83714.2F9A@compuserve.com> <34A97A24.6E8D@med.unc.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 26
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5327
Article PK: 1081405


kat dempsey wrote:
>
> i went through the input file a number of times, and cannot detect any
> differences. the main thing that bothers me, is that the bcp works when
> run from the server directly. what you say is logical, but i should be
> able to run the same bat file from the server and pc without further file
> manipulation. i tend to agree with you other statment about char sets
> and recognition from server vs client. wouldn't that be logical, if i
> bcp - out on the client, and it did accept that file?
> thanks for your help,
> kathryn

Have you tried doing the bcp out and back in from the client? Did it
work? If it didn't work ... I've give Sybase TS a call.

If the bcp out and back in *does* work from the client .. then, yeah, it
sounds like a character set problem. With the current process
(generating the output file from your C program) do you get any sort of
character set mismatch/error warnings from bcp?
--

Mark Parsons
Iron Horse, Inc.
[Team Sybase]


Chris Steains Posted on 1998-01-02 10:12:25.0Z
Subject: Re: drive mapping nt sybase server and now bcp probs
From: cls@intravel.com.au (Chris Steains)
Organization: Internet Travel
X-Newsreader: WinVN 0.99.9 (Beta 3) (x86 32bit)
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com> <34984AFA.6783@med.unc.edu> <3499B864.481F@compuserve.com> <349EAAED.1DCA@med.unc.edu> <34A27922.6BB1@compuserve.com> <34A8167B.7F14@med.unc.edu> <34A83714.2F9A@compuserve.com> <34A97A24.6E8D@med.unc.edu> <34A98BC9.3267@compuserve.com>
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Message-ID: <l04Asb2F9GA.146@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Fri, 02 Jan 1998 05:12:25 -0500
Lines: 36
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5322
Article PK: 1081403

In article <34A98BC9.3267@compuserve.com>, Iron_Horse@compuserve.com
says...

>
>kat dempsey wrote:
>>
>> i went through the input file a number of times, and cannot detect any
>> differences. the main thing that bothers me, is that the bcp works when
>> run from the server directly. what you say is logical, but i should be
>> able to run the same bat file from the server and pc without further file
>> manipulation. i tend to agree with you other statment about char sets
>> and recognition from server vs client. wouldn't that be logical, if i
>> bcp - out on the client, and it did accept that file?
>> thanks for your help,
>> kathryn
>
>Have you tried doing the bcp out and back in from the client? Did it
>work? If it didn't work ... I've give Sybase TS a call.
>
>If the bcp out and back in *does* work from the client .. then, yeah, it
>sounds like a character set problem. With the current process
>(generating the output file from your C program) do you get any sort of
>character set mismatch/error warnings from bcp?
>--
>
>Mark Parsons
>Iron Horse, Inc.
>[Team Sybase]

Character set could be the problem. Under the NT install of Sybase, the server
seems to default to cp850 character set while the client side uses the iso
character set. If you set the SQL server to the iso one this may make a
difference.

Chris Steains
cls@intravel.com.au


Kathryn Dempsey Posted on 1997-12-01 23:48:42.0Z
Message-ID: <34834CDA.6116@med.unc.edu>
Date: Mon, 01 Dec 1997 15:48:42 -0800
From: Kathryn Dempsey <katdemp@med.unc.edu>
Organization: UNC-CH School of Medicine
X-Mailer: Mozilla 2.0 (Win16; I)
MIME-Version: 1.0
To: Chris Steains <cls@intravel.com.au>
Subject: Re: drive mapping nt sybase server
References: <347B5DC2.2261@med.unc.edu> <IW#UgP$#8GA.132@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 41
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5380
Article PK: 1081463

thanks for the info, i believe i am set up correctly there..

Chris Steains wrote:
>
> In article <347B5DC2.2261@med.unc.edu>, katdemp@med.unc.edu says...
> >
> >hi,
> >my network knowledge is minimal, so here goes...
> >we have sybase running on 3.52 nt. the server was once in my office and
> >all was well. now the box resides in a 'server room'. i am mapped to
> >the server and can access files. i cannot, however, run bcps or any isql
> >via a batch file, or command line. i have tried explicitly putting the
> >mapped drive in the batch file or command line and i receive this error:
> >Operating-system error:
> > [] (sqiggles)
> >DB-LIBRARY error:
> > Netlib state error - Netllib initialization may have failed
> >does anyone have a clue, i do not, and besides, the 'server room' is
> >LOCKED. it is increasingly difficult to do my job - help please.
> >thanks,
> >kathryn
> >--
> >it is good to be alive,
> >to be able to live in the south,
> >and to eat sweettarts@.
> >
> >opinions by:
> >Kathryn Dempsey
> >Family Practice
> >UNC - Chapel Hill
> >go ecu!
> Kathryn
>
> If you're running these DOS-level utilities then you need to set the DSQUERY
> DOS environment variable to be the name of the server you are connecting to.
> This is one of those interesting, rarely documented requirements.
>
> Chris Steains
> Internet Travel
> cls@intravel.com.au

--
it is good to be alive,
to be able to live in the south,
and to eat sweettarts@.

opinions by:
Kathryn Dempsey
Family Practice
UNC - Chapel Hill
go ecu!


Reinoud van Leeuwen Posted on 1997-11-28 10:05:08.0Z
Message-ID: <347E9754.3B43@sybase.com>
Date: Fri, 28 Nov 1997 11:05:08 +0100
From: Reinoud van Leeuwen <reinoud@sybase.com>
Organization: Sybase Inc.
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
To: Kathryn Dempsey <katdemp@med.unc.edu>
Subject: Re: drive mapping nt sybase server
References: <347B5DC2.2261@med.unc.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 31
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5387
Article PK: 1081467


Kathryn Dempsey wrote:
>
> hi,
> my network knowledge is minimal, so here goes...
> we have sybase running on 3.52 nt. the server was once in my office and
> all was well. now the box resides in a 'server room'. i am mapped to
> the server and can access files. i cannot, however, run bcps or any isql
> via a batch file, or command line. i have tried explicitly putting the
> mapped drive in the batch file or command line and i receive this error:
> Operating-system error:
> [] (sqiggles)
> DB-LIBRARY error:
> Netlib state error - Netllib initialization may have failed
> does anyone have a clue, i do not, and besides, the 'server room' is
> LOCKED. it is increasingly difficult to do my job - help please.
> thanks,
> kathryn

Kathryn ,
Is the Open Client installed on your local computer? This error message
sounds like the bcp or isql utilties cannot find some libraries they
need. (Thos libraries are implemented in .dll files on Windows
computers).
When you install Open Client locally, you should be able to run bcp,
isql, wisql and other applications than use Sybase drivers.

Reinoud van Leeuwen
Sybase Professional Services Maarssen / The Netherlands