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?

asked 05 Mar '15, 13:58

Steve%20Someone's gravatar image

Steve Someone
15112
accept rate: 0%


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

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

permanent link

answered 05 Mar '15, 14:07

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

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.

(05 Mar '15, 15:07) Steve Someone
Replies hidden
1

> it doesn't work when I hit Test Connection

What exactly is the error message?

(05 Mar '15, 15:41) Breck Carter

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:

(05 Mar '15, 15:49) Steve Someone
Replies hidden

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.

(06 Mar '15, 03:02) Martin
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×126

question asked: 05 Mar '15, 13:58

question was seen: 19,504 times

last updated: 06 Mar '15, 03:02