Hi all,
We are in the process of upgrading our web and data servers. On the
web server side, we're moving from Win 2000 to Win 2003. On the data
side, we're moving from SQL Server 2000 to SQL Server 2005. We've
installed Witango on the web server and everything is working fine,
right up until I want to connect to a database.
I develop on a Mac and use Openlink SQL Server Lite for ODBC
connectivity. I have set up User DSN's on my Mac, and System DSN's on
the web server with identical names. On the old set up, this has
always worked just fine.
However, now when I try to connect to a datasource through a Witango
app (assuming my DSN is called 'asgelectronics'), I get the following
error:
Error
An error occurred while processing your request:
File: test.taf
Position: Search
Class: Internal
Main Error Number: -110
The specified data source cannot be found.
OpenLink SQL Server Lite Driver
File: test.taf
Position: Search
Class: Internal
Main Error Number: -4
Unable to connect to the specified data source.
Verify that data source is properly configured and that database
server is online.
[Application File]
[2]
START /test.taf Witango_Server_5.5
[Results Action]
[2]
Results
[Search Action]
[2]
Search : asgelectronics
[Datasource]
[2]
No existing connection to the data source found, creating a new
connection. DSN: odbc.asgelectronics; User: bhumes;
[Error]
[2]
-110 The specified data source cannot be found. OpenLink SQL Server
Lite Driver
[Datasource]
[3]
Unable to open a connection to odbc.asgelectronics 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.
[request$ Vars]
[3]
variableTimeout=30;
Here is the DataSources information contained in my test.taf app:
<DataSources>
<DataSource ID="asgelectronics">
<DSType>ODBC</DSType>
<DSN>asgelectronics</DSN>
<DBMS />
<Host>asgelectronics</Host>
<Database>OpenLink SQL Server Lite Driver</Database>
<UserInfo Encrypted="True">
<UserName>scrambled</UserName>
<Password>yaddayaddayadda</Password>
</UserInfo>
</DataSource>
</DataSources>
If I run the test.taf file on our Win 2000 web server (connecting to
our SQL Server 2000 box), this works just fine.
I have tried setting up the DSN using both SQL Native Client and SQL
Server, same results. One thing to note is that I have NOT upgraded
my OpenLink driver yet (to support 2005), but I am able to run
queries through Witango studio to the SQL Server 2005 server with no
problems. Any insight? I feel like this is something very simple that
I'm overlooking.
Thanks so much for your time. I really appreciate it.
Brian Humes
Director, Interactive
JohnsonRauhoff Communications Group
269.428.9257 (Direct)
269.428.3377 (Main)
269.428.3312 (Fax)
www.johnson-rauhoff.com
[EMAIL PROTECTED]
_____________________________
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
