Dave
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
this file
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
revOpenDatabase("MySQL","",
"databaseNameHere","root","rootPasswordHere",0/1?)
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)
Cheers
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 ?
Dave
--
Cat Kutay )\._.,--....,'``.
Room 206 CSE _/, _.. \! _\ ;`._ ,.
UNSW, Australia, 2052. `._.-(,_..'--(,_..'`-.;.'
Email: [EMAIL PROTECTED]
Ph: 61 (0)2 9385 5257 Fax: 61 (0)2 9385 5995
Mob: 0418 455 089
http://www.cse.unsw.edu.au/~ckutay
"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).
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution