home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 8 Other
/
08-Other.zip
/
SQLFIX1.ZIP
/
SQLFIX1.TXT
Wrap
Text File
|
1990-09-26
|
3KB
|
65 lines
HOW TO MAKE SQLSERVER 1.0/1.1 work with IBM LAN MANAGER 1.0/1.2
1) there is a bug in the IBM lan server named pipe support. which turns the
data you are sending thru the pipe to garbage. this only happens if you
do any/or all of the following:
a. make the inbound and outbound buffers different sizes
b. make the buffer sizes not an even multiple of 256
c. make the buffer size greater than 2048
the buffer size has nothing to do with the code you write. you DO NOT
have to change the size of your message if you use a message pipe, or the
number of bytes sent at a time if a byte pipe. as it has no affect on how
much data you can throw into the pipe at a time.
this only pertains to how the operating system shoots across chunks
of your data to the other end of the pipe. why they ever allowed us to
mess with the internal buffer size i'll never know. but both IBM lan server
1.0 < fixed in 3072 > and 1.2 < will be fixed in 4080 > have both had the
the problem i wonder if 1.3 will be the same!!!!!!
2] the problem messes up sqlserver cause the guys as Microsoft have set
the internal buffer size's [DosMakeNMPipe] so that they break all
three of the above rules.
if you can 'select * from titles' in the PUBS database then you don't
have a problem. otherwise you need the following patch.
3] the remedy is to get your exehdr or Dentist out and find the import
and correct the code [with patch.exe] just before the callNMpipe.
we basicly set the inbound & outbound size to 1024 bytes.
so for sql server 1.0 the address is a0fcd and for sql server 1.1 it's
9fe10 in the file sqlservr.exe. there should be a 68 06 06 68 02 02 at
the above address change it to 68 00 04 68 00 04 and your good to go.
i make no warrenty on anything i've said here. nor do i imply that any
modifications that you make to your software will either improve it
or tune it in any way.
also note that Microsoft has disavowed all knowledge of this patch.
and if you do call the $2 a min 1-900 hot line they will tell you to
wait till ibm fixs lan server.
any damage this may cause in any way, shape or form is not covered by me
in any way. this is AS IS. but if you have any questions or have a
version of sqlserver that dosent match up to what should be there
send me email or call my bbs 718-494-0197 and leave feedback.
also be sure to try my new netpopup service in MSSYS lib 16. it's called
newpop.zip. it adds a PM face lift where one was really needed.
lastly need a way to move 3000-5000 rows/min from DB2 to sql server
let me know as there is something i'm using called the DB gateway which
works nicely......... and you talk to it thru DB-LIB. imagine SAF connected
to DB2 instead of sqlserver or a program reading from both seamlessly using
the same sql and interface!!!!
sql server is a trademark of Microsoft corp. and DB gateway is a trademark
of Micro decisionware. lan server is a trademark of IBM corp