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.

Reply via email to