The problem with how farcry works (as I understand it) for having a script is that all of the table creation tasks are done "dynamically". That is, from the component definitions of the types that are defined, the fourq element of farcry creates appropriate SQL queries to create the tables. So, there is no single file that holds the tables, columns and default records.
That said, it might be a problem with the MSSQL implementation of the database gateway. I know there were some errors with the Oracle implementation for me, since I was using an older Oracle database. So, if you are inclined to do so, check out the file at \farcry\core\packages\fourq\gateway and look for MSSQLGateway. You might want to check that the SQL statement going into MSSQL is properly formatted for MSSQL (with which I don't have any experience). One thought that occured to my right now is that "stats" is a reserved keyword in MSSQL or something like that. This would mean that it exists and hence can't drop it because it is a super-user kind of table. No idea about this though. Good luck, Tomek On Thu, Oct 9, 2008 at 10:40 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]>wrote: > > I am new to farcry and downloaded farcry-community-5-0-0.zip last > night. > > This was a clean install. I have never used farcry before. The > result was that the installation put the code in correctly, but my > database still has no tables. > > I think i would be fine if provided the generated MSSQL scripts to > create the tables, columns, default records. Otherwise if there is a > new version that address this, i could try installing that. > > > On Oct 9, 10:28 am, Jeff Coughlin <[EMAIL PROTECTED]> wrote: > > Andrew, > > > > > Message [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot drop the > > > table 'stats', because it does not exist or you do not have > > > permission. > > > > > I am using MSSQL and had created the database / datasource and got the > > > above error. My datasource is using the SA account, so it should have > > > the permissions it needs. > > > > What version of FarCry were you using for the installer > > example: 4.0.11, 5.0.0, 5.0.1, 5.0.2, p500 (SVN), trunk (which is 5.1 > > in development), etc > > > > Also, was this a clean install or an upgrade? > > > > Regards, > > > > -- > > Jeff Coughlin > > Web Application Developerhttp://jeffcoughlin.com > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
