I believe that the db needs to have the period (e.g. "dbo.") because it gets used in querys as #application.dbowner##tablename# => dbo.dmHTML. Some DBs don't have use owners that way, so the value is blank. MS SQL usually works with "dbo." or without.
Blair On Sat, Mar 20, 2010 at 8:07 AM, Marco van den Oever < [email protected]> wrote: > OK, i am further checking with Activant to understand the problem he > is experiencing. > To further blank out some reasons why this is not working yet a > question: > > When selecting the "microsoft sql server" type and filling out the > database owner we see a period "." gets added to the database owner, > is this normal and is this maybe creating this problem??? > > Thanks! > > On Mar 12, 10:09 pm, Activant <[email protected]> wrote: > > I am open to using it. Just wanted to confirm. You spoke of using > > remote assistance. Shoot me some details and I would be extremely > > appreciative of your help. > > > > On Mar 12, 2:11 pm, Marco van den Oever <[email protected]> > > wrote: > > > > > Wel if you really don't want to use it i am not forcing you to do > > > so :) > > > But i am just curious if that would solve some issues, i don't know > > > for sure. > > > > > I am using vista business iis7, cf9, fc6. > > > > > I could check for the stuff i know and see if that is all setup ok. > > > > > On Mar 12, 7:39 pm, Activant <[email protected]> wrote: > > > > > > I am not using iis7. I don't even have that installed on my vista > > > > machine. So r u suggesting I go that route? > > > > > > On Mar 12, 11:12 am, Marco van den Oever <[email protected] > > > > > > wrote: > > > > > > > What happens when you try to set it up with iis7 in vista??? Just > to > > > > > check. > > > > > If you want i can try to assist you through msn request remote > > > > > assistance. > > > > > > > It all should work but these kind off things are hard to discus and > > > > > help with through email or threads :) > > > > > > > My IM is: [email protected] > > > > > > > On Mar 12, 5:45 pm, Activant <[email protected]> wrote: > > > > > > > > Ok. I decided to go with the subdirectory deployment. Thanks to > all > > > > > > for your assistance. > > > > > > > > On Mar 12, 9:25 am, Activant <[email protected]> wrote: > > > > > > > > > ok...am about ready to throw in the towel. Is there a way to > have > > > > > > > multiple projects using farcry w/o going through the advanced > > > > > > > deployment? I had no problems with the single subdirectory > deployment, > > > > > > > but now that I have chosen advanced, I am having issues as > previously > > > > > > > mentioned. I cannot find the solution. > > > > > > > > > On Mar 11, 1:54 pm, Activant <[email protected]> wrote: > > > > > > > > > > Still struggling with this. To repeat, everything seems to > install > > > > > > > > correctly, but when I browse to the site or webstop, it tells > me that > > > > > > > > no project exists and gives me a link to set one up even > though I have > > > > > > > > set one up. > > > > > > > > > > I am on Vista, using Apache (WAMP) with SQL Express and CF9 > > > > > > > > > > I put the farcry directory in my webroot. The project I setup > exists > > > > > > > > underneath the project folder. I also created a folder in > another part > > > > > > > > of the webroot that I am planning on redirecting to the > project/www > > > > > > > > directory. So visitors will go > towww.mysite.com/suchandsuch_folder...this > > > > > > > > will redirect to farcry/projects/suchandsuchproject/www/ > > > > > > > > > > I setup some aliases in my Apache (and I am no Apache expert > so I > > > > > > > > could have done this wrong) > > > > > > > > > > Alias /activant/eagle_customers "C:/Program > Files/wamp/www/farcry/ > > > > > > > > projects/eagle_customers/www" > > > > > > > > Alias farcry "C:/Program Files/wamp/www/farcry/core" > > > > > > > > Alias webtop "C:/Program > Files/wamp/www/farcry/core/webtop" > > > > > > > > > > So, basically, I cannot figure out why it is not recognizing > the > > > > > > > > project. Is it the farcryconstructor file or something else? > Thoughts? > > > > > > > > > > On Mar 8, 1:05 pm, Chris Kent <[email protected]> wrote: > > > > > > > > > > > I have been using the following for the Advanced Set up on > Windows > > > > > > > > > machines. > > > > > > > > > > > Using combinations of Windows Server 2003/XP/7, IIS6/7, > CF8/9, MySQL/ > > > > > > > > > MS SQL > > > > > > > > > > > Farcry code installed to x:\Applications\Farcry6 > > > > > > > > > > > So core code and projects are in > > > > > > > > > x:\Applications\Farcry6\farcry\core > > > > > > > > > x:\Applications\Farcry6\farcry\plugins > > > > > > > > > x:\Applications\Farcry6\farcry\projects > > > > > > > > > > > No CF Mappings required > > > > > > > > > > > IIS Settings > > > > > > > > > 1. I use individual Host names for each site and map > these to > > > > > > > > > localhost/127.0.0.1 in the > C:\Windows\System32\drivers\etc\hosts file > > > > > > > > > 2. FarCry Install Site, this will allow new sites to > be created > > > > > > > > > e.g. fcInstall > > > > > > > > > Home directory x:\\Applications\Farcry6 > > > > > > > > > 3. Each Farcry Site – after install > > > > > > > > > Home directory > x:\Applications\Farcry6\farcry\projects\projectname\www > > > > > > > > > Virtual Directory farcry mapped to > x:\Applications\Farcry6\farcry > > > > > > > > > Virtual Directory webtop mapped to > x:\Applications\Farcry6\farcry\core > > > > > > > > > \webtop > > > > > > > > > > > To install a new site, > > > > > > > > > 1. Create new database > > > > > > > > > 2. Create CF datasource > > > > > > > > > 3. in browser browse to fcInstall and follow > instructions > > > > > > > > > Create IIS site and virtual directories > > > > > > > > > > > This also allows me to have different versions of FarCry > core set up > > > > > > > > > for testing etc., e.g. set up a > x:\\Applications\Farcry6-0-1 folder, > > > > > > > > > subfolders and IIS settings and I can run 6 and 6.1 in > parallel on the > > > > > > > > > same server. > > > > > > > > > > > I do not use Apache, but it should not be too difficult to > set up > > > > > > > > > based on the IIS details above. > > > > > > > > > > > Chris. > > > > > > > > > > > On Mar 8, 6:51 pm, Activant <[email protected]> > wrote:> Thanks, Marco for your thoughts. I am new to the Apache world. I > just > > > > > > > > > > cannot figure out why it is telling me no projects have > been > > > > > > > > > > installed. > > > > > > > > > > > > On Mar 8, 12:41 pm, Marco van den Oever < > [email protected]> > > > > > > > > > > wrote: > > > > > > > > > > > > > What i provided above is for a advanced installation, > only it's local. > > > > > > > > > > > > > Now i have no apache setup / experience so i can't > grasp some > > > > > > > > > > > knoweledge about what might can be going on in the > apache part. > > > > > > > > > > > > > On Mar 8, 7:29 pm, Activant <[email protected]> > wrote: > > > > > > > > > > > > > > Yes...I did not need it for my singled directory > install. I am now > > > > > > > > > > > > attempting an advanced deployment and am struggling > with my web server > > > > > > > > > > > > mappings in Apache and the result is FarCry does not > see that I have > > > > > > > > > > > > any projects installed. > > > > > > > > > > > > > > On Mar 8, 12:13 pm, Tomek Kott <[email protected]> > wrote: > > > > > > > > > > > > > > > i think the reasons it is confusing is because "It > depends" on the > > > > > > > > > > > > > installation method. For a plain vanilla, single > project, install in webroot > > > > > > > > > > > > > kind of install, no mapping are needed. For more > interesting configurations, > > > > > > > > > > > > > different mappings might be necessary. That's how I > understand it. > > > > > > > > > > > > > > > Tomek > > > > > > > > > > > > > > > On Mon, Mar 8, 2010 at 12:55 PM, Malik Robinson < > [email protected]>wrote: > > > > > > > > > > > > > > > > I thought mappings weren't needed anymore? The > docs that I've seen seem to > > > > > > > > > > > > > > indicate that we should remove /farcry as a > mapping in CFAdmin. But it > > > > > > > > > > > > > > always seems like it's needed. I'm confused... > > > > > > > > > > > > > > > > On Mon, Mar 8, 2010 at 9:49 AM, Marco van den > Oever < > > > > > > > > > > > > > > [email protected]> wrote: > > > > > > > > > > > > > > > >> My project mappings exist of one alias name > without slashes etc, so > > > > > > > > > > > > > >> for example (i use iis): > > > > > > > > > > > > > > > >> alias: passionfood > > > > > > > > > > > > > >> path: > C:\inetpub\wwwroot\Farcry\projects\passionfood\www > > > > > > > > > > > > > > > >> Also i have mappings for Farcry: > > > > > > > > > > > > > > > >> alias: Farcry > > > > > > > > > > > > > >> path: C:\inetpub\wwwroot\Farcry > > > > > > > > > > > > > > > >> alias: webtop > > > > > > > > > > > > > >> path: C:\inetpub\wwwroot\farcry\core\webtop > > > > > > > > > > > > > > > >> This is a local setup on vista, cf8, iis7 > > > > > > > > > > > > > > > >> On Mar 8, 6:26 pm, Activant < > [email protected]> wrote: > > > > > > > > > > > > > >> > I followed the aforementioned link and > attempted to create the server > > > > > > > > > > > > > >> > mappings, but I am no expert at this and I am > still getting the no > > > > > > > > > > > > > >> > project issue. Here are my mappings... > > > > > > > > > > > > > > > >> > Alias /activant/eagle_customers > "C:/Program Files/wamp/www/farcry/ > > > > > > > > > > > > > >> > projects/eagle_customers/www" > > > > > > > > > > > > > >> > Alias /farcry/core "C:/Program > Files/wamp/www/farcry/core" > > > > > > > > > > > > > >> > Alias /farcry/core/webtop "C:/Program > Files/wamp/www/farcry/core/ > > > > > > > > > > > > > >> > webtop" > > > > > > > > > > > > > >> > Alias /farcry/plugins/farcryverity > "C:/Program Files/wamp/www/ > > > > > > > > > > > > > >> > farcry/plugins/farcryverity" > > > > > > > > > > > > > >> > Alias /farcry/projects/activant > "C:/Program Files/wamp/www/farcry/ > > > > > > > > > > > > > >> > projects/activant" > > > > > > > > > > > > > >> > Alias /farcry/projects/activant/www > "C:/Program Files/wamp/www/ > > > > > > > > > > > > > >> > farcry/projects/activant/www" > > > > > > > > > > > > > > > >> > Anyone have any thoughts? > > > > > > > > > > > > > > > >> > On Mar 6, 9:32 am, Tomek Kott < > [email protected]> wrote: > > > > > > > > > > > > > > > >> > > sorry, you may be right. This is the closest > i could find on mapping / > > > > > > > > > > > > > >> > > deployment info: > > > > > > > > > > > > > >> > http://docs.farcrycms.org/display/FCDEV50/Deployment+Configurations > > > > > > > > > > > > > > > >> > > On Fri, Mar 5, 2010 at 3:35 PM, Activant < > [email protected]> > > > > > > > > > > > > > >> wrote: > > > > > > > > > > > > > >> > > > also...I changed the project url... > > > > > > > > > > > > > > > >> > > > <cfset THIS.projectURL = > "/activant/eagle_customers" /> > > > > > > > > > > > > > > > >> > > > Here is my webtop url... > > > > > > > > > > > > > > > >> > > > <cfset THIS.webtopURL = "/webtop" > />...does this need to be /farcry/ > > > > > > > > > > > > > >> > > > webtop? > > > > > > > > > > > > > > > >> > > > As far as cf mapping. I thought that was > no longer required on 5.2? > > > > > > > > > > > > > > > >> > > > On Mar 5, 1:32 pm, Tomek Kott < > [email protected]> wrote: > > > > ... > > > > read more » > > -- > You received this message cos you are subscribed to "farcry-dev" Google > group. > To post, email: [email protected] > To unsubscribe, email: > [email protected]<farcry-dev%[email protected]> > For more options: http://groups.google.com/group/farcry-dev > -------------------------------- > Follow us on Twitter: http://twitter.com/farcry > > To unsubscribe from this group, send email to farcry-dev+ > unsubscribegooglegroups.com or reply to this email with the words "REMOVE > ME" as the subject. > -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry To unsubscribe from this group, send email to farcry-dev+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
