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 Chris 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
Jul 22, 2004
2
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