|
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? |
|
You can find the SQL Anywhere client downloads on the SCN SQL Anywhere community site: 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, TaskCompletionSource
(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
|
