How To Download Sybase SQL Anywhere ODBC Driver?

[Former Member]

We are using a point-of-sale system (Micros) that employs Sybase database. I'm trying to connect using ODBC because that's how our existing projects were created. I can't set up a working DSN because I don't have the Sybase ODBC driver on my machine. The lead developer is on vacation so I can't ask him how to do this. Is there some way I can download the driver I need from the Internet?

[jeff_albion]

You can find the SQL Anywhere client downloads on the SCN SQL Anywhere community site:

http://scn.sap.com/docs/DOC-35857

[Former Member]

Jeff Thanks for the reply. I installed the client and I created an ODBC DSN, but it doesn't work when I hit Test Connection. I based the DSN on a connection string that was built in our program. It looks like this:

Dsn=Micros;uid=username;pwd=password;databasename=micros;enginename=sqlMI65008;autostop=No; integrated=No;debug=NO;disablemultirowfetch=NO;commlinks=TCPIP{ip=000.000.000.000}; compress=No;description=MICROS RES Database;keysinsqlstatistics=YES;delphi=Yes

I replaced the IP address with zeros. Does this look like a Sybase connection to you? When I set up the DSN I'm not sure if I pick "Connect to a running database on another computer" and, if so, I'm not sure what values I use for Host, Port, and Server name. I checked "Microsoft applications" and "Delphi applications". When I connect it says Server not found or Architecture doesn't match between Driver and Application.

Thanks

[the forum says I should click the reply icon, but I don't see the reply icon.]

Edit: I installed the 16.0 version. Do you think I should try the 12.0.1 version? I think I saw somewhere in our documentation that it mentioned Sybase 5.0, but I'm not sure.

[Breck_Carter]

> it doesn't work when I hit Test Connection

What exactly is the error message?

[Former Member]

Breck

It says what I said it says.

"When I connect it says Server not found or Architecture doesn't match between Driver and Application."

I've actually tried to connect two ways; from ODBC Data Source Administrator in Windows, and from a project that uses the DSN.

In ODBC Data Source Administrator when I click Test Connection it says:

"Connection failed: Database Server not found"

In Visual Studio when I try to run the project it says all of the below, but the critical portion is "The specified DSN contains an architecture mismatch between the Driver and Application":

System.Data.Odbc.OdbcException was unhandled by user code ErrorCode=-2146232009 HResult=-2146232009 Message=ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application Source="" StackTrace: at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.Odbc.OdbcConnection.Open() at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at System.Web.UI.WebControls.BaseDataBoundControl.DataBind() at System.Web.UI.WebControls.GridView.DataBind() at MenuLevels._Default.ddStore_SelectedIndexChanged(Object sender, EventArgs e) in C:\\Users\\sgaines\\Desktop\\LastCall Source Code 3-2-2015\\ADSpotlight\\4.0\\IT\\MenuLevels\\MenuLevels\\Default.aspx.vb:line 16 at System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged(EventArgs e) at System.Web.UI.WebControls.DropDownList.RaisePostDataChangedEvent() at System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent() at System.Web.UI.Page.RaiseChangedEvents() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) InnerException:

[MCMartin]

This is the case if the your app is 64bit and the driver 32bit or vice versa. Check the project settings in Visual studio to generate the matching bitness of the app.