INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

ODBC conections. !!!!!

ODBC conections. !!!!!

(OP)
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]

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close