Connect to Sybase db VB2010 ADO
I am working in Visual Basic 2010 and connecting to a Sybase 12 database on a remote server using ADO.
I want to connect through code as the particular database will change.
I have not been able to find a connection string that works.
I can connect via ODBC using the ip address of the server and the database name, so I know the connection is possible if I can get the correct syntax for the connection string.
The last string I tried was
Dim strConnection As String = "Provider=ASAProv.12;ENG=192.00.00.00.rancustomreports;Uid=uid;Pwd=pwd;Links=tcpip(Host=192.00.00.00);"
2 answers
Link to instructions that worked for me
You can use this Sybase ODBC driver and this connection strings instruction for correct tunning.
Post an answer but please log in first
Similar Questions
c # connect syabse sql anywhere database .db file?
Now there is a database file of sybase SQL anywhere in the format of .db file. I now have Sql anywhere 5.0 installed on this machine. I can connect through ODBC, but now I want to install it in a database-less environment, that is, without installation.
DSUSRL option do not find my Sybase ASE server
Hi, I'm trying to connect to Sybase ASE 15 using ADO.net in a Powershell script At the beginning of the shell I got the load of the DLL : Add-Type -AssemblyName "Sybase.AdoNet2.AseClient, Version=2.157.1330.0, Culture=neutral, PublicKeyToken=XXXXXX"
Cannot connect to sybase server using ssl connection string
Hello, I am trying to connect to Sybase server using ssl enabled connection string. But I always get exception "[AseException: Could not load sybdrvssl library]
Access to Sybase Anywhere 8.0 with Excel VBA
Hi! I Need make a connection to Adaptive Server Anywhere 8.0 database using Excel 2013+VBA commands, Someone who can help me
Connect to Sybase ASE Database with Visual Basic 2015
Hello all, my gears are grinding for some weeks now. My company uses Sybase ASE, but I can't figure out how to connect to the database with Visual Studio 2015 (Visual Basic). Where I need help with:
Invalid user name and/or password in odbc_connect command in php script
I use Eaglesoft practice management software for my practice. For the older version (16.0), I had a simple php script written to connect to its database using oddcconnect. The database is sybase (Sap) sql anywhere and the connection string used was odbcconnect("dental", "dba","sql").
How to connect ASA8.0 database file directly in Powerbuilder 11
How to connect ASA8.0 database file directly in Powerbuilder 11? (Background: I connect to ASA11.0 with ODBC in Powerbuilder, at the same time, I need to connect to ASA8.0 database to retrieve data,
Sybase ASE OLE DB provider for 12.5
Hi, I am working on migration from Sybase to SQL server 2005 project. I need to connect Sybase through OLE DB provider. I want to download Sybase ASE OLE DB provider for 12.5 Is there any locat
- Load more posts