MS SQL Connectivity ?
ckutay at cse.unsw.edu.au
Mon Oct 16 22:35:26 EDT 2006
not sure htis helps, but the steps i use for mysql are:
1.Put the sql file my.ini in c:\windows directory so that is the system
default for sql access parameters
For instance if mysql is running on port 3306 this needs to be set in
2.In sql configuration, set root to remote access of database. Seemed to
be needed even when using on localhost
3.Set user to root in your Revolution request, again seemed to be
necessary probably for same reason as previous step ie
0/1 depending on ssl usage
Note do not need "localhost" in host parameter
4.If you ahve more than one sql running on your system, check the
process called 'mysql' is the correct one, ie the one you want to be
access, is up and running, etc.
5. set path in Revolution script to the server which is up and running,
in step 4.
revSetDatabaseDriverpath "C:\Program Files\mysql\bin"
6. Also check your internet firewall is not blocking access to sql
server (even localhost)
> Dave Herndon herndogy at sbcglobal.net wrote:
> Anyone know of a way to open a database connection with a MS SQL server database from within revolution ? The same string that works for SQlight which includes the username, password, etc doesn't work for MS SQL Server. I have however obtained success by entering my username and password in the ODBC settings in the Windows administrative tools control pannel. Then the connection string works. But I would rather not have to mess with this on every client computer.
> Any answers ?
Cat Kutay )\._.,--....,'``.
Room 206 CSE _/, _.. \! _\ ;`._ ,.
UNSW, Australia, 2052. `._.-(,_..'--(,_..'`-.;.'
Email: ckutay at cse.unsw.edu.au
Ph: 61 (0)2 9385 5257 Fax: 61 (0)2 9385 5995
Mob: 0418 455 089
"Aboriginal people believe that only when non-Aboriginal people accept
the spirit we offer will they really feel at home in this land. To do
this white Australia must understand the culture of Aboriginal people
and accept it as their own. When white Australians come to understand
Aboriginal people and understand the immense value of Aboriginal culture
they will be fit to teach our young." Pat Fowell, Education (1988).
More information about the Use-livecode