ERROR 0x82504

[Mark Schonewille]

Hi William,

Thanks for testing. For file names, I use .vdb as the file extension and 
for database names I use the same file names without file extension. In 
SQL syntax, I use the database name without file extension and that 
seems to work fine. In LiveCode, I use database names with file 
extension and that seems to work fine too. Yes, it seems the file 
extension isn't important, but using a file extension in SQL syntax may 
confuse the SQL interpreter.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other 
colour spaces. http://www.color-converter.com

Buy my new book "Programming LiveCode for the Real Beginner" 
http://qery.us/3fi

Fill out this survey please
http://livecodebeginner.economy-x-talk.com/survey/

On 10/3/2013 19:05, william humphrey wrote:
> I just tested opening an existing database with the above example. You
> can use
> "databaseName"  or "databaseName.dbf" -- both work fine, it doesn't care
> if you have the extension there or not.
>
>
> On Thu, Oct 3, 2013 at 12:26 PM, william humphrey
> <bill at bluewatermaritime.com <mailto:bill at bluewatermaritime.com>> wrote:
>
>     If I close the vServer database on this machine and run the same
>     code I get no error at all (which makes sense). I'm still trying to
>     figure out how to get error 82504
>
>
>     On Thu, Oct 3, 2013 at 12:19 PM, william humphrey
>     <bill at bluewatermaritime.com <mailto:bill at bluewatermaritime.com>> wrote:
>
>         If I use the exact code you show for opening a database on
>         localhost using vServer and I change the name of the database to
>         one that is non-existent (just did it now). I get error 82517
>         which is
>
>         ERR_CONNECTION_DATABASE_NOT_OPENED
>
>
>         I do not get error "invalid database name"
>
>