I need to get my software to connect to an SQL server on the network.
I can connect to the server just fine using SQL Anwhere.
However, my software won't do it correctly.
I'm assuming I may have an error in my connection string.
I was told that I need to structure the string this way, but I don't know how.
[login to view URL]
Here is the current connection string I'm using.
MICROS&Provider=SAOLEDB.11;UID=custom;PWD=custom;ENG=sqlmicros1;CON=SQL_DBC_190f07d8;LINKS='TCPIP(IP=[login to view URL];PORT=2638)'
Here is the error I'm getting.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
[login to view URL] (0x80040E4D): Connection error: Found server but communication error occurred
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at [login to view URL](DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at [login to view URL](DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at [login to view URL](DbConnection owningConnection)
at [login to view URL](DbConnection outerConnection, DbConnectionFactory connectionFactory)
at [login to view URL]()
at [login to view URL]()
at BarPos.FrmMain.btnUpdateMenu_Click(Object sender, EventArgs e)
at [login to view URL](EventArgs e)
at [login to view URL](EventArgs e)
at [login to view URL](MouseEventArgs mevent)
at [login to view URL](Message& m, MouseButtons button, Int32 clicks)
at [login to view URL](Message& m)