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
