Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC conections. !!!!!

Status
Not open for further replies.

eduhalma

Programmer
Joined
Jul 22, 2004
Messages
2
Location
AR
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]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top