Member Avatar for weshahy123

I am work with sybase Adaptive Server Enterprise (ASE) 12.5
I wanna connect sybase from visual basic 6
I found this connection string:
Provider=Sybase.ASEOLEDBProvider.2;Server Name=myASEserver;Server Port Address=5000;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

but i don not have the provider Sybase.ASEOLEDBProvider.2
I want this sostware driver and know how to connect sybase
please help me and descibe the solution with photo as possible as you can
thanks alot

mail:

  • 5 Contributors
  • 5 Replies
  • 187 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by aktharshaik

Dani AI

Generated

Summary and correct direction for : Adaptive Server Enterprise (ASE) 12.5 does not install its OLE DB provider from the SQL Anywhere (ASA) installer. The ASE client libraries ("Open Client" / ASE Client Utilities for 12.5) provide the ASEOLEDB provider and the native ASE ODBC driver. The suggestion from points at SQL Anywhere (Adaptive Server Anywhere), which is a different product and will not register the ASE OLE DB provider.

Practical steps and verification:

  • Obtain the ASE 12.5 client package (server media or vendor/SAP distribution). Install the client components and choose the OLE DB and ODBC pieces. That registers the Sybase ASE OLE DB provider (ProgID varies by version).
  • Quick verification without code: create a text file, rename it to test.udl, double-click it and look on the Provider tab for a "Sybase" / "ASE OLE DB" entry. If not present, the provider is not installed.
  • If installing the Sybase client is not possible, use the Sybase ODBC driver (or a compatible driver such as FreeTDS ODBC) and configure a DSN. On 64-bit Windows, the VB6 process requires 32-bit drivers and the 32-bit ODBC administrator (%windir%\SysWOW64\odbcad32.exe).

Connectivity and troubleshooting checklist:

  • Confirm the ASE server is reachable on the correct port (5000 is common but confirm with the DBA). Test TCP connectivity (telnet host port or equivalent).
  • Check the server "interfaces" file or the server admin for the logical server name-to-host/port mapping.
  • Verify credentials and that the ASE account has connect privileges.
  • Watch for 32-bit vs 64-bit mismatches; VB6 is 32-bit and must use 32-bit drivers or run in a 32-bit environment (VM or compatibility layer).

Example VB6 pattern using an ODBC DSN (replace placeholders as appropriate):

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
cn.Open "DSN=MySybaseDSN;UID=myUsername;PWD=myPassword;"

Notes: was right to look for the provider; 's hint to search is practical; 's SQL Anywhere advice only applies to ASA, not ASE. If drivers still fail on a modern OS, legacy 32-bit VMs or contacting the DBA/vendor for the ASE 12.5 client installer are the usual remedies.

Recommended Answers

All 5 Replies

Member Avatar for debasisdas

what did google say ?

have you tried for that option ?

Member Avatar for pnorten462

you have to find provider of this program, after this you will be able to access this program.

Member Avatar for aktharshaik

Go to www.sybase.com
Download 'SQL Anywhere Studio'
You'll need to register yourself, but that's easy.
Then you only install the 'Network database client' (in AdaptiveServer Anywhere for Windows)

may help to load the driver.

Regards
Shaik Akthar

Member Avatar for dharam_05

I am working on microsoft MS SQL 2005, want to connect with vb script. Want a connect string for this.

Member Avatar for aktharshaik

Try this link

Regards
Shaik Akthar

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.