CFRONT With SQL Server

waynewil

I'm trying to use CFRONT with Delphi against SQL-Server version of Navision.

My problem is that the ConnectServerandOpenDatabase function requires a net type parameter of one of the four following values:

Default
Use the default Net Type.

Named Pipes
Use Named Pipes.

TCP/IP Sockets
Use TCP/IP Sockets.

Multiprotocol
Use Multiprotocol.

Unfortunately, a call to this function rejects the use of the last three options because they exceed 10 characters. A call to "Default" prompts the system to look for a nc_Default.dll, which does not exist.

Any ideas?

Waynewil

db

Why you using CFront ? use OLE DB it's faster.

fko

There is a special cFrontSQL.dll in the CFRONT directory on my computer. There are the same functions inside, but this is designed for SQL Server connection and works perfect on my workstation.

waynewil

Thanks, but I've long since moved on to a combination of using MSMQ and/or talking to SQL Server directly.

Waynewil