Thanks Robert. That fixed it.
From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Wednesday, September 21, 2011 2:52 PM To: Witango-Talk@witango.com Subject: RE: Witango-Talk: MySQL ODBC And TeraScribe 6.1 Steve, I believe the issue is that you have setup your DSNs using the 64-bit ODBC manager (and therefore drivers) Since TeraScript 6 is a 32-bit application, you must manually open and use the ODBC administrator found here: C:\Windows\SysWOW64\odbcad32.exe Everything else is the same. Robert From: Fogelson, Steve [mailto:stevefogel...@askics.net] Sent: Wednesday, September 21, 2011 3:44 PM To: Witango-Talk@witango.com Subject: Witango-Talk: MySQL ODBC And TeraScribe 6.1 I have Windows 2008 R2 Web Edition, MySQL ODBC 5.1 (5.01.08.00) (I loaded the 64 bit MSI and it said it loaded both the 32 bit and 64 versions, but I only see one in the ODBC manager), TeraScribe 6.1, IIS 7.5 MySQL 5.0 is setup on a separate Windows 2008 server. I am working through setting up a new server. Html and simple tafs (without DB requests) work fine. I have setup up the ODBC connection on the TeraScribe Server in the System tab. I have a simple taf that tries to read a table in a MySQL database. (Other servers are connecting fine using Witango 5.5.) I get the following: [Direct DBMS Action] [3] ReadCatSites : MyCatSites [Datasource] [3] No existing connection to the data source found, creating a new connection. DSN: odbc.MyCatSites; User: xxxxxxxxxxxx; [Error] [3] -110 The specified data source cannot be found. [Datasource] [3] Unable to open a connection to odbc.MyCatSites due to an unknown error during connection [Datasource] [3] Total Connection in Datasource Pool: 0; Max connections for the host: 0; Current connections in use for the host: 0 [Error] [3] -4 Unable to connect to the specified data source. Verify that data source is properly configured and that database server is online. The ODBC Manager indicates “Connection Successful” when tested, but TeraScribe indicates that the connection was unsuccessful. Any suggestions? FYI: The taf was created with Witango Studio 5.5 Steve Fogelson Internet Commerce Solutions ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.
