I'm trying to test the revdb functions on MacOS. I've downloaded and
installed demo of the Merant ODBC drivers and driver manager; and Runtime
Lab's MacSQL.
I've got two kinds of problem at the moment: Revolution doesn't seem to be
talking correctly to Merant; and Merant doesn't quite get it either.
Non-revolution part:
I'm trying to connect to a SQL Server database on another machine on our
LAN.
- If I use MacSQL to make a SQL Server connection, it works.
- I've made a User DSN in the Merant ODBC Data Source Administrator control,
using the same data. I can then use MacSQL to make an ODBC connection using
the DSN. So far so good.
- Using the ODBC Connection Test app which comes with the Merant software, I
cannot connect. Typically, there is no actual error message (or rather, the
error sting is just set to "[MERANT][Macintosh ODBC Driver Manager]"); the
"NATIVE_ERROR" is reported as 0; the "SQLSTATE" is reported as "IM012". I
have a few examples in which the SQL_STATE was IM008, and the message
"[MERANT][Macintosh ODBC Driver Manager]Dialog failed".
Specifically Revolution part:
There is no obvious way to use a DSN. The revdb_connect function, and the
Database Manager example, require type, host, database, user and password.
However, whatever I enter in these fields (with type set to ODBC, the only
option for working with SQL Server) the error I get is always:
[MERANT][Macintosh ODBC Driver Manager]
Data source name not found and no default driver specified
So the message suggest that it's trying to locate a DSN, but I'm unclear how
or where. I've tried substituting the DSN name for the database, but
without success.
questions:
- is there supposed to be a way to use a DSN? If so, how?
- if we ignore DSNs, how do you specify port? I've tried every "<ip
address>:<port number>" and "<ip address>,<port number>" (which is what the
Merant tool seems to need for DSNs); and also tried using the name, rather
than the ip address, of the host computer (with both variants for setting
port). I've no reason to think this is the root of my problem, but it would
be nice to know so that I can have fewer variables to test.
Any help, on the Revolution or other sides, gratefully received.
TIA,
Ben Rubinstein | Email: [EMAIL PROTECTED]
Cognitive Applications Ltd | Phone: +44 (0)1273-821600
http://www.cogapp.com | Fax : +44 (0)1273-728866
