--------------------------
Sent from my BlackBerry Wireless Handheld
-----Original Message-----
From: Brian Humes
To: Witango Talk
Sent: Fri Mar 02 15:52:56 2007
Subject: Witango-Talk: Connecting to SQL Server 2005
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
