Hi Peter,
I don't know why my other two posts didn't go through, I'll give it a little while and see if they populate, but although the driver is SQL Anywhere 12 I have some other info. Basically, Peter, I thanked you for pointing out that the ODBC was a connector and not a database type, and then included some more information to try and understand where I start with this.
I guess I am trying to create a connection between what appears to be a SQL Anywhere 12 Driven database that connects via an ODBC connection and a newly created MYSQL database we made on another computer on the network. The info I have to go off of at the moment is the connection string someone had created for excel and the database info I have been able to retrieve:
More Connection Information
Work Database
workdb.workserver.local
10.215.111.222
Port:2345
Server Name: workdb
user:USER
password:PASSWORD
encryption method: simple
***
<xml id=docprops><o:DocumentProperties
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns="
http://www.w3.org/TR/REC-html40">
<o:Name>Query from workdb1</o:Name>
</o:DocumentProperties>
</xml><xml id=msodc><odc:OfficeDataConnection
xmlns:odc="urn:schemas-microsoft-com:office:odc"
xmlns="
http://www.w3.org/TR/REC-html40">
<odc:Connection odc:Type="ODBC">
<odc:ConnectionString>DSN=workdb</odc:ConnectionString>
<odc:CommandText>SELECT v_Discounts.FOX_DIS_FK, v_Discounts.DIS_Description FROM wdb.v_Discounts v_Discounts</odc:CommandText>
</odc:Connection>
</odc:OfficeDataConnection>
</xml>
<style>