[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 374
  • Last Modified:

Connecting to Sybase using Sybase ASE Provider

I need a connection global module in VB 6 so that I can use it for connection to sybase from any function or program using ASE provider.

so in my function I want to just use the modules method and connect .
0
Joserip
Asked:
Joserip
  • 2
1 Solution
 
DhaestCommented:
ODBC Driver for Sybase
If using the Sybase System 12 (or 12.5) Enterprise Open Client ODBC Driver

oConn.Open "Driver={SYBASE ASE ODBC Driver};" & _
           "Srvr=myServerName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"
 
If using the Sybase System 11 ODBC Driver

oConn.Open "Driver={SYBASE SYSTEM 11};" & _
           "Srvr=myServerName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"
 
If using the Intersolv 3.10 Sybase ODBC Driver

oConn.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};" & _
           "Srvr=myServerName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"
For more information, see: Sybase System 10 ODBC Driver Reference Guide
http://manuals.sybase.com/onlinebooks/group-cn/cng1000e/odbc_ref/@ebt-link;pt=622?target=%25N%14_1044_START_RESTART_N%25

To view Microsoft KB articles related to ODBC Driver for Sybase,
http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=Sybase&Queryc=Sybase&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=100
0
 
DhaestCommented:
Recommendations: answered by dhaest
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now