Subject | Re: [firebird-support] Re: Failing to create Firebird DB file |
---|---|
Author | Ivan Grozny |
Post date | 2006-11-29T18:21:40Z |
Yuliya -
That's how I set things on all the machines I take care of - if apps are correctly written, they should check before creating temp files to avoid filename collisions (or, if they can't handle that, generally they should ignore the TEMP variable and create tempfiles in their own private subfolder). Microsoft's default setup of having individual TEMP directories for each user does not, in my experience, avoid any problems; it simply makes it incredibly cumbersome to keep the disk from filling up with junk. If you stash all the temp files in one place, it's easy to clean them up once in a while. (You could do it if they were scattered, too, but somehow nobody ever does.)
I believe what he meant by the TEMP being set correctly is: does the directory it points to actually exist? If, as in your case, TEMP=C:\TEMP, then C:\TEMP had better exist and be a valid directory... otherwise, all bets are off as to where apps will create their temp files. (Personally, I always check to make sure that the folder exists, and fall back to creating my tempfiles in a subfolder of my app's folder, but not everyone does.)
----- Original Message ----
From: Yuliya Shulman <yuliyashulman@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, November 29, 2006 9:39:17 AM
Subject: RE: [firebird-support] Re: Failing to create Firebird DB file
TEMP=C:\TEMP
TMP=C:\TEMP
TMPDIR=C:/TEMP
That's not what TEMP should be set to, is it? I
thought it was usuallt set to C:\DOCUME~1\ <user
name>\LOCALS~ 1\Temp, but I'll admit I haven't given it
much thought.
What should it be set to for Firebird to work
properly?
Yuliya
--- Alan McDonald <alan@.... au> wrote:
#ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;
}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;
}
#ygrp-vitnav{
padding-top:10px;
font-family:Verdana;
font-size:77%;
margin:0;
}
#ygrp-vitnav a{
padding:0 1px;
}
#ygrp-actbar{
clear:both;
margin:25px 0;
white-space:nowrap;
color:#666;
text-align:right;
}
#ygrp-actbar .left{
float:left;
white-space:nowrap;
}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;
font-size:77%;
padding:15px 0;
}
#ygrp-ft{
font-family:verdana;
font-size:77%;
border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;
}
#ygrp-vital{
background-color:#e0ecee;
margin-bottom:20px;
padding:2px 0 8px 8px;
}
#ygrp-vital #vithd{
font-size:77%;
font-family:Verdana;
font-weight:bold;
color:#333;
text-transform:uppercase;
}
#ygrp-vital ul{
padding:0;
margin:2px 0;
}
#ygrp-vital ul li{
list-style-type:none;
clear:both;
border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;
color:#ff7900;
float:right;
width:2em;
text-align:right;
padding-right:.5em;
}
#ygrp-vital ul li .cat{
font-weight:bold;
}
#ygrp-vital a {
text-decoration:none;
}
#ygrp-vital a:hover{
text-decoration:underline;
}
#ygrp-sponsor #hd{
color:#999;
font-size:77%;
}
#ygrp-sponsor #ov{
padding:6px 13px;
background-color:#e0ecee;
margin-bottom:20px;
}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;
margin:0;
}
#ygrp-sponsor #ov li{
list-style-type:square;
padding:6px 0;
font-size:77%;
}
#ygrp-sponsor #ov li a{
text-decoration:none;
font-size:130%;
}
#ygrp-sponsor #nc {
background-color:#eee;
margin-bottom:20px;
padding:0 8px;
}
#ygrp-sponsor .ad{
padding:8px 0;
}
#ygrp-sponsor .ad #hd1{
font-family:Arial;
font-weight:bold;
color:#628c2a;
font-size:100%;
line-height:122%;
}
#ygrp-sponsor .ad a{
text-decoration:none;
}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;
}
#ygrp-sponsor .ad p{
margin:0;
}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;
}
#ygrp-text tt{
font-size:120%;
}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
[Non-text portions of this message have been removed]
That's how I set things on all the machines I take care of - if apps are correctly written, they should check before creating temp files to avoid filename collisions (or, if they can't handle that, generally they should ignore the TEMP variable and create tempfiles in their own private subfolder). Microsoft's default setup of having individual TEMP directories for each user does not, in my experience, avoid any problems; it simply makes it incredibly cumbersome to keep the disk from filling up with junk. If you stash all the temp files in one place, it's easy to clean them up once in a while. (You could do it if they were scattered, too, but somehow nobody ever does.)
I believe what he meant by the TEMP being set correctly is: does the directory it points to actually exist? If, as in your case, TEMP=C:\TEMP, then C:\TEMP had better exist and be a valid directory... otherwise, all bets are off as to where apps will create their temp files. (Personally, I always check to make sure that the folder exists, and fall back to creating my tempfiles in a subfolder of my app's folder, but not everyone does.)
----- Original Message ----
From: Yuliya Shulman <yuliyashulman@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, November 29, 2006 9:39:17 AM
Subject: RE: [firebird-support] Re: Failing to create Firebird DB file
TEMP=C:\TEMP
TMP=C:\TEMP
TMPDIR=C:/TEMP
That's not what TEMP should be set to, is it? I
thought it was usuallt set to C:\DOCUME~1\ <user
name>\LOCALS~ 1\Temp, but I'll admit I haven't given it
much thought.
What should it be set to for Firebird to work
properly?
Yuliya
--- Alan McDonald <alan@.... au> wrote:
> if you issue SET a the prompt - what do you see? is<!--
> the temp variable set
> incorrectly?
> Alan
>
>
>
#ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;
}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;
}
#ygrp-vitnav{
padding-top:10px;
font-family:Verdana;
font-size:77%;
margin:0;
}
#ygrp-vitnav a{
padding:0 1px;
}
#ygrp-actbar{
clear:both;
margin:25px 0;
white-space:nowrap;
color:#666;
text-align:right;
}
#ygrp-actbar .left{
float:left;
white-space:nowrap;
}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;
font-size:77%;
padding:15px 0;
}
#ygrp-ft{
font-family:verdana;
font-size:77%;
border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;
}
#ygrp-vital{
background-color:#e0ecee;
margin-bottom:20px;
padding:2px 0 8px 8px;
}
#ygrp-vital #vithd{
font-size:77%;
font-family:Verdana;
font-weight:bold;
color:#333;
text-transform:uppercase;
}
#ygrp-vital ul{
padding:0;
margin:2px 0;
}
#ygrp-vital ul li{
list-style-type:none;
clear:both;
border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;
color:#ff7900;
float:right;
width:2em;
text-align:right;
padding-right:.5em;
}
#ygrp-vital ul li .cat{
font-weight:bold;
}
#ygrp-vital a {
text-decoration:none;
}
#ygrp-vital a:hover{
text-decoration:underline;
}
#ygrp-sponsor #hd{
color:#999;
font-size:77%;
}
#ygrp-sponsor #ov{
padding:6px 13px;
background-color:#e0ecee;
margin-bottom:20px;
}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;
margin:0;
}
#ygrp-sponsor #ov li{
list-style-type:square;
padding:6px 0;
font-size:77%;
}
#ygrp-sponsor #ov li a{
text-decoration:none;
font-size:130%;
}
#ygrp-sponsor #nc {
background-color:#eee;
margin-bottom:20px;
padding:0 8px;
}
#ygrp-sponsor .ad{
padding:8px 0;
}
#ygrp-sponsor .ad #hd1{
font-family:Arial;
font-weight:bold;
color:#628c2a;
font-size:100%;
line-height:122%;
}
#ygrp-sponsor .ad a{
text-decoration:none;
}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;
}
#ygrp-sponsor .ad p{
margin:0;
}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;
}
#ygrp-text tt{
font-size:120%;
}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
[Non-text portions of this message have been removed]