When connect Centura Builder 3 using ODBC driver for VFP. I've got connect but this is very slow and run atomatic sqlbase I don't no why. The sql.ini is
REMOTE database using TCP/IP (WinSock)
;
[winclient]
clientname=WinUser
[winclient.dll]
comdll=sqlspxw4
[winclient.nbiow]
[winclient.spxw4]
[winclient.wsock]
[win32client.comments]
;
; Win32 (Windows 95 or NT)
;--------------------------
; Use this section to specify Win32 client workstation parameters that
; are independent of the communications protocol(s) being used.
;
; This section is for the Win32 client workstations. Here you will specify
; the COMmunication DLL(s) that the Win32 application(s) intend to use.
; Use the following protocol(s) to connect to the specified SQLBase product:
;
; comdll SQLBase target
; ------ --------------
; sqlapipe LOCAL database using Anonymous Pipes
; sqlntnbi REMOTE database using NetBios
; sqlws32 REMOTE database using TCP/IP (WinSock)
; sqlspx32 REMOTE database using IPX/SPX (Win32 Novell Client)
; sqlwsspx REMOTE database using IPX/SPX (Win32 Microsoft Client)
;
[win32client]
clientname=Eze
[win32client.dll]
comdll=sqlspx32
comdll=sqlora32
comdll=sqlntnbi
comdll=sqlapipe
comdll=sqlodb32
[win32client.apipe]
[win32client.ntnbi]
[win32client.ws32]
[win32client.spx32]
[win32client.wsspx]
[nwclient.comments]
; Netware clients
;-------------------
; Add this to the sql.ini for netware clients for SQLAPI for Netware and 2pc.
; Use this section to specify Netware client workstation parameters that
; are independent of the communications protocol(s) being used.
;
[nwclient]
clientname=Sandra
[nwclient.dll]
comdll=sqlspx
[nwclient.spx]
[patch.comments]
;
; This section is only used if running the NLM Database Server on a
; NETFRAME machine.
;
[patch]
[oragtwy]
remotedbname=base,@base
longbuffer=32767
substitute=",
substitute=SYSSQL.,
fetchrow=20
[odbcrtr]
remotedbname=tsv,DSN=tsv
odbctrace=off
odbctracefile=sql.log
remotedbname=notped,DSN=notped
odbctrace=off
odbctracefile=sql.log
; Win32 (Windows 95 and NT)
;-------------------------------
; This section is for the SQLBase Win32 database server. You can
; specify which communication protocol(s) the server can use as well as which
; protocol(s) a database can use.
;
[dbntsrv]
;dbname=ISLAND,SQLAPIPE
;dbname=PELLACAN,SQLAPIPE
;servername=server1,sqlapipe
;cache=2000
;sortcache=2000
;readonly=0
;oracleouterjoin=0
;logfileprealloc=0
;partitions=0
;optimizerlevel=2
;locktimeout=275
[dbntsrv.gui]
[dbntsrv.dll]
comdll=sqlapipe
[dbntsrv.apipe]
[dbntsrv.ntnbi]
[dbntsrv.ws32]
[dbnt50sv.comments]
;
; This section is for the 1-User SQLBase Win32 database server.
;
[dbnt1sv]
;servername=server1,sqlapipe
;cache=1000
;sortcache=1000
;readonly=0
;oracleouterjoin=0
;logfileprealloc=0
;partitions=0
;optimizerlevel=2
;locktimeout=275
dbdir=C:\CENTURA
;dbname=island
[dbnt1sv.dll]
comdll=sqlapipe
[dbnt1sv.apipe]
[dbnt1sv.ntnbi]
[dbnt1sv.ws32]
[dbnservr.comments]
REMOTE database using TCP/IP (WinSock)
;
[winclient]
clientname=WinUser
[winclient.dll]
comdll=sqlspxw4
[winclient.nbiow]
[winclient.spxw4]
[winclient.wsock]
[win32client.comments]
;
; Win32 (Windows 95 or NT)
;--------------------------
; Use this section to specify Win32 client workstation parameters that
; are independent of the communications protocol(s) being used.
;
; This section is for the Win32 client workstations. Here you will specify
; the COMmunication DLL(s) that the Win32 application(s) intend to use.
; Use the following protocol(s) to connect to the specified SQLBase product:
;
; comdll SQLBase target
; ------ --------------
; sqlapipe LOCAL database using Anonymous Pipes
; sqlntnbi REMOTE database using NetBios
; sqlws32 REMOTE database using TCP/IP (WinSock)
; sqlspx32 REMOTE database using IPX/SPX (Win32 Novell Client)
; sqlwsspx REMOTE database using IPX/SPX (Win32 Microsoft Client)
;
[win32client]
clientname=Eze
[win32client.dll]
comdll=sqlspx32
comdll=sqlora32
comdll=sqlntnbi
comdll=sqlapipe
comdll=sqlodb32
[win32client.apipe]
[win32client.ntnbi]
[win32client.ws32]
[win32client.spx32]
[win32client.wsspx]
[nwclient.comments]
; Netware clients
;-------------------
; Add this to the sql.ini for netware clients for SQLAPI for Netware and 2pc.
; Use this section to specify Netware client workstation parameters that
; are independent of the communications protocol(s) being used.
;
[nwclient]
clientname=Sandra
[nwclient.dll]
comdll=sqlspx
[nwclient.spx]
[patch.comments]
;
; This section is only used if running the NLM Database Server on a
; NETFRAME machine.
;
[patch]
[oragtwy]
remotedbname=base,@base
longbuffer=32767
substitute=",
substitute=SYSSQL.,
fetchrow=20
[odbcrtr]
remotedbname=tsv,DSN=tsv
odbctrace=off
odbctracefile=sql.log
remotedbname=notped,DSN=notped
odbctrace=off
odbctracefile=sql.log
; Win32 (Windows 95 and NT)
;-------------------------------
; This section is for the SQLBase Win32 database server. You can
; specify which communication protocol(s) the server can use as well as which
; protocol(s) a database can use.
;
[dbntsrv]
;dbname=ISLAND,SQLAPIPE
;dbname=PELLACAN,SQLAPIPE
;servername=server1,sqlapipe
;cache=2000
;sortcache=2000
;readonly=0
;oracleouterjoin=0
;logfileprealloc=0
;partitions=0
;optimizerlevel=2
;locktimeout=275
[dbntsrv.gui]
[dbntsrv.dll]
comdll=sqlapipe
[dbntsrv.apipe]
[dbntsrv.ntnbi]
[dbntsrv.ws32]
[dbnt50sv.comments]
;
; This section is for the 1-User SQLBase Win32 database server.
;
[dbnt1sv]
;servername=server1,sqlapipe
;cache=1000
;sortcache=1000
;readonly=0
;oracleouterjoin=0
;logfileprealloc=0
;partitions=0
;optimizerlevel=2
;locktimeout=275
dbdir=C:\CENTURA
;dbname=island
[dbnt1sv.dll]
comdll=sqlapipe
[dbnt1sv.apipe]
[dbnt1sv.ntnbi]
[dbnt1sv.ws32]
[dbnservr.comments]