Connected using FPSQL.PLB 1

[sipos]

Hi, i was just trying to use FPD26 Connectivity Kit (FPSQL.PLB for sure). I was trying connecting to SQL Server 2000. But the FPSQL told that there was an error happened when it tried to connect to the server ... This is the error message:

DB-Library error 10040: DB-Library network communications layer not loaded.

Does anyone here know something about this error ... i mean, do i miss a file on installing connectivity kit (a driver or something)? Or does it happen because there is a different DB-Library protocol on FPSQL.PLB and SQL2000? Or do i miss a file when installing SQL Server Client utility?
Or ...

 

[ezopaci]

What operating system do you use ?
If you use Win., I think there is no interface by interrupt XX between PLB and network layer.
In DOS, i think, were INT 70h for access to the IP stack, but it does not exist in dos emulation layer.

Tomas

 

[sipos]

I don't think that's the problem ... because the Fox 26 LCK package only give the .PLB. There is no other program.

But supposed, if what you say is correct, then LCK should say something about a resident program to be called before calling .PLB. But i don't find it in the documentation. Or do i miss the words ?

Edo

 

[sipos]

Finally, i found a word on the sample in SQL Samples for DB-Library.

Actually, before we can use DB-Library for MS-DOS, we need to resident a program. The program is DBNMPIPE.EXE.

and then, i search the file, and i cannot found it anywhere (in SQL installation package, in my hardisk). So I use google (God bless google), i found the file on installer for a DOS program using Sybase SQL.

And ... Yes, DBNMPIPE ver 1.0.3 (c) 1994 by Microsoft and Sybase can be resident, and network layer is build ... but sadly, it still cannot connect to server, because

10010: Possible Network Error: Read from SQL Server Error

now, i'm stuck for now ...

 

[ezopaci]

What OS do you use ?
DBNMPIPE is "DB Named Pipe" - layer for communication
over "named pipe" technology. For named pipe is some support in ntvdm (dos in win xp).

Tomas

 

[sipos]

sorry ...
i'm using DOS in WinXP.

 

[datace]

Can you resolved this:
DB-Library error 10040: DB-Library network communications layer not loaded.

can you tell me how?

 

[sipos]

you should called a resident program named DBNMPIPE.EXE that has been given to you by every SQL installer below v2000 ... BEFORE you use your DB-Libray interface program.

DBNMPIPE.EXE hasnot changed since SQL v.7, so SQL 2000 didnot give this program in their installer.


NOTES ...

Even when you already resident the DBNMPIPE, YOU MUST recompile your DB-Library Interface using C library that comes with current SQL Server version (your installed SQL Server).
if you don't do it, then your DB-library interface program would not connect to your current SQL Server.

for example ...
FPSQL.PLB is compiled using DB-Library that comes with SQL 6.5. This interface program won't connect to SQL 2000. It will show an error like "Expected EOF".

Till now, i still cannot connect to SQL2K using Foxpro (FPSQL.PLB),
I don't know for next year, if I have time, maybe I will create FPSQL myself, using Foxpro API and DB-Library C Library for SQL2K.