ok, i think i see whats happening... my datasource in cf admin is connecting with the SA account which is creating these tables directly in the master table. I will play around a little and create a new dbUser account that should only have access to my farcry table (not master) and will post the results.
On Oct 9, 11:25 am, Jeff Coughlin <[EMAIL PROTECTED]> wrote: > Andrew, > > > 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. > > Stick with the 5.0.0 community installer for now. You can upgrade the > core later. > > Are you saying that no tables were created at all? or just the stats > table wasn't created? > > If you're saying that absolutely no tables were created at all, then > something is likely wrong with your datasource or DB connection. I am > only suggesting this because (to my knowledge) no one has had this > issue before with the 5.0.0 community release (released in June 2008) > and MSSQL. > > Here are some examples of this to check: > * What driver are you using to connect to the SQL database? (you want > to be using the JDBC driver and not the ODBC driver) > * When you're in the CF Administrator, have you verified that the > connection between your DSN (with the JDBC driver) can successfully > connect to the empty database? > * Check the DSN settings in the CF Administrator (maybe someone turned > off access for creating tables or something) > * Verify that the SQL user has access to write tables (owner, or less). > * Verify that you are using the minimum requirements for FarCry 5: CF > 7.0.2+ and SQL 2000+ (although I suggest 2005 or better - I personally > haven't tested it in SQL 2008 yet - Is that what you're using?) > * If all of the above passes, try eliminating FarCry as the culprit -- > create a temp cfm file with a simple <cfquery/> to create an empty > table. See if it lets you create the empty table with a field or > two. If not, review the CF error and go from there. > > -- > 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 -~----------~----~----~----~------~----~------~--~---
