Hi all,
I solved the problem. I was using the 64-bit ODBC Admin panel vs. the
32-bit panel. I entered the DSNs in the 32-bit panel and everything
is working perfectly now.
Thanks for everyone's help!
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]
_____________________________
On Mar 6, 2007, at 8:34 AM, Brian Humes wrote:
Hi Dan,
Thanks for the suggestion. I tried the Actual drivers…same results.
Like Robert suggested, I think this is a problem on the Windows
end, but I can't figure out what I'm doing wrong.
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]
_____________________________
On Mar 3, 2007, at 7:03 AM, Dan Stein wrote:
Try these drivers the work well at least for connecting with other
apps. They have a beta driver that configures easily just like
windows. It might solver your problems
http://www.actualtechnologies.com/
If the non betas do not work contact me back channel I will get
you the ones that I have that do.
--
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com
"It is perfectly safe to stand nowhere."
From: Brian Humes <[EMAIL PROTECTED]>
Reply-To: "[email protected]" <[email protected]>
Date: Fri, 2 Mar 2007 15:52:56 -0500
To: Witango Talk <[email protected]>
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
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
