It sounds like his problem is on windows, not on the mac.
The fact that the error lists the openlink driver, has nothing to do
with the problem. When you have an odbc error, witango just spits out
that field from the DSN info in the TAF xml.
It just sounds like, for whatever reason, your witango server process
does not see a DSN with that name (asgelectronics).
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Mar 3, 2007, at 4: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
