Database Question From Newbie

John Miller johnmiller1950 at sbcglobal.net
Thu Dec 9 06:19:24 EST 2004


Greetings All,

I am trying to access our company's inventory database via Revolution. 
I have successfully set up the DSN under Windows XP. I can use Excel to 
create a Database Query and a spreadsheet with the information I want. 
However, I am having trouble connecting to the same database using 
Revolution.

Here is my code:

on mouseUp
    revSetDatabaseDriverPath "C:\WINDOWS\system32"
    get revOpenDatabase("ODBC","Database 
Name",,"userName","userPassword")
    put the result
end mouseUp

When I run this code, I get the following error message:

    revdberr,invalid database type


Anybody got any suggestions?

Thanks,
John Miller



More information about the use-livecode mailing list