On 12/11/01 7:34 pm, Ben Rubinstein <[EMAIL PROTECTED]> wrote:
> 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?
Try to connect using the syntax:
get revdb_connect("ODBC",<DSN>,"",[user],[password])
Where user and password are optional. For DSN just specify the DSN name
instead of host. If that doesn't work you could try "DSN=DSNNAME" as the
host, though that probably isn't necessary.
> - 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.
Set all of this information in the Merant Control Panel. You might also
want to check if it connects with MacSQL - if so, it should work with
Revolution.
> Any help, on the Revolution or other sides, gratefully received.
One other point worthy of note is that there is a bug in our Database
Manager stack: the connection dialog forces you to place an entry in all the
fields, this may not always be necessary. You can edit the scripts to turn
of this validation easily for the moment though.
Regards,
Kevin
Kevin Miller <[EMAIL PROTECTED]> <http://www.runrev.com/>
Runtime Revolution Limited - Power to the Developer!
Tel: +44 (0) 870 747 1165. Fax: +44 (0)1639 830 707.
